How do I display data in a bar charted rounded to thousands?

C

CatyLin

I am preparing a bar chart and want the data displayed as round thousands
The chart data is in whole numbers. How do I do this?
 
B

Bernard Liengme

Make another column rounding the y-values to thousands and chart this data
If first y-value is in B2 use in C2 =ROUND(B2,-3)
Select all the x-values; hold CTRL key and select all the new y-values; make
chart
best wishes
 
J

Jon Peltier

If you don't want to change the values, but only the display, select and
right-click the data, choose format, then click on Number, and choose a
number tab like one of these

0,
0,k

The comma drops the last three digits, displaying the thousands rounded
to the nearest thousand, but the underlying values are unchanged.

- Jon
 
Top