• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Modifying Excel Charts > Changing the Chart Type

Changing the Chart Type

No matter how much time you spend deliberating before creating a chart about what type of chart to use, occasionally the result just isn't what you need. You can change the chart type easily to some other type that works better for the data. Excel even lets you combine chart types by changing individual data series to a different type from the rest of the chart. For example, when comparing trends or different sets of data, it can be helpful to separate the data series with different chart types on the same chart to show distinct differences between two sets of information. Figure 21.1 shows projected sales in a line and actual sales in columns. In this example, displaying the projected sales as a line clearly emphasizes by how much sales fell short of projection.

Figure 21.1. The result of the changed series is in the form of a line chart.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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