10/31/2023 0 Comments Mac excel 2013![]() ![]() 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. ![]() (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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |