Microsoft Office Tutorials and References
In Depth Information
Understanding the Shortcomings of Stacked Column Charts
In the top chart, readers
are not able to draw
conclusions about the
growth of the three
regions located at the top
of the chart.
Current-year sales are
shown as a stacked
column chart, with last
year’s sales as a dotted
2. Select cells A1:D13 and create a stacked column chart. Initially, Excel stacks prior-year
sales on top of the other sales, and you have a chart that is not remotely close to the
3. Click the top bar to select the third series. Select Design, Change Chart Type, Line
Chart. An important distinction here is that the first two series are plotted as stacked
charts. The third series is plotted as a regular line, not as a stacked line.
4. Use the Format tab to format the third series as a dotted line. Format the colors of the
first two series as shown in Figure 3.34.