Creating a Dynamic Chart that shows from Today for 100 days forward, changing daily

Hi,
I have a table that contains all dates for the whole year. I need to update my charts so they are always looking at the next 100 days from the date that is TODAY, so each day the chart will be rolling forward by 1 day (I hope that makes sense)

At the moment my charts are managing the date range using the Select data Horiziontal Axis (range), but this means I have to change it daily. Instead, I would like advice to make this an automatic process to save me work.

Also, In the select data Legend Entries, is there a way that I can select all entries in the Series Values columns, rather than setting a fixed range, making it easier for me to add extra dates and not having to change the ranges?

I will attach my spreadsheet shortly so that you can see what I have done, hopefully someone can assist me - I'm not an expert at excel so can you please advise in laymans terms.

Thank you for your help

Rob

Following the general procedure in this article I was able to make the charts dynamic. Look on tab "Charts" to see how changing the formulas that are providing the beginning and ending dates =TODAY() and =TODAY()+100 changes the charts. Look at the name manager on the formula tab to see how the cells and formulas are named. Also make sure to look at the selected data for the charts to see how the formulas are applied.
Here is a copy of your file with the Charts tab added: Dynamic Charts (Named ranges and formulas) - All Resourcing Requests.xlsx
Let me know if you have any questions.

The issue with the formulas was that since they had been placed on a sheet other than Linux Resources the Look_up array had to be refereed back to that sheet as in: ="'Linux Resources'!$A$" & MATCH(fromDate,'Linux Resources'!$A$2:$A$1094,0) & ":$A$" &MATCH(toDate,'Linux Resources'!$A$2:$A$1094,0)
Here is a copy of the file, I changed the name so that I could remember that the charts are made dynamic by using named ranges and formulas, with the formulas applied to the charts on the Linux Assigned sheet: Dynamic Charts (Named ranges and formulas) - updated-All Resourcing Requests.xlsx
Let me know if you have any questions.

When I entered the series values I typed 'Calc'!rngName2L I guess Excel changes that. Hope that is a helpful answer.

You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.