Here’s a sample radar chart, so you can see what we’re talking about. It’s useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey data. You’ll see the percentage values on the right Y axis, now.ĭownload the Secondary Axis Charts-Complete.A radar chart compares the values of three or more variables relative to a central point. This will only change the Profit Percentage series, not the rest of the chart. If you’re using Excel 2010 or earlier, choose one of the Line chart selections.
Now that you can see it, you can right click on the secondary axis series.
#USE SECONDARY AXIS IN EXCEL FOR MAC SERIES#
Below the Chart Elements field, click the Format Selection button.In the drop down list, select the “invisible” series, in our case, Profit Percentage.On the Layout tab, click the Chart Elements field in the Current Selection group.This depends upon the version of Excel you are using. So, we’ll use an alternate method to select it. It would be hard to right click on this data, since we can’t see it. By default, this will create it on a worksheet of its own, maximizing the chart size. Note: Want more room to maneuver? Try using the F11 shortcut to create your chart. It’s there, it’s just so small when we compare it to the Sales Data. As you can tell, the Profit Percentage data appears to be missing. So, we’ll select the first two columns containing the Item and sales price, then hold down the Ctrl key to select the column containing the profit percentage.Ĭhoose the chart type in which you’d like to see your primary data series formatted.
In our case the data we want to chart is not contiguous. A secondary axis chart does not add a 3 rd axis or dimension to your chart (Z-axis), it is more like a second Y axis.ĭownload SecondaryAxisChart.xlsx to work along with the tutorial. To see both and how they correlate, we’ll need to use a Secondary Axis Chart. So, if you’d like to see the profit percentage, which is usually a value of 1 or less, plotted with the sales price, typically a much larger value, using a regular chart style will render the profit percentage virtually invisible. Divide this remainder by the production cost, and you get the profit percentage. When you subtract the production cost from the sales data, you get the gross profit. For example, let’s say you have data representing the sales of products. If you have two data series that are related, but not comparable, it might be tough to chart it. By Melissa Esquibel Categories: Charts, Excel® Tags: excel chart secondary axis
0 kommentar(er)
