Microsoft Office Tutorials and References
In Depth Information
Line charts
T ABLE 2-4 LINE CHART SUBTYPES (Continued)
Chart Type
Description
100% stacked line
Line chart with stacked data series expressed as
percentages
Line with data markers
Line chart with data markers
Stacked line with data markers
Line chart with stacked data series and data
markers
100% stacked line with data markers
Line chart with stacked data series and line
markers, expressed as percentages
3-D line
Chart that displays “ribbon-like” lines, using a
third axis
See Figure 2-8 for an example of a line chart that depicts daily sales (200 data
points). Although the data varies quite a bit on a daily basis, the chart clearly
depicts an upward trend.
Figure 2-8: A line chart often can help you spot trends in your data.
A line chart can use any number of data series, and you distinguish the lines by
using different colors, line styles, or markers. Figure 2-9 shows a line chart that
uses three series, each with 48 data points. Each line is displayed in a different color
and with a different marker. The series are identified by the legend.
Figure 2-10 shows a 3-D line chart that depicts population growth for three
states. Most would agree that a 3-D line chart is definitely not a good chart type for
this data. For example, the 3-D perspective makes it virtually impossible to
determine the relative growths of Washington and Oregon. In fact, the chart may present
Search JabSto ::




Custom Search