![]() ![]() ![]()
Voilà! Your chart is ready, showing both the number of shoes sold and percent, according to shoe size. Select the first line graph option that appears, as shown below. On the far righthand side, select the "Change Chart Type" icon and hover over the "Line" graph option. Then, click into "Chart Design" on the menu bar on top of your Excel spreadsheet. How to make a logarithmic graph in excel for mac series#Let's do that.Ĭlick your orange columns - as shown in the screenshot above - to highlight your second data series again. See how you have "Percent of Nike Shoes Sold" overlapping with the "Number of Shoes Sold" columns? Ideally, you want to present your secondary data series in a different form than your columns. You now have your percentages on their own Y axis on the right side of your chart, but we're still not done. In this menu bar, click the "Secondary Axis" bubble to switch your Percentage of Nike Shoes Sold data from your primary Y axis to its own secondary Y axis. Having highlighted this additional data series on your chart, a menu bar labeled "Format Data Series" should appear on the right of your screen, as shown below. To give this data a secondary Y axis, click on one of these bars just above the X axis line until they become highlighted. You'll see your new data series added to your chart, but currently, this data is being measured as a low-laying series of columns on your primary Y axis. Switch this data series from your primary Y axis to your secondary Y axis. If you're using a version of Excel that doesn't provide you with this formatting button, move on to the fourth step below. ![]() A pop-up will come out that gives you the option to select a secondary axis. Having selected "Format," navigate to the dropdown menu on the top-lefthand corner of your menu bar, where it might currently say "Chart Area." Click this dropdown and select "Series 'Percent of Nike Shoes Sold'" (or whichever series you want as your secondary axis).Īfter you select "Series 'Percent of Nike Shoes Sold,'" click on the "Format Selection" button - it's right below the dropdown. Head over to your top navigation bar and click on "Format." This should pop up in dark green next to "Chart Design," as shown to the far right in the screenshot below. Now it's time to turn the "Percent of Nike Shoes Sold" data - currently row 3 in the spreadsheet - into your chart's secondary Y axis. Your chart will then appear below your data set. Then, click "Charts," navigate to the "Column" section, and select "Clustered Column" - the first option, as shown below. Otherwise, you can highlight the data you want to include in your chart and click "Insert" on the top-lefthand corner of your navigation bar. Want a detailed guide to creating a chart in Excel? Click here. For this example, Row 3 will be our secondary axis. Make Row 1 your X axis and Rows 2 and 3 your two Y axes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |