Is a self-growing line graph possible?

[TRLWNC]

I have an input spreadsheet that receives information daily. I need to take this info and output it on a graph.

The problem is, sometimes I have less than 30 inputs, sometimes I have almost 1000.

Is there a way to update, or grow, a graph continuously as the information is added, or do I have to generate a new graph after each input?

I'm barely into VBA, so I don't have a clue what THAT could do.

I'm fine with an indirect answer if there is a website that could help me understand the process.

Thanks.

[mikeTRON]

You can use a dynamic named range instead of a fixed name range.
http://www.excel-easy.com/examples/d...med-range.html

Post a sample workbook and I can probably assist.

[TRLWNC]

That is awesome. I didn't know what to search for, and this looks like it will answer my question perfectly. Thanks!

[mikeTRON]

Sure. If you need specific help post a sample workbook and we can assist.

[Jon_Peltier]

Even easier than setting up defined names is to use a table for your data.

Set up the data in columns, then select the range and on the Insert tab of the Ribbon, choose Table. Then make your chart from this data.

When you add data to the next row of the Table, it expands to include the added data. The chart will then update to include the expanded table.

See my tutorial Easy Dynamic Charts Using Lists or Tables