Excel Chart - Primary Axis - Bounds & Units

[Sundance_Kid]

Hi,

I have an excel chart showing Sales per month over 11 months. The months are on the horizontal axis and the amounts are on the vertical axis.

I want to have units of 5,000 between each part, however, I would like for the start of the axis to go from 0/- to 20,000 and then go to 25,000, 30,000 etc.

Instead it goes from 0/- to 5,000 and up in 5,000 increments.

Any idea is it possible to do this?

Image attached.

 

[DRSteele]

I think you can just set the minimum Bound for the axis and the major Units.

I give you a picture, instead of a thousand word.

 

[Sundance_Kid]

I think you can just set the minimum Bound for the axis and the major Units.

I give you a picture, instead of a thousand word.

View attachment 59283

Thanks, however, that is not solving what I want.
Your axis is starting at 20k, I want it to start at 0 and then go to 20k, then up in increments of 5k after.

 

[DRSteele]

I nearly certain you cannot do that in Excel.

 

[Sundance_Kid]

I nearly certain you cannot do that in Excel.

I think you are probably right.