Charts in Excel: Axes

• Axis type
• Axis titles
• Axis scaling

Most chart types have two axes: a horizontal axis (or X-axis) and a vertical axis (or Y-axis). This example will teach you how to change the axis type, add axis titles, and change the scale of the vertical axis.

To create a histogram, follow these steps:

1. Highlight a range A1: B7.
2. On the Advanced tab Вrate (Insert) section Diagrams (Charts) click bar chart > Histogram with grouping (Column > Clustered Column).

Axis type

In the figure below, you can see that Excel shows unnecessary dates between 24.08.2013/01.09.2013/XNUMX and XNUMX/XNUMX/XNUMX. To remove these dates, change the axis type from date axis to text axis. For this:

1. Right click on the horizontal axis and select Axis Format (Format Axis).
2. Put a marker in front of the parameter Here is the text (Text axis).
3. Нажмите кнопку Close (Close).

Result:

Axis titles

To add a horizontal or vertical axis title, do the following:

1. Select a chart. Tab group activated Working with charts (Chart Tools).
2. On the Advanced tab Layout (Layout) click the button Axis names (Axis Titles).
3. Click on the button Name of the main vertical axis > Rotated title (Primary Vertical Axis Title > Rotated Title).
4. Enter a name for the vertical axis. For example, “Visitors”.

Result:

Axis scaling

By default, Excel automatically determines the values ​​on the vertical axis. To change these values, follow the instructions below:

1. Right-click on the vertical axis and from the context menu select the command Axis Format (Format Axis).
2. In line Maximum value (Maximum) put a marker in front of the parameter fixed (Fixed).
3. Enter the value “12000”.
4. Нажмите кнопку Close (Close).

Result: