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

Chapter 14. 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 very 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 quite helpful to separate the data series with different chart types on the same chart to show distinct differences between two sets of information. Figure 14.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.

The methods are basically the same for changing the chart type for the entire chart or for selected data series. The only difference is that if you want to change just a data series, you select the data series first. You can use any of the following methods to change the chart type:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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