how to plot a graph in excel with 2 axes

(And for even more Excel tips, check out our post about how to use Excel.) 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. 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. 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. Split Dual-displays the secondary Y-Axis below the chart.Having those two sets of data on one graph is extremely helpful to picking out patterns and identifying full-funnel trends.īut there's a problem.

On-creates a secondary Y-Axis in the same chart.

In the Chart General Properties, set Toggle Dual Y Split to one of the following: Setting up a chart with a secondary Y-axis requires changes to two places: In this case you can use any bar or line chart type. You can also plot the secondary Y-axis as a split dual chart, where the secondary Y-axis appears with its data series below the original chart. For example bar for the primary Y- axis and line for the secondary Y-axis. While the secondary Y-axis can be used with any line and bar chart type, it is more commonly used with the combination chart type, which helps to distinguish the data series that are plotted on the secondary Y-axis. The scale of the secondary Y-axis reflects the values for the associated data series.

When the data values in a chart vary widely from data series to data series, or when you have mixed types of data (for example, currency and percentages), you can plot one or more data series on a secondary vertical (Y) axis.

How to plot a graph in excel with 2 axes