help on bar graph please

khiemdong · #1 07-24-2009, 12:18 AM

Hi,

Is there any one know how to label the y axis of the bar graph in integer such as 20k, 30k, 40k instead of displaying 20, 30 and thousands on the side. I do want it specifically as 20k, 30k or 40k. Hope i don't confuse you.

Thanks

d'anconia · #2 07-24-2009, 02:18 AM

You could format the cells for the y-axis to be 20, 30, 40, etc and just make the label for that axis say "thousands of _______".

Or you could click individually on those y-axis labels and see if you can't manually change them. The problem with having the y-axis say "40k" vs 40000 is that 40k itself is not really a number so it's hard for excel to consider it as such and graph it.

I'm new here though so some of these other guys might be able to help you.

**arthurbr** · #3 07-24-2009, 02:51 AM

Hi and welcome to the board.
Please take some time to read forum rules and post in the correct forum.
Thx

Andy Pope · #4 07-24-2009, 04:57 AM

Use custom number format on the Y axis

0,k

Welcome to the Excel Forum

Forum Statistics