Setting the numeric format for the x and y axes
You can change the numeric format for x-axis, y-axis, and data label text in charts. For example, you can display data using currency symbols or percentages. You can also display data as dates.
To set the numeric format for the x and y axes |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click the X or Y axis to select the text.
|
|
Selection handles appear around the X or Y axis labels.
|
|
3.
|
|
Click Chart
 Text properties. |
|
4.
|
|
Click the Numeric format tab.
|
|
5.
|
|
In the Category area, choose one of the numeric formats from the list.
|
|
For example, to use a date format, choose Date from the list.
|
|
6.
|
|
In the Format area, specify any numeric format settings.
|
