longagent.blogg.se

1. #Add a secondary y axis to a graph in excel for mac how to#
2. #Add a secondary y axis to a graph in excel for mac series#

#Add a secondary y axis to a graph in excel for mac series#

Switch this data series from your primary Y axis to your secondary Y axis.Gather your data into a spreadsheet in Excel.

Keep in mind the options shown in each screenshot might be in different locations depending on the version of Excel you’re using. Note: Although the following Mac and Windows instructions used Microsoft Excel 20, respectively, users can create a secondary axis for their chart in most versions of Excel using variations of these steps.

#Add a secondary y axis to a graph in excel for mac how to#

(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. 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.

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.