Sample attached
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
|