up vote 1 down vote favorite
share [g+] share [fb]

I have a colleague who creates lots of charts. He wants the min/max of the Y-axis of a bar chart to reflect the min/max within a range in Column "A" of an Excel spreadsheet. The min/max will change depending on his input into the spreadsheet. The values are very large and he has several hundred rows of values.

I would write a min() and max() formula or sort by ascending order to identify the upper and lower bounds, then change the axis options to "Fixed" for the Y-axis and type in the numbers. He does not want to do this. He also does not know VBA.

Is there a quick way to accomplish his goal without using VBA and without having to type in the Fixed min/max values?

Thanks, Diana

link|improve this question
I think this question is better suited for superuser.com ? – GWW Sep 27 '10 at 15:57
Okay, I will cross-post there. – Diana Tortolini Sep 27 '10 at 16:09
feedback

migrated from stackoverflow.com Oct 19 '10 at 13:26

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard