Charting Ranges

[Dazed_]

Hi, i've got an excel database which uses forms for increasing the data range and then inserting data. I need to graph this data. However i can't figure out how to get excel to refer to the constantly expanding range, rather than specific cells. I try typing my range name in the chart wizard, but it just selects the cells which that range currently refers too...

Any help would be ace...

Cheers, Daniel...

 

[Ivan F Moala]

On 2002-02-17 17:41, Dazed_ wrote:
Hi, i've got an excel database which uses forms for increasing the data range and then inserting data. I need to graph this data. However i can't figure out how to get excel to refer to the constantly expanding range, rather than specific cells. I try typing my range name in the chart wizard, but it just selects the cells which that range currently refers too...

Any help would be ace...

Cheers, Daniel...

Hi Daniel
If I understand you Q ??
When entering named ranges for chart data
the format should look like;

='SheetName'!NamedRange

For a dynamically changing range I'm assuming your using a Dynamic range formula similar to;
=OFFSET('sheetname'!$B$5,0,0,COUNTA('sheetname'!$B:$B)-1,1)

which will give you a dynamically changing adress..............

Actually now that I reread your post I'm guessing you have assigned this from your form ??


Ivan

 

[Dazed_]

Cheers Ivan...

I wasn't expanding my range that way... But i've found a way around my problem... Thanks for your help anyhow... much appreciated...

Daniel