I have A LOT of data worksheets and charts that go with them. I am trying to find a way to make my charts automatically update when I put in the data. For example, I have a one worksheet name 8-22 to 8-29 data and then next worksheet is named 8-22 to 8-29 chart. The kicker is that in each data worksheet I have 4 sets of the same information with different numbers and then I have to chart all four sets with different information. So, the result is that on my chart worksheet, I have 16 charts that have to be updated. This is repeated for each week of the year...so as you can see it is a major undertaking to have to manually updated the source data for each one each week. I need to be able to put in the numbers on the data worksheet and the charts automatically update. Please help!!