Auto-size data range for Excel Chart

[cpc34]

I am outputing data from Access into Excel in order to show how the data changes over time. I have produced a Chart in excel to do this, but I don't want to have to change the data range every time I re-generate the data in the spreadsheet.
Can Excel automatically fit the data range around the occupied cells in a column?

 

[SkipVought]

Hi,

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

If the dynamic range is named MyRange on Sheet1, then in the series value/category...
[tt]
=Sheet1!MyRange
[/tt]


Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}