Home Β» Charts

Format Chart Axis in Excel – Axis Options: Effects

In this blog, we will be formatting the chart axis effects by taking an example of a Line Chart in Excel. In a line chart, the data series is represented by a line that may or may not be contiguous. There can be two horizontal and two vertical axes on the chart i.e primary and secondary. We will consider only the primary horizontal and primary vertical axis for this example.

Here we go 😎

What is Meant by Formatting Chart Axis in Excel

Formatting the excel cells includes font size, font color, fill color while formatting a chart axis is slightly different. Although there are a lot of formatting options for a chart axis, in this blog we will edit the effects used for the chart axis.

Moving Step Wise

There are the steps we made for you to follow.

Inserting a Line Chart in Excel

If we want to format a chart axis, we must make a chart first. Let us take an example where we have the website visitors of a business for 2020 and 2021 month wise. Below is the data.

inserting a line chart raw data

We have inserted a line chart for the above data by first selecting it and then Line Chart> Recommended Charts > Charts group > Insert Tab.

inserting a line chart in excel

As a result, we have got a line chart where blue and orange line represents the website visitors for 2020 and 2021 respectively,

infographics axis options effects

Analyzing Format Axis Pane

Now right click on the vertical axis and click on the format axis from the shortcut menu.

opening format axis pane from the shortcut menu chart in excel

This will open up a Format Axis Pane at the right of the window.

Format Axis pane has two Sub panes named Axis options and Text options.

Formatting Chart Axis in Excel – Axis Options : Sub Panes

There are further four more panes in the axis options named: Fill and Line, Effects, Size and properties, Axis Options. We have worked with the Fill and Line in our previous blog.

axis options in format axis pane

Chart Axis – Axis Options : Effects

The Effects has the following menu.

format axis pane effects options

However, In this blog, we will be working with Shadow, Glow, Soft Edges, 3-D format > Effects Options > Axis Options > Format Axis Pane.

Effects: Shadow

We can add the Shadows to each of the axis values. The first option is for preset. Preset it to use the predefined shadow types..

We have chosen the shadow preset as the bottom left.

After there is the color for the shadow. A shadow need not be black always as in real life. Here is the list of colors for the axis values shadow.

adding shadow color to the axis values of a chart in excel

This is how the axis values will look after this.

applying shadow to axis values of a chart in excel

The next four options are to customize and make your own shadow type.

  • Transparency – This is to make the shadow transparent. Increasing Transparency to 100 % would make the shadow completely invisible.
  • Size – Size of the shadow increases or decreases the shadow size.
  • Blur – More blur is the value of shadow, less sharpened it will be. In other words, 0 pt blur would mean a sharpened orange shape as shadow would be there.
  • Distance – This is the distance between the axis values and the shadows.
  • Angle – This is the angle between the axis value and its shadow. You can notice the angle change only when there is some distance between the angle and the shadow.

For now, we are setting the following values for them by their sliders.

formatting chart axis in excel shadow setting values

This is how the shadow for the chart axis will look now.

result after changing the chart axis shadows

Effects: Glow

As the name suggests, glow makes the axis line glow from all four edges. We will apply this effect on the horizontal axis this time. Right-click on the horizontal axis and the format axis pane for the horizontal axis opens.

glow the axis values in the chart

There are four options as you can see above. Presets have predefined glows for the axis values.

We can customize this preset as we want from the following menu.

customizing glow for axis line of a chart in excel

We have set the glow size and transparency to 8pt and 0% respectively.

This is how the horizontal chart axis line looks now.

Effects: Soft Edges

The soft edges option softens the axis line of the chart in excel. There are some predefined soft edges formatting sets as follows.

soft edges preset for chart axis in excel

There is also a slider to adjust the soft edges to get it customized. We have formatted the vertical axis to 2pt soft edges with this slider. This is how it would look now.

soft edges customized slider for chart axis in excel

This brings us to the end of the blog.

Thank you for reading πŸ˜‰

Leave a Comment