How do I display data in a bar charted rounded to thousands?
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
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters
"CatyLin" wrote in message
...
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?
|