Excel 2010 Bible

Chapter 19: Learning Advanced Charting

451

FIGURE 19.11

These charts display the same data, but the right chart uses a logarithmic scale.

If your chart uses very large numbers, you may want to change the Display Units settings. Figure

19.12 shows a chart that uses very large numbers. The chart on the right uses the Display Units as

Millions settings, with the option to Show Display Units Labels on Chart.

FIGURE 19.12

The chart on the right uses display units of millions.

The Major and Minor Tick Mark options control how the tick marks are displayed. Major tick

marks are the axis tick marks that normally have labels next to them. Minor tick marks fall between

the major tick marks.