Microsoft Office Tutorials and References
In Depth Information
Line charts
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
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
equal intervals.
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
Chart Type
Description
Line
Standard line chart
Stacked line
Line chart with stacked data series
Continued
Search JabSto ::




Custom Search