Microsoft Office Tutorials and References
In Depth Information
Figure 13-7 Use a 100% stacked column chart when you want to emphasize the percentage
changes between parts of a total over time.
For column charts, most of the 3-D subtypes apply visual effects only. The exception is the
3-D Column subtype, which uses the horizontal axis and the depth axis to compare series
and categories equally, with values on the vertical axis.
Use a line chart when you want to plot data over time (or along ordered categories) to
show trends on a continuous scale: revenues by quarter, economic growth by year or
decade, rainfall or high and low temperature by month, and so on. The horizontal axis
should be divided into equal units, with no gaps. Figure 13-8, for example, shows a month’s
worth of daily high and low temperatures plotted on a line graph
Figure 13-8 Because this line graph has 31 separate data points on each line, we’ve chosen not
to use data markers.
Each of the 2-D subtypes in the Line Chart category includes options to show lines with or
without data markers. If the number of data points on the category axis is relatively small,
let Excel automatically add markers to show the exact location of each point. That makes it