Chart and Y -Axis Ranges

[Steffi1013]

Is there a way to set up the chart to dynamically set its own range for the y-axis based on the data coming in?

I have a chart that depending on a certain type, the y-axis (which is money) could be $100.00 max or it could be $5000.00 max and I don't want to have to set the range all the way to $5000.00 if the top is only $100.00

Does this make sense?

 

[ablackwe]

Hi, I have produced graphs where the Max of the Y-axis changes dependant on the max value. On the Chart Properties, set the Scale Minimum to 0 and leave the Scale Maximum blank.

Hope this helps
Thanks
Adam


Adam Blackwell
Information Analyst

http://www.workinglinks.co.uk/

 

[xlbo]

yup - leave both blank for auto scaling. I think by default, the report is set up with a value of 0 in both - simply remove any values in place for the max/min and it should auto scale

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Steffi1013]

That works!!!! Thanks for pointing me in the right direction.