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

Excel Chart Types

Excel offers a wide variety of chart types because certain data works better with some chart types than others. For example, if you're plotting sales figures over a period of months, it's better to use a clustered column chart or line chart than a pie chart. The different chart types and the data that works best with the charts can be confusing, so it's important to understand which is the best chart for the information. The Chart Wizard suggests a certain type based on the data, but that doesn't mean that the suggested type is the best type to represent the data.

At some point, you'll probably want to experiment with each chart type to see how it plots data. This section shows the types that probably will be most beneficial in real world use. After you become familiar with the different charts and what they're best suited for, you can even combine chart types for complex charting.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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