Change number formats in charts
Note If you change the number formatting in a chart, the number formatting is no longer linked to the worksheet cells.
- To format labels along an axis, double-click the appropriate axis.
To format data labels or a trendline label, double-click the item.
- On the Number tab, select the options you want.