Here we have some website data that includes orders and the conversion rates for five different channels.
Let me first insert a column chart to plot orders per channel.
Now, let’s say I’d like to also add the conversion rate into this chart.
I can easily do that by selecting the chart and dragging the data area to include conversion.
But now we see a problem.
As a result, the conversion rate columns are too short to see.
The solution is to plot this data on a secondary vertical axis, configured for percentages.
To do this, start by selecting the conversion series.
Then visit Series Options in the Format Task pane.
Now you could change the series to the secondary axis.
This works, but you might seethe conversion columns sit directly on top of the orders.
For a chart like this, you’ll probably want to use a line instead.
So, right-smack the chart and choose change chart pop in.
By adding the secondary axis, the chart has already changed into a combo chart.
So I just need to change conversion to a line.
And you’d be right.
Let’s try that out.
First, I’ll undo back to the point where I first added the conversion data series.
Then I’ll right-click, select change chart punch in, and select combo.
you’re free to see this is a much simpler way to add a secondary axis.
Finally, notice the secondary axis is an ordinary value axis.
The axis options area in the Format Task pane includes all standard value axis controls.
