• 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


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

Automatic Format Axis


New Member
I have to do multiple graphs based on similar data, but each time I need to format the axis as I change the data but the graph uses same cell reference.

I have to do like 400 such graphs.

So changes in data requires me to format the y axis each time as the y axis stays the same as the last graph

Any help would be appreciated.


Excel Ninja
Staff member

I generally don't graph directly from my data, but use some helper columns/rows where I extract the data first and then graph from thoose areas.

This way, for example if you are doing a moving 12 month chart, all the data is extrated into the helpr columns usin Offset/Match or VLookups etc.

Then becaue all the charts are based on the same X-Axis you can set its scale to automatic and everything moves together.