Microsoft Office Tutorials and References
In Depth Information
Unlike a column chart, there is no subtype that displays multiple series
along a third axis (that is, there is no 3-D Bar Chart subtype type).
As with a column chart, you can include any number of data series in a bar
chart. In addition, the bars can be “stacked” from left to right. Figure 2-7 shows a
100% stacked-bar chart. This chart summarizes the percentage of survey
respondents who replied to each option.
Line charts are often used to plot continuous data and are useful for identifying
trends. For example, plotting daily sales as a line chart may enable you to identify
sales fluctuations over time. Normally, the category axis for a line chart displays
Table 2-4 lists Excel’s seven line chart subtypes.
Figure 2-7: A 100% stacked-bar chart
T ABLE 2-4 LINE CHART SUBTYPES
Standard line chart
Line chart with stacked data series