Automatically update graphs

[Jon Peltier]

The problem you described is with the first part if you insert rows above
A9. A simple change would be:

=INDEX('Raw Data'!$A:$A,9):INDEX('Raw Data'!$A:$A,MATCH(9.99999E+307,'Raw
Data'!$A:$A))

- Jon

 

[ChrisG]

Thank you for that fix. Now what do we do with regards to the fact that
ChartDates
("=OFFSET(AllDates,MATCH(StartDate,AllDates,1)-1,0,MATCH(EndDate,AllDates,1)-MATCH(StartDate,AllDates,1)+1,1)")
is not highlighted, and neither is ChartEuropeanEquity
("=OFFSET(ChartDates,0,1)") ?

 

[Jon Peltier]

Assuming AllDates is highlighted...

What are StartDate and EndDate?

What do you get if you enter
=MATCH(StartDate,AllDates,1)
and
=MATCH(EndDate,AllDates,1)
into cells in the worksheet?

Instead of the OFFSET refers-to formula for ChartDates, try this:
=INDEX(AllDates,MATCH(StartDate,AllDates,1)-1):INDEX(AllDates,MATCH(EndDate,AllDates,1))

- Jon

 

[ChrisG]

All Dates is highlighted, and when I enter "=MATCH(StartDate,AllDates,1)"
into an empty cell in the worksheet, the number 290 pops up, same thing with
"=MATCH(EndDate,AllDates,1)" My StartDate is "=INDIRECT("A"&8)" and my
EndDate is "18/01/2007" (there is no formula). When I enter
"=INDEX(AllDates,MATCH(StartDate,AllDates,1)-1):INDEX(AllDates,MATCH(EndDate,AllDates,1))"
into the refers to box for ChartDates, it only highlights the first and
second dates of my data set (they are the furthest down the row).

 

[Jon Peltier]

Chris -

I can't help any more by remote control. Send a copy of your workbook to
jonxlmvp (at) peltiertech (dot) com

- Jon

 

[Jon Peltier]

Upon inspection of Chris' workbook, I realized that his dates appeared in
descending order. The proper form for the MATCH function in this case is

MATCH(match_value, match_array, -1)

This cleared up his problem.

- Jon