Data source for Graph help

[Djbell]

Hi All

I have an excel spreadsheet thats uses a query lookup from a database to get the information needed.This information always varies so from day to day the amount of information on the spreadsheet can change. At the moment I have my graphs datasource as A1300 as 300 will be the maximum the data will ever reach. My graphs look terrible as sometimes the data only populates to A15 or A112. This is an automatic spreadsheet so I dont want to keep on having to change my graphs datasource to reflect the amount of information. Is there anyway for me to populate the information onto the graph automatically, So if one day the information is only from A15 the graphs datasource becomes A15 or if it is A150 the next day the graphs datasource becomes A150 automatically?

Regards

Djbell

 

[SkipVought]

Djbell,

Check out my FAQ...

How can I rename a table as it changes size faq68-1331

I suggest the OFFSET function in Insert/Name/Define to create DYNAMIC NAMED RANGES.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}