automatically vertical axis length to be resized as the value changes?

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

automatically vertical axis length to be resized as the value changes?

Post by BittenApple »

Hello team,
Can we make the length of vertical axis in a column chart in Excel to be resized automatically as the value changes in office 365?

Regards,
bittenapple

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: automatically vertical axis length to be resized as the value changes?

Post by HansV »

By default, the scale of the axis (min and max value) will be adjusted automatically. But the physical length of the axis won't change.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: automatically vertical axis length to be resized as the value changes?

Post by BittenApple »

Hello Hans,
Thanks for the response. It seems to me that length axis was changing when the series were changing but all of a sudden this feature stopped when I set min and max for axis.
Regards
Bittenapple