Thread: Excel updating source data issue...

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.