Hi I was hoping to get some help on some code that will update my scatter plot on click of button on Excel sheet. I'm using Excel 2007. Data is on Pivot Tables and the row range will always change.
Basically I have Scatter plot that collects data from two separate Pivot Tables on two sheets...