• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

Choosing the correct chart type to display information is critical to comprehension. Figure 13.48 shows a typical clustered column chart that displays additions to each department's headcount as a separate column. Although the information being conveyed is clear, the ramifications aren't obvious; the audience must do a bit of quick calculating to figure out the results. In Figure 13.49, the stacked chart type displays additions to each department as stacks on top of the current headcount stack. When displaying information that's in addition to another column but within the same data set, stacked charts work much better for getting the point across.

Figure 13.48. Displaying the current and projected amounts in separate columns requires the audience to do a little math in their heads.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint