With logarithmic scaling of your value axis, you can compare the relative change (not the absolute change) in data series values.

Because a typical line chart compares absolute data values, if you plot the sales for these two firms in the same line chart, you completely miss out on the fact that one firm is growing much more quickly than the other firm.

With the logarithmic scaling, the growth rates are shown rather than the absolute values.

And when you plot the growth rates, the much quicker growth rate of the small company becomes clear.

In fact, you can actually extrapolate the growth rate of the two companies and guess how long it will take for the small company to catch up with the big company.

Just extend the lines.).

But you can change the scaling by entering some other value into the Logarithmic Scale Base box.

After you choose one of these location-related commands, Excel adds a placeholder box to the chart.

To replace the placeholder title text, click the placeholder and type the title you want.

This pane provides buttons you can use to control the appearance of the title and the box the title sits in.

The pane provides buttons and boxes for specifying any special effects, including shadowing, glow, edge softening, and the illusion of three-dimensionality.

You can also control the sizing and setting other properties of the title.

In the case of the Format Chart Title pane, for example, you click the icons that look like a paint can, a pentagon and a box with measurement marks to access the Fill Line, the Effects and then the Size Properties settings.

So go ahead and experiment with your options here to get comfortable with the options you have for your pivot charts.

To display the Format Chart Title dialog box, click the Layout tabs Chart Title command button and then choose the More Title Options command from the menu Excel displays.

Add Axis Labels In Excel For Mac