Prev: Excel 2007 default colors charts
Next: Show only specific Series in the data table
From: CatyLin on 24 May 2010 09:55
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?
From: Bernard Liengme on 24 May 2010 13:12
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" <CatyLin(a)discussions.microsoft.com> wrote in message
news:444D5AF2-FF04-4E3C-BA01-98F6CA6AC76C(a)microsoft.com...
> 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?

From: Jon Peltier on 24 May 2010 14:19
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/24/2010 1:12 PM, Bernard Liengme wrote:
> 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
 | 
Pages: 1
Prev: Excel 2007 default colors charts
Next: Show only specific Series in the data table