Auto update graphs?

[hedgie]

I have a large number of column graphs that show data through the current month. Currently I need to go in and update the ranges each month for each component of the graph. I would like to have a master field where I can indicate the range of data. All the graphs feed off the same data sheet, the only difference is in the columns. (Starting rows for each graph are not identical, but that can be hardwired.) Alternatively, if there was a way to define the range based on where the data ends, that would work. In other words, range= a1..A58 for June. Now that it is July, I added a number to A59, so I need the range to extend to A59.

Any thoughts?

 

[tusharm]

See
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
for a variety of possibilities.