I have no experience with VBA so please consider that with any responses. (Document is attached)
I would like to create a macro that is activated with a button in "Snapshot Data" that changes the bounds of the chart sheet called “Snapshot”. As you can see from the graph the default bounds leave a lot of gap on both sides of the chart. I would like the bounds to be whatever number I define in “K19” and “K20”, in this case 2% above and below the min and max, respectively.
The code could be written to exclude the reference to a particular cell also as long as an explanation on how I would change that percent up or down is given (I don’t know that 2% is exactly what I want just yet)
On the actual document there are several other lines of data than cost per day that have a wide range requiring me to switch the boundaries manually often during presentations.
Any help would be appreciated!
Bookmarks