• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fix axis min, max, major and minor values equal to cell values

E

excel_stuff

Member
Hi, I am using a bar graph and want to be able to set the minimum and maximum values and major and minor values equal to a value defined in cells so I don't have to change the axis every time. Any thoughts? Thank you!
 
Unfortunately, that's not a built in feature of XL, but there are work-arounds.

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
 
Agreed. I keep hoping Microsoft will give us the ability in some future version of XL, but so far, no luck. =(
 
You must log in or register to reply here.
Back
Top