Easily update Excel graphs; AutoHotKey saved me 100’s of repetitive clicks

Easily update Excel graphs

Easily update Excel graphs

In market research I used to spend a lot of time making sure my charts and graphs were beautiful visualizations that conveyed the data in an easy to understandable way.

I always wanted to make complete use of the range of the graph and would have to, manually, update each one.  I finally learned some object oriented programming and wrote an script in AutoHotKey to easily change the axis on scales in and easily update Excel graphs.  The below video demonstrates how I can just hit a key combo and scroll up/down to adjust the scale.

Tweaking Graphs in Excel

Leave a Reply