Hello... I have a table and chart in an excel sheet and would like to know what I can do to make the table and chart dynamically cycle through the data.
As you can see in the attached picture the table has a Monthly column as well as columns for 5 weeks of data. I would like the Chart to plot the new data I enter in this case for week 2 and then for all the weeks after and change as I enter the new information. More importantly I would like the Chart to begin plotting on the Week 1 column when I enter the new data there.
Bookmarks