You will see in my spreadsheet I have a chart with two lines of data; one for "Scheduled" and one for "Completed". The Scheduled data uses all of the values from B7:Q7, which goes to January 2015. For the Completed data, I only show from the beginning (B8) until the current month, in this case E8. My problem is that each month I need to go to the graph, click on "Select Data" and increment the range for "Completed" by one column, so next month, I will change it to be B8:F8 and then B8:G8, etc. I have many of these so it is time consuming and I have to remember to do it and then hope I don't make any mistakes.
Ideally, I would be able to use current date logic and make the range end at something less than or equal to today's date.
Thanks in advance for your help.
Steve

Attached Files

Sample Variable or Condiitional Data Range.xlsx (17.1 KB, 14 views)