Showing a cost value in thousands instead of millions?

[Anonymous]

I have a table made out to represent some costs of environments. Right now the values are being shown in millions, but I don't know how to get to represent in thousands.

[Anonymous]

[irobba · Accepted solution]

Hi there, 

You can change the Display Unit for the labels and for the axis individually in the Chart properties. 

With the chart selected, click the Paint Roller, then expand Data Labels, then Display Units and choose Thousands from there.  For the axis, do the same but look under Y-Axis in this case rather than Data Labels.