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

Chapter 11. Advanced Chart Topics > Using Logarithmic Scales

Using Logarithmic Scales

If you look again at the chart in Figure 11.3 (in the previous section of this chapter), notice how you can't see much detail in certain parts of the chart. For example, the first three time categories don't let you see much difference for most of the series being plotted; they're all right next to one another. Also notice how the later categories show very steep rises in the data. You see this pattern when you chart values that increase by orders of magnitude from one chart category to the next. You can address this problem by using a logarithmic scale for the value axes on the chart. For this example, a logarithmic scale will be chosen for both value axes. To do this for each axis, follow these steps:

  1. Right-click the axis you want to change and choose Format Axis from the shortcut menu.

  2. Click the Scale tab on the Format Axis dialog box.

  3. Select the Logarithmic Scale check box and click OK to close the dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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