If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I display data in a bar charted rounded to thousands?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
How do I display data in a bar charted rounded to thousands?
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 |
Thread Tools | |
Display Modes | |
|
|