![excel add axis titles to a chart excel add axis titles to a chart](https://images.idgesg.net/images/article/2017/09/02-chart-elements-100735971-orig.jpg)
Let's try that out.įirst, I'll undo back to the point where I first added the conversion data series. So, as you're watching this, you might guess that changing the chart type is a better way to do this from the start. So I just need to change conversion to a line. By adding the secondary axis, the chart has already changed into a combo chart. So, right click the chart and choose change chart type. The conversion columns sit directly on top of the orders.įor a chart like this, you'll probably want to use a line instead. Now you can change the series to the secondary axis. Now if the Format Task pane isn't open, select the conversion series, then use control 1 to open the Format Ttask pane. Then visit Series Options in the Format Task pane. Its hard to select because it's so small, so you can right-click the chart and use the mini toolbar. To do this, start by selecting the conversion series. Now, I want to point out that you can add a secondary axis with the format task pane, though it's not ideal, for reasons I'll explain. The solution is to plot this data on a secondary vertical axis, configured for percentages. The conversion rate is measured as a percentage, where all numbers are less than 1, while the orders are much bigger numbers.Īs a result, the conversion rate columns are too short to see. I can easily do that by selecting the chart and dragging the data area to include conversion.īut now we see a problem. Now, let's say I'd like to also add the conversion rate into this chart. Let me first insert a column chart to plot orders per channel. Here we have some website data that includes orders and the conversion rates for five different channels.
EXCEL ADD AXIS TITLES TO A CHART HOW TO
In this video, we'll look at how to add a secondary axis to chart.