Macros for charts/graphs...please help!!!

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.

no suggestions??

I don't know specifically how your sheet is laid out. Usually when I face that scenario, I just have the chart pull from a larger range than I ever expect the data range to fill. So if your data range is sometimes 5 rows, sometimes 20 rows, sometimes 15 rows, and so forth, I would set the chart to plot 30 rows.

If that won't work, then give us more details as to what you need and what your constraints are so we can give a better solution.