BexleyManor
05-10-2005, 03:45 PM
: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
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