Hey all,
Some nugget in my department created an Excel file with about 50 worksheets. Each worksheet contains about 5 Excel graphs with the raw data above on each page.
We now need to update this report for this year. While the raw data has been updated, I now have to go into every excel chart and right click then go to "Source Data" and update the fields to include the new line of data.
Is there a macro that would automatically change the charts for me?
Basically, I need to change the range for every chart to include one more line.
Some nugget in my department created an Excel file with about 50 worksheets. Each worksheet contains about 5 Excel graphs with the raw data above on each page.
We now need to update this report for this year. While the raw data has been updated, I now have to go into every excel chart and right click then go to "Source Data" and update the fields to include the new line of data.
Is there a macro that would automatically change the charts for me?
Basically, I need to change the range for every chart to include one more line.