Specifying scale properties
You can specify the scale type for a y-axis and the x-axis in a scatter chart by choosing either a linear or logarithmic scale.
When you create a chart, the scale values are automatically set based on the source data; however, you can specify custom values.
You can also restore the default scale values.
To specify the scale type |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
 Axes, and click an axis. |
|
3.
|
|
Click the Scale tab.
|
|
4.
|
|
In the Scale type area, enable one of the following options:
|
|
•
|
Linear — sets the scale to linear, where the value of each major division is exactly the same
|
|
•
|
Logarithmic — sets the scale to logarithmic, where the value of each major division of the axis represents 10 times the value of the previous major division
|
|
5.
|
|
Choose an option from the Scale values to list box.
|
|
•
|
|
You can scale values only when the scale numeric format is set to currency or number. For information about setting the numeric format, see “Setting the numeric format for the x and y axes.”
|
To specify the scale values | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Scale tab.
|
|
4.
|
|
Disable the Automatic check box.
|
|
5.
|
|
Type values in the following boxes:
|
|
•
|
Max value
|
|
•
|
Min value
|
To restore the default scale values | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Scale tab.
|
|
4.
|
|
In the Values area, enable the Automatic check box.
|