Chart Range update every month

**abinayan** · 07-12-2011, 09:33 AM

Hi Everyone,

I have a question. I am frustrated by this. I am trying to find a way to update the ranges of my charts automatically to a new column of data. For example, if you consult the excel sheet, I would like the sheet to be able to automatically update each month with the number of fruits for that particular month.
It would be even better if I am able to go back an forth eith the ranges as well.. like for example a dropdown or something like that for every month. so that I can download which ever statistic i want any time.
I want to be able to do this for more than 10 years. Would that be possible?

Cheers.

**ChemistB** · 07-12-2011, 10:43 AM

Here is a site that can explain dynamic named ranges better than I can.

http://www.contextures.com/xlNames01.html#Dynamic

I created 3 charts for you in the attached workbook.
1. Basic Dynamic expands as you add dates in row 6.
2. Latest History, takes the final x dates of data only
3. Range, input a beginning and ending date to chart a range.

Is that what you are looking for?