How to customize chart axis
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.
Table of Contents
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.
- Select the x-axis.
- Go to tab "Home" on the ribbon.
- Press with mouse on "Format Painter" button.
- 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.
2. Axis value font type
- Press with mouse on the axis values you want to change.
- Go to tab "Home" on the ribbon.
- Press with mouse on font.
- Select a font.
3. Axis value font color
4. Customize axis line
- Press with right mouse button on on x-axis values.
- Press with mouse on "Format Axis..."
- Press with mouse on the "Fill and Line" button.
- Press with mouse on Line to expand the Line settings
- 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.
5. Axis line position
- To change the position of the x-axis you must press with right mouse button on on the y-axis and vice versa.
- Press with mouse on "Format Axis..."
- Press with mouse on the "Axis Options" button.
- Find Horizontal Axis crosses and select Axis value.
- Change it to the value on the y-axis you want the x-axis to cross, or vice versa.
6. Add axis title text
The chart above has no descriptive titles, follow these simple steps to add chart axis titles.
Chart elements category
Charts in Microsoft Excel lets you visualize, analyze and explain data. Charting in Excel is very easy and you […]
Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of […]
Excel lets you easily add a best-fit curved logarithmic trendline calculated based on the method of least squares. How to […]
A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values […]
The image above demonstrates data labels in a line chart, each data point in the chart series has a visible […]
Chart gridlines are great for making the chart data more readable and detailed, Excel allows you to add major and […]
Enable error bars when you want to show, for example, standard deviations in a chart, Excel lets you insert error […]
To change the looks of a data series simply double-press with left mouse button on with left mouse button on […]
The x-axis and y-axis titles are just as easy to format and customize as the other chart elements. How to […]
The image above shows tick mars in a line chart, there are two types of tick marks, major and minor […]
The chart area contains all components. If you choose to format the chart area you can change things like border, […]
You can easily customize the font, font size, font color etc of the chart legend: Select legend. Go to tab […]
I recommend that the chart title is short and easy to understand. How to add a chart title Follow these […]
The plot area refers to the location of the chart that displays the actual data represented by lines, bars, columns, […]
The image above demonstrates a line chart containing two data series and two y-axes, one for each data series. I […]
Excel categories
One Response to “How to customize chart axis”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Nice! But how do you format the background color of the y axis based on value settings? For example, 0 to 80% is green, 81 to 90% is yellow, the rest is red. Thank you.