Chapter 20: Getting Started with Excel Charts
20
FIGURE 20.22
A line chart often can help you spot trends in your data.Pie charts
A pie chart is useful when you want to show relative proportions or contributions to a
whole. A pie chart uses only one data series. Pie charts are most effective with a small
number of data points. Generally, a pie chart should use no more than five or six data
points (or slices). A pie chart with too many data points can be difficult to interpret.All of the values in a pie chart must be positive numbers. If you create a pie chart that uses one or more negative
values, the negative values will be converted to positive values, which is probably not what you intended.