Dynamically updating chart

[NMB311]

I would like to create a line chart that updates daily. I think I've gotten the data to update and show up automatically, I just can't figure out the chart. Basically, I want to have the chart to add the values from each day as the days happen, but to not display future dates and values. Hopefully that's understandable.

 

[Magriza]

Hello,

You don't update the chart automatically, rather the chart points to a named range that will dynamically update when the data does. This is usually done with the optional width or height arguments of the OFFSET function.

In order to be able to help you further it'd be useful if you'd post a sample of your data so that we know how to structure a solution.

 

[NMB311]

Thanks for replying so quickly. I'll play around with the OFFSET function a little bit and see what I can figure out. I'll post my data if I can't. Thanks again!