Add secondary axis manually
If not automatically, you can always add a secondary axis to your chart manually🏃♀️
This will usually be the case when none of the charts recommended by Excel show a secondary axis.
Yes, that’s very much possible. For example, here is the data with three columns again: the products, sales, and demand.
But both the numeric data columns (sales and demand) are simple integers so Excel plots them both on the same axis.
And so, we don’t have a secondary axis in any of the recommended charts this time 🤷♀️
Excel only represents the second dataset with another color. And very clearly, we cannot read the figures it represents.
If that’s the case you’re facing, don’t worry. You can insert a secondary axis in your chart manually. How? See here.
- Insert the basic chart from the recommended charts (without a secondary axis).
Here’s how it looks.
Looks weird, I know. We will just put it back in place 💪
- Double-click on the small orange bars at the bottom.
You’d be taken to the Format Data Point > Series Options as shown here.
- Check the option Secondary Axis.
And here comes a new axis to the right of the chart.
But the chart is now stacked. The orange bars resonate to the secondary y-axis.
Whereas, the blue bars resonate to the primary y-axis.
If you don’t want it to be a clustered chart but a different one, you can change it through the following steps ✍
- Select the chart.
- Go to the Insert tab > Recommended Charts.
- Under the Change Chart Type dialog box, select the tab All Charts
- From the list of charts on the left, select Combo Charts.
This window allows you to select the chart type for each axis.
We are setting Demand (in units) as the secondary axis by checking the arrow next to it.
- For the chart type, click the drop-down arrow next to Demand (in units) and select the desired chart type from this list of charts.
We are selecting a line graph. This can be any chart (your call totally).
Here comes the chart with a secondary axis on the right. A line chart is made on the chart that graphs the demand (in units).