Microsoft Office Tutorials and References
In Depth Information
The line chart (middle left) may not be the best choice because it can imply that the data is
continuous — that points exist in between the 12 actual data points. This same argument
may be made against using an area chart (middle right).
The pie chart (lower left) is simply too confusing and does nothing to convey the
timebased nature of the data. Pie charts are most appropriate for a data series in which you
want to emphasize proportions among a relatively small number of data points. If you have
too many data points, a pie chart can be impossible to interpret.
The radar chart (lower right) is clearly inappropriate for this data. People aren’t accustomed
to viewing time-based information in a circular direction!
Fortunately, changing a chart’s type is easy, so you can experiment with various chart
types until you ﬁ nd the one that represents your data accurately, clearly, and as simply as
This chapter introduced Excel charts, including the difference between embedded charts
and separate chart sheets, and parts of a chart. You learned how to:
Create a chart, including choosing a recommended or other chart type.
Change the chart style or layout.
Display and work with various chart elements.
Move, resize, and copy a chart.
Use the Format pane for formatting various chart elements.
Print a chart.
Experiment with more chart types.