Then, on the Excel spreadsheet's top menu bar, select Chart Design. To highlight your second data series once more, click your orange columns as seen in the picture above. Your secondary data series should ideally be presented in a different format than your columns. Look at how the columns for Number of Shoes Sold and Percent of Nike Shoes Sold cross each other. We're not finished until your percentages are on their own Y axis on the right side of your chart. To change the Percentage of Nike Shoes Sold data's primary Y axis to its own secondary Y axis, click the Secondary Axis bubble in this menu bar.Īdjust your formatting to add a second axis in excel:
A menu bar with the label Format Data Series ought to appear on the right side of your screen once you've highlighted this extra data series on your chart, as seen below. Click on one of these bars directly above the X axis line until it becomes highlighted to add a second Y axis to this data. Your new data series will now be displayed in your chart, however it is presently being measured as a low-lying sequence of columns on your main Y axis. Your primary Y axis should now be your secondary Y axis for this data series in excel
If the version of Excel you're using doesn't have a formatting button, continue to the fourth step below.\ Select Series 'Percent of Nike Shoes Sold' by clicking this option (or whichever series you want as your secondary axis).Ĭlick the Format Selection button, which is located immediately below the dropdown, after choosing Series 'Percent of Nike Shoes Sold.' You can choose a secondary axis from a pop-up window that will appear. Navigate to the dropdown menu on the top-left corner of your menu bar, where it could now say Chart Area, after choosing Format. As seen in the screenshot at the far right of this article, this ought to appear in dark green next to Chart Design. Then, select Format from the top navigation bar. The Percent of Nike Shoes Sold data, which is presently row 3 in the spreadsheet, must now be converted into your chart's secondary Y axis. Then, your data set will be followed by your chart. Then, as seen below, choose Charts, go to the Column section, and choose Clustered Column - the first choice. In the top-left corner of your navigation bar, click Insert. We will use Row 3 as our secondary axis in this case Your X axis should be Row 1, and your two Y axes should be Rows 2 and 3. Percentage of inventory of that size that was sold. In a blank spreadsheet, we'll add the following three rows of data about Nike shoe sales for the process:
0 kommentar(er)
