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

Excel in Practice

When data series on a chart have extremely different values, as shown in Figure 21.32, but they still must be viewed on the same chart, use the secondary axis feature as shown in Figure 21.33. Select the data series to plot on the secondary axis and choose Format, Selected Data Series. Click the Axis tab and choose Secondary Axis.

Figure 21.32. The numbers for units and sales are widely divergent, making the chart look awkward and difficult to read.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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