Change the scale of the horizontal (category) axis in a chart

Piezīme.:  Mēs vēlamies sniegt jums visjaunāko palīdzības saturu jūsu valodā, cik vien ātri to varam. Šī lapa ir tulkota automatizēti, un tajā var būt gramatiskas kļūdas un neprecizitātes. Mūsu nolūks ir šo saturu padarīt jums noderīgu. Vai lapas lejasdaļā varat mums pavēstīt, vai informācija jums noderēja? Ērtai atsaucei šeit ir šis raksts angļu valodā .

The horizontal (category) ass, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) axis, also known as the y axis, of the chart.

However, you can specify the following axis options:

  • Interval between tick marks and labels

  • Placement of labels

  • Order in which categories are displayed

  • Axis type (date or text axis)

  • Placement of tick marks

  • Point where the horizontal axis crosses the vertical axis

To change the scale of other axes in a chart, see Change the scale of the vertical (value) axis in a chart or Change the scale of the depth (series) axis in a chart.

  1. In a chart, click to select the category axis that you want to change, or do the following to select the axis from a list of chart elements:

    1. Noklikšķiniet jebkurā vietā diagrammā.

      This displays the Chart Tools, adding the Design and Format tabs.

    2. On the Format tab, in the Current Selection group, click the arrow in the box at the top, and then click Horizontal (Category) Axis.

  2. Cilnes Formāts grupā Pašreizējā atlase noklikšķiniet uz Formatēt atlasi.

  3. In the Format Axis pane, do any of the following:

    Svarīgi!: The following scaling options are available only when a category axis is selected.

    • To reverse the order of categories, expand Axis Options, and then select the Categories in reverse order check box.

    • To change the axis type to a text or date axis, expand Axis Options, and then under Axis Type, select Text axis or Date axis. Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units.

      Piezīme.: Selected by default, Automatically select based on data determines the axis type that makes the most sense for your type of data.

    • To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis.

    • To change the interval between tick marks, expand Tick Marks, and then in the Interval between tick marks box, type the number that you want.

      Piezīme.: The number that you type determines how many categories are displayed between the tick marks.

    • To change the placement of the axis tick marks, expand Tick Marks, and then select any of the options that you want in the Major type and Minor type boxes.

    • To change the interval between axis labels, expand Labels, and then under Interval between labels, select Specify interval unit and type the number you want in the text box.

      Padoms.: Type 1 to display a label for every category, 2 to display a label for every other category, 3 to display a label for every third category, and so on.

    • To change the placement of axis labels, expand Labels, and then in the Distance from axis box, type the number that you want.

      Padoms.: Type a smaller number to place the labels closer to the axis. Type a larger number if you want more distance between the label and the axis.

  1. In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements:

    1. Noklikšķiniet jebkurā vietā diagrammā.

      Tiek parādīta kontekstcilne Diagrammu rīki, kurā ir pievienotas cilnes Noformējums, Izkārtojums un Formāts.

    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis.

      Lentes attēls

  2. Cilnes Formāts grupā Pašreizējā atlase noklikšķiniet uz Formatēt atlasi.

  3. In the Format Axis dialog box, under Axis Options, do one or more of the following:

    Svarīgi!: The following scaling options are available only when a category axis is selected.

    • To change the interval between tick marks, in the Interval between tick marks box, type the number that you want.

      Piezīme.: The number that you type determines how many categories are displayed between the tick marks.

    • Lai mainītu intervālu starp ass etiķetēm, sadaļā Intervāls starp etiķetēm, noklikšķiniet uz Norādīt intervāla vienību un pēc tam tekstlodziņā ierakstiet vēlamo skaitli.

      Padoms.: Type 1 to display a label for every category, 2 to display a label for every other category, 3 to display a label for every third category, and so on.

    • Lai mainītu ass etiķešu novietojumu, lodziņā Uzlīmju attālums no ass ierakstiet vēlamo skaitli numuru.

      Padoms.: Type a smaller number to place the labels closer to the axis. Type a larger number if you want more distance between the label and the axis.

    • To reverse the order of categories, select the Categories in reverse order check box.

    • To change the axis type to a text or date axis, under Axis Type, click Text axis or Date axis. Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units.

      Piezīme.: Selected by default, Automatically select based on data determines the axis type that makes the most sense for your type of data.

    • To change the placement of the axis tick marks and labels, select any of the options that you want in the Major tick mark type, Minor tick mark type, and Axis labels boxes.

    • To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, under Vertical axis crosses, click At category number, and then type the number that you want in the text box, or click At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis.

Padomi.: 

  • After changing the scale of the axis, you may also want to change the way that the axis is formatted. For more information, see Change the display of chart axes.

  • Scaling does not change the series overlap or gap width between data series. To change the series overlap or gap width, right-click a data series, and then click Format Data Series. Under Series Options, specify the settings that you want.

By default, the minimum and maximum scale values of each axis in a chart are calculated automatically. However, you can customize the scale to better meet your needs. For example, if all the data points in your data table are between 60 and 90, you might want the value (y) axis to have a range of 50 to 100 instead of 0 to 100. When a value axis covers a very large range, you can also change the axis to a logarithmic scale (also known as log scale).

  1. Šī darbība attiecas tikai uz Word 2016 darbam ar Mac. Cilnes Skats izvēlnē noklikšķiniet uz Drukas izkārtojums.

  2. Noklikšķiniet uz diagrammas.

  3. On the Format tab, click Horizontal (Category) Axis in the dropdown list and then click Format Pane.

  4. In the Format Axis pane, do any of the following:

    Svarīgi!: The following scaling options are available only when a category axis is selected.

    • To reverse the order of categories, expand Axis Options, and then select the Categories in reverse order check box.

    • To change the axis type to a text or date axis, expand Axis Options, and then under Axis Type, select Text axis or Date axis. Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units.

      Piezīme.: Selected by default, Automatically select based on data determines the axis type that makes the most sense for your type of data.

    • To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis.

    • To change the interval between tick marks, expand Tick Marks, and then in the Interval between tick marks box, type the number that you want.

      Piezīme.: The number that you type determines how many categories are displayed between the tick marks.

    • To change the placement of the axis tick marks, expand Tick Marks, and then select any of the options that you want in the Major type and Minor type boxes.

    • To change the interval between axis labels, expand Labels, and then under Interval between labels, select Specify interval unit and type the number you want in the text box.

      Padoms.: Type 1 to display a label for every category, 2 to display a label for every other category, 3 to display a label for every third category, and so on.

    • To change the placement of axis labels, expand Labels, and then in the Distance from axis box, type the number that you want.

      Padoms.: Type a smaller number to place the labels closer to the axis. Type a larger number if you want more distance between the label and the axis.

    • To position the label, expand Labels, and select an option in the dropdown list box.

By default, the minimum and maximum scale values of each axis in a chart are calculated automatically. However, you can customize the scale to better meet your needs. For example, if all the data points in your data table are between 60 and 90, you might want the value (y) axis to have a range of 50 to 100 instead of 0 to 100. When a value axis covers a very large range, you can also change the axis to a logarithmic scale (also known as log scale).

  1. Šī darbība attiecas tikai uz Word for Mac 2011. Cilnes Skats izvēlnē noklikšķiniet uz Drukas izkārtojums.

  2. Noklikšķiniet uz diagrammas un pēc tam noklikšķiniet uz cilnes Diagrammas izkārtojums.

  3. Under Axes, click Axes > Horizontal Axis > Axis Options.

    Chart Layout tab, Axes group

    Piezīme.: Depending on the chart type, some options may not be available.

  4. In the Format Axis dialog box, click Scale, and under Horizontal axis scale, modify any of the following options:

    • To change the interval between axis labels, in Interval between labels, type the number you want.

    • To change the interval between tick marks, in Interval between tick marks, type the number you want.

    • Lai mainītu ass etiķešu novietojumu, lodziņā Uzlīmju attālums no ass ierakstiet vēlamo skaitli numuru.

      Padoms.: Type a smaller number to place the labels closer to the axis. Type a larger number if you want more distance between the label and the axis.

    • To reverse the order of categories, select the Categories in reverse order check box.

  5. Noklikšķiniet uz Labi.

Add or change the position of horizontal axis labels

For a horizontal axis, you can add and position the axis on the left side or the right side of the plot area.

Piezīme.: The options may be reversed for bar compared column charts.

  1. This step applies to Word for Mac 2011 only: On the View menu, click Print Layout.

  2. Noklikšķiniet uz diagrammas un pēc tam noklikšķiniet uz cilnes Diagrammas izkārtojums.

  3. Under Axes, click Axes > Horizontal Axis, and then click the kind of axis label that you want.

    Chart Layout tab, Axes group

    Piezīme.: Depending on the chart type, some options may not be available.

Paplašiniet savas Office prasmes
Iepazīties ar apmācību
Esiet pirmais, kas saņem jaunās iespējas
Pievienoties Office Insider programmai

Vai šī informācija bija noderīga?

Paldies par jūsu atsauksmēm!

Paldies par atsauksmēm! Šķiet, ka varētu būt noderīgi sazināties ar kādu no mūsu Office atbalsta aģentiem.

×