Chart with a single x-axis but two different ranges

In this charting tutorial, you learn to create Excel chart with single x axis but two different ranges.

Let us create a simple chart having 2 types of data like day density (range 0 to 20) and percentages (0 to 100%) like below:

density data table

Changing x axis range

Create a simple graph. A simple 2d column chart will look like this:

2d column chart

The issue with this chart is that the percentages are treated as decimals and have very low values r columns displayed which are not visible at all.

Let us handle it by creating the secondary axis as follows. Right click on the graph and click change chart type:

change chart type

Adding secondary axis range

Select “Combo” chart type. Check secondary axis for percentages:

chart with two axes Combo

Right click the axis on the right and click format axis:

chart with two axes format axis

In the axis options change the min and max to 0 to 1.0

chart with two axes axis options

And then change the number format to percentages as follows:

chart with two axes number format percentages

chart with two axes percentage

Finally we will have 2 types of axis and the graph looks readable for both Density and percentages:

chart with two axes 2 types of axis

You now have a chart in Microsoft Excel with a single x-axis but two different ranges.

See also  How To Create A Territory Map In Excel?