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?

How to display data in a bar chart rounded to thousands in Microsoft Excel:

1. Select the data range that you want to use for your bar chart.
2. Click on the Insert tab in the top menu bar and select Bar from the Charts section.
3. Choose the type of bar chart you want to create. For example, you can choose a clustered bar chart or a stacked bar chart.
4. Once you have created your chart, right-click on any of the bars in the chart and select Format Data Series from the drop-down menu.
5. In the Format Data Series pane that appears on the right-hand side of the screen, click on the Number tab.
6. Under Category, select Custom.
7. In the Type field, enter the following format code:
   Formula:

   #,###;(#,###) 

8. Click Add and then OK to close the Format Data Series pane.

Your bar chart will now display data rounded to the nearest thousand. If you want to change the rounding to a different value, simply modify the format code in step 7 to reflect the desired rounding.

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?

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