Have you ever wanted to create a single chart for two different (yet related) pieces of data? Maybe you wanted to see the raw number of leads you’re generating from each channel and what the conversion rate of the channel is. Having those two sets of data on one graph is extremely helpful to picking out patterns and identifying full-funnel trends. But there’s a problem. Those two sets of data have two Y axes with two different scales — the number of leads and the conversion rate — making your chart look really wonky.
Luckily, there’s an easy fix. You need something called a secondary axis: it allows you to use the same X axis with two different sets of Y-axis data with two different scales. To help you solve this pesky graphing problem, we’ll show you how to add a secondary axis in Excel on a Mac, PC, or in a Google Doc spreadsheet. (And for even more Excel tips, check out our post about.) Note: Although the following Mac and Windows instructions used Microsoft Excel 2016 and 2013, respectively, users can create a secondary axis for their chart in most versions of Excel using variations of these steps. Keep in mind the options shown in each screenshot might be in different locations depending on the version of Excel you’re using.
I found a workaround for this problem, after trying to apply the suggestion from dav (but being unable to find that setting in Office for Mac 2011). I converted the graph type to Area, then made the line thick and the fill transparent.
Please flag this for moderator attention and ask to have it reopened and moved to. If they move it but leave it closed, ping me; I can vote to reopen on Super User (although it will need four other votes). If the moderators refuse to move it, please just re-ask it on Super User. Either way, please post an answer at the level of detail of, but correct for Excel 2013. I’ve got a chart with dual X axes and dual Y axes, but my two X axes show the same labels, and I can’t figure out how to fix it from your comment alone. – Dec 7 '17 at 21:43.
![How How](/uploads/1/2/5/3/125362125/686238735.png)
You should follow the guidelines on: Add a secondary horizontal axis To complete this procedure, you must have a chart that displays a secondary vertical axis. To add a secondary vertical axis, see.
Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Axes group, click Axes. Click Secondary Horizontal Axis, and then click the display option that you want. Add a secondary vertical axis You can plot data on a secondary vertical axis one data series at a time. To plot more than one data series on the secondary vertical axis, repeat this procedure for each data series that you want to display on the secondary vertical axis.
In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements:. Click the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
![How How](/uploads/1/2/5/3/125362125/361947056.jpg)
On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis. On the Format tab, in the Current Selection group, click Format Selection. The Format Data Series dialog box is displayed. Note: If a different dialog box is displayed, repeat step 1 and make sure that you select a data series in the chart.
On the Series Options tab, under Plot Series On, click Secondary Axis and then click Close. A secondary vertical axis is displayed in the chart. To change the display of the secondary vertical axis, do the following:. On the Layout tab, in the Axes group, click Axes. Click Secondary Vertical Axis, and then click the display option that you want. To change the axis options of the secondary vertical axis, do the following:.
Right-click the secondary vertical axis, and then click Format Axis. Under Axis Options, select the options that you want to use.