Setting the numeric format for chart text
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.
To set the numeric format for chart text |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Select the text.
|
|
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.
|