When you create a chart, tick marks and tick marks (tick marks are small unit labels that cross an axis and look like ruler ticks. Tick labels identify categories, values, and series on a chart.) appear on the axes by default. The way they are displayed can be customized using major and intermediate divisions and division labels. To avoid cluttering a chart, you can display fewer tick marks and labels on the horizontal axis (category axis) by specifying the intervals at which you want to add category labels, or by specifying the number of categories to display between tick marks.
You can also change the alignment and orientation of labels, and change or format the text and numbers that appear in them, such as displaying numbers as percentages.
Showing and hiding axes
Click the chart on which you want to show or hide the axes.
The funds will be displayed Working with charts, including tabs Constructor, Layout And Format.
On the tab Layout in the group Axles(Figure 4) press the button Axles.
Figure 4. Group Axles
To display an axis, highlight the type of axis you want to display, and then select one of the options that corresponds to the axis to display.
To hide an axis, select the type of axis you want to hide and then select the option No.
Setting axis tick marks and labels
On a chart, click the axis for which you want to customize tick marks or tick labels, or follow these steps to select an axis from the list of chart elements.
On the tab Format in the group Current fragment click the arrow next to the field Chart area, and then click the axis you want to select.
Open the page Axis parameters if it is not already open, and then do one or more of the following:
to change the display of the main divisions, in the field Basic
to change the display of auxiliary tick marks in the drop-down list Intermediate select the desired division position;
to change the position of the division labels in the field Axis labels select the desired option.
You can hide tick marks or tick labels by selecting the option No.
Changing the number of categories between labels and divisions
On a chart, click the horizontal axis (category axis) that you want to change, or follow these steps to select an axis from the list of chart elements.
Open the page Axis parameters, if it is not already open, and then do the following as you choose. To change the spacing between axis labels, see Interval between signatures select an option Specify the interval unit, and then enter the desired number in the text field. To display captions for each category, enter a value of 1, to display them through one category, enter 2, for every third category - 3, etc.
To change the placement of axis labels, in the Signature distance from axis enter the required number.
To place the labels closer to the axis, enter a lower value. Enter a larger value if you want the distance between the label and the axis to be greater.
Change the alignment and orientation of labels
You can change the alignment of axis labels on both the horizontal axis (category axis) and the vertical axis (value axis). If there are multi-level category labels in the chart (category labels on the chart, displayed as a structure depending on the data in the cells on the sheet. For example, the heading “Students” can be displayed above the line with the headings “EP-11d”, “EP-12d”) You can change the alignment of all label levels. You can also change the distance between label levels on the horizontal axis (category axis).
On a chart, click the axis that contains the labels for which you want to apply a different alignment, or follow these steps to select an axis from the list of chart elements.
Select the desired axis. On the tab Alignment in the area Text Format select the desired position in the field Vertical alignment.
To change the text orientation, select the desired position in the box Text direction.
To quickly change the horizontal alignment of selected axis labels, click the axis right click mouse, and then on the mini toolbar, click Align Left ,Centered or Align Right .
Good afternoon.
When creating graphs based on Excel tables, the program automatically calculates the values and builds a graph based on these calculations, but there is a possibility that the automatically created graph will be inconvenient or unpresentable. To correct its appearance, you simply need to swap the axes: set the X axis vertically and the Y horizontally.
How to build a graph and change axes?
For example, let's take a table with a sales schedule for a pet store. The names of animals are written vertically, months of sales horizontally.
Let's build a graph. To do this, select the table with the left mouse button. In the insert tab, select “insert graph”. After clicking on the “Graph” icon, a window with a graph will appear on the sheet. 
But the window with the graph does not look presentable, since the names of the animals are located horizontally, and the months are simply written as the names of the graphs. It is impossible to track the dynamics of sales for each type of product from the graph. 
To change the graph view and swap the axes, follow these steps:
Most chart types allow you to hide or show axes. To make your chart data easier to understand, you can also change its appearance.
Important: This article does not cover changing the scale of chart axes. For information about changing the scale, see the following articles:
More about axes
Charts typically have two axes that measure and organize data: a vertical (value axis or y-axis) and a horizontal (category axis or x-axis). 3D histograms, 3D cone charts, and pyramid charts have a third axis, the depth axis (row axis or z axis), so that data can be plotted to the depth of the chart. Radar charts have no horizontal (category) axes, and pie and donut charts have no axes at all.
Vertical axis (values)
Horizontal axis (categories)
Depth axis (data series)
Here's what you can do with your charts to make them look more impressive and convey information better. More information For information about what axes are and what you can do with them, see the section.
Showing and hiding axes
Setting axis tick marks and labels
Changing the number of categories between labels and divisions
Change the alignment and orientation of labels
Advice Can be changed horizontal alignment axis labels by clicking the axis and selecting from the toolbar Home option Align Left , Align Center or Align Right .
Changing the text of category labels
Note
Changing the appearance of text and numbers in captions
Formatting text
On the toolbar Home select the type of formatting you need.
Advice Home in the group Font.
Formatting numbers
Note quantity / total = percentage 10 / 100 = 0,1 and then format 0,1 10 % .
Change the appearance of chart axes in Office 2010
Show or hide axes (Office 2010)
Set tick marks and axis labels (Office 2010)
Change the number of categories between labels and tick marks (Office 2010)
Change the alignment and orientation of labels (Office 2010)
The alignment of labels can be changed on both the horizontal (category) and vertical (values) axis. If your chart has multi-level category labels, you can change the alignment of each level of labels. You can also change the distance between label levels on the horizontal (category) axis.
Advice To change the horizontal alignment of an axis label, right-click the axis and mini toolbars select Left , Centered or Right .
Change the text of category labels (Office 2010)
You can change the text of category labels on the sheet or directly on the chart.
Change the text of a category label on a sheet
On the worksheet, click the cell with the signature text that you want to change.
Enter new text and press ENTER.
Note. After you make changes to the sheet, the chart is automatically updated.
Changing the caption text on a chart
Change the appearance of text and numbers in captions (Office 2010)
You can change the format of the label text on the category axis or the numbers on the value axis.
Formatting text
In the chart, right-click the axis with the labels you want to format.
On mini toolbars Select the formatting options you want.
Advice You can also select an axis with labels and then use the formatting buttons on the tab Home in the group Font.
Formatting numbers
Note. Before you format numbers as percentages, make sure that the numbers shown in the chart were calculated as percentages in the source data and are displayed in decimal format. Percentages are calculated in the worksheet using the expression quantity / total = percentage. For example, if you calculate the value 10 / 100 = 0,1 and then format 0,1 As a percentage, the number should be displayed as follows: 10 % .
Add tick marks to an axis
The axis can be formatted to display major and minor tick marks at selected intervals.
This action applies to Word for Mac only: in the menu view select item Page layout.
Click the chart and open the tab Constructor.
Click the button Add a chart element > axes > Additional Axis Options.
On the panel Axis format expand the element divisions and select Options for major and minor tick types.
After you add tick marks, you can change the spacing between tick marks by changing the value in the field character spacing .
All about axes
On the charts different types axes may be displayed differently. For example, in scatter (xy) and bubble charts numeric values displayed on both the horizontal and vertical axis. An example would be displaying the amount (inches) of precipitation relative to barometric pressure. Both elements have numerical values, and data points are plotted on the x and y axes relative to those values. There are many options available for value axes, such as setting the scale to logarithmic.
Other types of charts, such as histograms, graphs, and area charts, display numeric values only on the vertical (value) axis and text classifications (or categories) on the horizontal axis. An example would be to display the amount (inches) of precipitation by geographic area. In this example, geographic areas are text categories of data that are displayed on the horizontal (category) axis. Geographic areas that represent text are spaced evenly, unlike values that can be measured. Keep this distinction in mind when choosing a chart type, since the capabilities for value and category axes differ. In such cases, the depth (series) axis is another kind of category axis.
When you create a chart, the axes display tick marks and labels by default. The way they are displayed can be customized using main and intermediate divisions and labels. To avoid cluttering a chart, you can display fewer labels or tick marks on the horizontal axis (categories) by specifying spacing for labeling categories or the number of categories displayed between tick marks.
You can also change the alignment and orientation of labels, or the display format of text and numbers (for example, to display numbers as percentages).
Note: This page has been automatically translated and may contain inaccuracies and grammatical errors. It is important to us that this article is useful to you. Was the information useful? For convenience also (in English).
If you want to change the axes in a chart in Excel to highlight your data under a different aspect, you do not need programming knowledge. On the contrary, you are only a couple of clicks away from the desired image.
Replacing chart axes in Excel versions prior to 2003
Select your chart and call “Data Generator” through the “Diagram” menu item, which appears after selecting it in the menu bar. Alternatively, you can right-click on the border area of the diagram and select this command from the context menu.
The Data Generator window appears. On the "Data Field" tab you can see preview chart and then at the bottom the "Series in:" command with the "Rows" and "Columns" options. Click on "Strings" and see a preview. Excel changed the axes and automatically coordinated the explanation entries. By clicking on OK you confirm new look presentations.
From Excel 2007: replacing x and y axes
This is even easier in newer versions of Excel. Once you select a chart, the three chart utility tabs in the menu area automatically open. On the Structure tab, in the Data group, click the Replace Row/Column command to replace the axes. We recommend replacing the columns and rows of the original table.
If the appearance of the chart after changing the axes does not correspond to your ideas, as an alternative you can also first change the columns to rows in your table of values. To do this, select the table and copy it. (Important: This does not work with the "Cut" command!).
Click a cell in another area of your spreadsheet and select the Move command next to or under the Insert button. Column values appear in columns, and column values appear in rows. Compose your Excel chart in your new table. Everything should work out.
The chart's horizontal axis, also called the category axis and x-axis, displays text labels instead of numeric intervals; In addition, it supports fewer zoom options than the chart's vertical axis (the value axis, or y-axis).
However, you can set the following axis parameters:
Spacing between tick marks and labels.
Location of signatures.
Axis type (dates or text).
Location of divisions.
The point of intersection of the horizontal and vertical axes.
To change the scales of other axes, see Change the scale of the vertical axis (values) in a chart or Change the scale of the depth axis (data series) in a chart.
Click anywhere on the chart.
A tab will open Working with charts with additional tabs Constructor And Format.
On the tab Format in the group Current fragment Click the arrow in the box at the top and select .
Axis parameters and check the box categories in reverse order.
Axis parameters and select text axis or date axis in the field Axle type
Note:
Axis parametersintersect the vertical axis, install in room category in the maximum category
By divisions spacing between marks.
Note:
By divisions main And additional type.
signatures and then in the section spacing between signatures select Interval unit
Advice: Enter 1 2 3
stickers distance from axis.
Advice:
On the chart, select the category axes you want to change, or do the following to select it from the list of chart elements:
On the tab Format in the group Current fragment click the button Selection Format.
In the area Axis format
Important:
Change the scale of the horizontal axis (categories) in a chart (Office 2010)
Adviсe:
By default, the scale is minimum and maximum values Each axis on the chart is calculated automatically. However, you can adjust the scale to better suit your needs. For example, if all data points in a data table are between 60 and 90, you can change the value (y) axis to have a range of 50 to 100 instead of 0 to 100. When the value axis covers a very large range, you can also change the logarithmic scale (also known as log scale) of the axis .
To change the order of categories, expand Axis parameters and check the box categories in reverse order.
To change the axis type to text or date axis, expand Axis parameters and select text axis or date axis in the field Axle type. Text and data points are spaced evenly on the text axis. The date axis displays dates in chronological order in specified time intervals or base units, such as number of days, months, or years, even if the dates on the worksheet are not ordered or in the same base units.
Note: Default value Automatically select based on data defines the type of axis that in the best possible way suitable for the selected data type.
To change the points where you want the vertical axis (values) to cross the horizontal axis (categories), expand Axis parametersintersect the vertical axis, install in room category and enter the desired number in the text field or select in the maximum category indicate that the vertical axis (values) crosses the horizontal axis (categories) after the last category on the horizontal axis.
To change the interval between tick marks, expand By divisions and enter the number you want in the dialog box spacing between marks.
Note: This number determines the number of categories that are displayed between the tick marks.
To change the position of the axis tick marks, expand By divisions and select the parameters that should be in the fields main And additional type.
To change the spacing between axis labels, expand signatures and then in the section spacing between signatures select Interval unit and enter the number required in the text box.
Advice: Enter 1 to display a caption for each category, 2 to display a caption for every second category, 3 to display a caption for every third category, etc.
To change the location of the axis labels, expand stickers and enter the number you want in the field distance from axis.
Advice: To position the labels closer to the axis, enter a lower number. To increase the distance between the label and the axis, enter a larger number.
To change the location of the label, expand marks and select one of the options from the drop-down list.
This action applies in Microsoft Word for Mac only: In the menu View select item Page layout.
Click the chart.
On the tab Format click the button horizontal axis (categories) in the drop-down list and click the button Format area.
In the area Axis format Do one of the following:
Important: These zoom options are only available when the category axis is selected.
