(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.
0 Comments
Leave a Reply. |