Microsoft Office Tutorials and References
In Depth Information
Parts of a Chart
Chart Limitations
The following table lists the limitations of Excel charts. Most users never find these
limitations to be a problem.
Item
Limitation
Charts on a worksheet
Limited by available memory
Worksheets referred to by a chart
255
Data series in a chart
255
Data points in a data series
32,000
Data points in a data series (3-D charts)
4,000
Total data points in a chart
256,000
Notice that this chart has two vertical axes. These are known as value axes , and
each one has a different scale. The axis on the left is for the columns (Income) and
the axis on the right is for the line (Profit Margin).
The value axes also display scale values. The axis on the left displays scale
values from 0 to 250,000, in “major unit” increments of 50,000. The value axis on the
right uses a different scale: 0 percent to 14 percent, in increments of 2 percent.
A chart with two value axes is appropriate because the two data series vary
dramatically in scale. If the Profit Margin data were plotted using the left axis, the line
would not even be visible.
Figure 1-5: Parts of a chart
Search JabSto ::




Custom Search