Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

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

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

    
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

1 Answer 1

No. There is not a quick way to accomplish his goal without using VBA and without having to type in the Fixed min/max values.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.