I have the attached Excel sheet, when the end user clicks the button it populates columns A through D. It all depends on what parameters the end user enters in cells: B1, D1 and B2, D2.
Now, I have a chart in the "Slab-Dried-in Chart" worksheet. Currently I have to manually change the series for the everything every time I click the button. Is there a way to automatically tell the chart to update the series everytime the button is clicked?
In the attachment there are only 3 rows of data, but it can vary, there could be 50 rows or 10 rows etc. I don't want to have to select the new data everytime to update the chart. Can I do this using VBA?
Thank you in advance!