Self Expanding Graphs

[par0016]

I have a spreadsheet that I update with new data every day. Is there a way to have my graph automatically include the new data in the graph without me having to expand the data boxes daily? I have about 10 graphs from this data and it is a pain to have to update the data range daily. However, it does not help to have the data range box be larger than the data because then the graph's x axis is too large for the graphs to be of any use.

[Kyle123]

You can set a dynamic named range to your data and use this as the source for your graph

[mgaworecki]

I use the following code as a named range (it includes up to the last used cell in the range) and then use the named range as the data for the graph.

Please Login or Register  to view this content.

I also use the following code if it doesn't matter if the the value is greater than zero (or any other number):

Please Login or Register  to view this content.

You can adjust the column:row and greater/less than value as needed.

I hope that helps.

Mark

[par0016]

I've never used a named range before so I am unsure of what to do with this code? Do I use this code for each of the Series X and Series Y data with the respective column letter name inserted where "A" is in your code?