I have a worksheet full of raw data and other worksheets which are just
charts based on the raw data. I continually add more data to the raw data
worksheet, and I was wondering if there is a way to change the source data of
the chart so that it will automatically update if the raw data changes. To
clarify this, I will give an example. If on Monday I have 5 rows of data and
every day that week I add more rows, so that by friday I have 10 rows of data
(with the most recent data comprising the top row), can I have the chart
automatically include all of the data? Thanks for your help