Auto update Excel Charts

[BexleyManor]

:banghead: Driving me to despair this one!!

Ok, I simply want the chart to update when I enter data into the worksheet. I vaguely remember something about using names then modding the series forumla in the chart to use these but I'm not too sure on the finer points.

Could any of you kind folks assist before I wig out!!??

Also, (I'm being greedy now!!) on chart2, is it possible to get this to contain only the last sixty days worth of data??

Buy you all a beer for this one (Virtual beer, you understand!!) :thumb

[HaHoBe]

Hi, BexleyManor,

I applied 3 names for High, Low and Close for the last 60 days like this one for High


=OFFSET(strategy2!$B$1,COUNTA(strategy2!$B:$B)-60,0,60,1)

and assigned the source data with the name of the workbook and the given names:


='UK100 re.xls'!High

HTH,
Holger

[BexleyManor]

Hiya,

Just got in so I will take a look at your suggestion then report back.

Incidentally, many thanks for your input

[BexleyManor]

Ok, I've had a look at the worksheet and there are a couple of things.

1) "I applied 3 names for High, Low and Close for the last 60 days"

- This appears to effect Chart1 as well as Chart2, however I wish for the 60 day filter to be applied to Chart2 only. Is this possible?

Update
*****

I've put head into gear and worked it out!! For Chart1 I've used a named range "High" and for the formula


=OFFSET(strategy2!$B$2,0,0,COUNTA(strategy2!$B:$B)-1)


then for Chart2 I've used a named range "High60" and your excellent suggestion:


=OFFSET(strategy2!$B$1,COUNTA(strategy2!$B:$B)-60,0,60,1)


And everything appears to work fine. I'm sure I'll be back with more on this but until then, thanks for the help, it's really, really appreciated!
:beerchug:

All praise the mighty VBAX, the King of all Forums!!