Change numbers that appear on margin together with the bar graph

**Karolina2012** · 01-28-2013, 03:40 AM

Hi there!

I would like to ask something about the bar-graphs.

How can I change the numbers that appears on the margin together with graph? I have attached worksheet. It is probably very easy but still, I cant figure it out...

Thanks

Excel bar-help.xlsx

**dilipandey** · 01-28-2013, 04:13 AM

Hi Karolina,

Those number are auto scale (i.e, auto numbers) generated by chart itself.
If you really want to 'change' those numbers (may be you wish to change the scale), double click on that, Axis Options and enter number in Fixed field - before that you need to understand your data limits (max / min / intervals etc)

Regards,
DILIPandey
<click on below * if this helps>