Dynamically Update Chart With Latest X Columns Of Data As New Data Is Updated

[larryt1940]

Can be done with a few simple formulas and named ranges. Here's a sample. Post back if you need clarity on how to use it.

Excel Fox, Thank you. Looking at the code, I believe this will work. Will try it with the charts tomorrow.