Dynamic chart based on dates --- do not work...:/ help...

[Rmag]

Hi all what i am trying to do a dynamic chart based on tables indirect function and start and end dates...

Indirect function is for changing the date that i want to see on the chart...

Start and end dates are for choosing specific periot of time that interest me.....

I know what i wrote might be confusing.... But please see file every thing will be more obvious......

I want to (yellow[box] choose the right table and next from boxes below start date and end date of data that intrest me....


But i can't make it work....
Can any one help ?????????????????????






Ps ( i am using excel 2003).......

[Andy Pope]

I corrected the XValues named range and changed the YValues one.
Also the reference to Country is now just a value to offset number of columns.

[DavidJAllen]

I have fixed up your spreadsheet so the dynamic chart now works. The main problem was that the dynamic range for the offset needs to match both on the dates and the country.

XValues=OFFSET(Chart!$A$1,MATCH(StartDate,ChartDates,0),MATCH(Country,CountryRange,0),MATCH(EndDate,ChartDates,0)-MATCH(StartDate,ChartDates,0)+1,1)

Also when including the dynamic range in the ChartTools/Design/SelectData/Series you need to include the name of the excel file so the series value would be entered as =CHARTMY.xlsx!XValues

Hope that helps!

David