Within the Series Options, you can change whether a data series points towards the primary or secondary axis. The chart is easier to read and interpret. The Market share data series no longer hides the other data. The easiest way to settle this is to change the chart type for that data series.įrom the Chart Tools' Design tab, press the Change Chart Type button.įrom the Line category, select Line with Markers option. The problem in this present chart is that the Market share data series is now hiding the other values. The values on it are in percentages compared to number on the axis on the left side of the chart. The secondary axis will appear on the right side of the chart. Here are the steps to activate it.įrom the Chart tools' Layout or Format tabs, select the Series Market share.įrom the Series Options category, select Secondary Axis. In this case, adding a second axis from the Market share data is necessary. Imagine, how hard it would be if the values where in the millions or more. But there is another way to add data to a chart in Excel/2010.Īs you can see, it's hard to interpret the Market share data series even when you try to compare it to values ranging from 15 to 40. You could go to the Chart tools' Design tab and press the Switch Row/Column button to fix this. The years are no longer on the X axis (horizontal). This is how it would look if you added the market share data. The Market share data series will be added later.įrom the Insert tab, select Column Chart and 2-D Clustered column. This page will show you how to activate a secondary axis for your charts. The reason is because of the difference in scale between two data series or more. On occasion, it's better to present a data series on a second axis.
0 kommentar(er)
