I have a chart with two lines; one to represent when items are scheduled to be done and the second line to indicate when they were actually done. Both lines pull from a table that tracks scheduled and completed items, by month, with each column representing a different month. The chart plots when scheduled items should be done for the next 15 months. I only show the completed items from the beginning through the current month/date. The problem is, I have to go in and manually adjust, using Select Data to change the range by one month (i.e. one column) every month.
Is there away to make the address / range dynamic? Thank you.