When to use a Bar Chart versus a Column Chart depends on the type of data and user preference. The first chart below is the Bar Chart for our single series, Flowers. The horizontal axis of a Bar Chart contains the numeric values. The Bar Chart is like a Column Chart lying on its side. A 3-D Line Chart is available, but the Line Chart does not display data well in three dimension. Though not as colorful as the other charts, it is easy to see how effective the Line Chart in showing a trend for a single series, and comparing trends for multiple series of data values.īesides the Line Chart, we have the Stacked Line Chart and the 100% Stacked Line Chart - with or without markers. Notice that each line is a different color. The Line Chart is equally effective in displaying trends for multiple series as shown in the above Line Chart without markers.
Markers-the circles, squares, triangles, or other shapes which mark the data points-are optional, and Excel displays a unique marker in shape and/or color for each data series. The first image shows the Line with Markers chart of our single data series. The vertical axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category.
The Line Chart is especially effective in displaying trends.
0 kommentar(er)
