• 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 14.32, but they still must be viewed on the same chart, use the secondary axis feature as shown in Figure 14.33. Select the data series to plot on the secondary axis and choose Selected Data Series from the Format menu. Click the Axis tab and choose Secondary Axis.

Figure 14.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