Excel updating source data issue...

[Dagwood2005]

I have a chart/graph in excel. Each morning I import fresh source data into a worksheet named “A” and it alters the graph (located in a worksheet named “B”) according to what the new data indicates. However, each morning I have to manually adjust the source data values to depict the full range of values, since with each new data set the number of values changes. How do I write a macro that automatically adjusts the source data values so I don’t have to manually correct them? I’ve been struggling with this for a few days and have been unable to get anywhere.

Thanks.

[mrice]

Have you tried using a named range as the source data for your graph and just changing the name for the new data?