Macro to update line chart

[hreyo25]

Hello all I have a line chart that constanlty has new data added to it. I was wondering if there is a way to define the line chart range based on the first and last cell in a column. For instance if a new row of dates was inserted the chart would automatically update. Thanks for any advice

 

[Hui]

Hreyo

Yes

These are typically known as Dynamic Ranges or Named Formula

Have a read of: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

 

[hreyo25]

Thank you for the quick response this is great information