Author: Oscar Cronquist Article last updated on February 01, 2023

 

Most Excel charts consist of an x-axis and a y-axis, Excel allows you to easily change the looks of the chart axis.

The chart below is what Excel returns using a few random values as a data source, there are, however, no axis lines.

I have drawn a blue rectangle surrounding each group of axis values in the chart above.

To make it easier to see the changes I am about to do, I am now going to remove the major horizontal grid lines.

Simply press with left mouse button on the gridlines and press delete on your keyboard to remove them.

1. Font size of axis values

To change the font size of the axis values select the axis you want to change.

Go to tab "Home" on the ribbon then press with left mouse button on font size.

I chose font size 16.

Tip! If you want to quickly format the y-axis with the same font size, follow these steps.

  1. Select the x-axis.
  2. Go to tab "Home" on the ribbon.
  3. Press with mouse on "Format Painter" button.
  4. Press with mouse on y-axis.

Both chart axis now have the same font size, this technique can be used on many different Excel objects, not only charts.

Back to top

2. Axis value font type

  1. Press with mouse on the axis values you want to change.
  2. Go to tab "Home" on the ribbon.
  3. Press with mouse on font.
  4. Select a font.

Back to top

3. Axis value font color

  1. Select axis values
  2. Press with mouse on font color button.
  3. Pick a font color.

Back to top

4. Customize axis line

  1. Press with right mouse button on on x-axis values.
  2. Press with mouse on "Format Axis..."
  3. Press with mouse on the "Fill and Line" button.
  4. Press with mouse on Line to expand the Line settings
  5. Now you can change the color of the axis line, thickness, dashed or dotted and so on.

I exaggerated the axis line thickness and changed the color black to make it stand out.

Back to top

 

5. Axis line position

  1. To change the position of the x-axis you must press with right mouse button on on the y-axis and vice versa.
  2. Press with mouse on "Format Axis..."
  3. Press with mouse on the "Axis Options" button.
  4. Find Horizontal Axis crosses and select Axis value.
  5. Change it to the value on the y-axis you want the x-axis to cross, or vice versa.

Back to top

6. Add axis title text

The chart above has no descriptive titles, follow these simple steps to add chart axis titles.

  1. Select chart.
  2. Go to tab "Design" on the ribbon. The tab will appear as soon as you select the chart.
  3. Press with mouse on "Add Chart Element".
  4. Press with left mouse button on "Axis Titles".
  5. Press with mouse on "Primary Horizontal" or "Primary Vertical"

Back to top