Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Axes
Repeat this procedure for each series in the chart. This method of unlinking a chart series (as
opposed to creating a picture) enables you to continue to edit the chart and apply formatting. Note
that you can also convert just a single argument to an array. Highlight the argument in the SERIES
formula and press F9.
Excel imposes a 1,024-character limit to the length of a SERIES formula, so this
technique doesn’t work if a chart series contains a large number of values or category labels.
Note
Working with Multiple Axes
An axis is a chart element that contains category or value information for a series. A chart can use
zero, two, three, or four axes, and any or all of them can be hidden if desired.
Pie charts and doughnut charts have no axes. Common chart types, such as a standard column or
line chart, use a single category axis and a single value axis. If your chart has at least two series — and
it’s not a 3-D chart — you can create a secondary value axis. Each series is associated with either the
primary or the secondary value axis. Why use two value axes? Two value axes are most often used
when the data being plotted in a series varies drastically in scale from the data in another series.
Creating a secondary value axis
Figure 6-20 shows a line chart with two data series: Income and Profit Margin. Compared to the
Income values, the Profit Margin numbers (represented by squares) are so small that they barely
show up on the chart. This is a good candidate for a secondary value axis.
Figure 6-20: The values in the Profit Margin series are so small that they aren’t visible in the chart.
Search JabSto ::




Custom Search