Is it possible for charts to update to the last 20 rows automatically?

[aaronp]

I've been using excel for quite some time now but I am pretty new to charting. I have a spreadsheet that has a few charts on it and the sheet gets updated quite frequently....just wondering if there is a way I can design the charts to update to the last 20 rows automatically or if i have to do it manually every time the sheet updates? Thanks!

[Pete_UK]

Yes, it can be done automatically. If you want to be shown how, then attach a workbook so we can see what you are trying to do.

Hope this helps.

Pete

[aaronp]

I have been working on updating an old sheet to a new one. The new one has not had the charts made yet. There is 3 tabs that will have the charts. I will attach the new version so you can see how it will update itself and the old version so you can see what is being charted. Thanks so much!!

New: DC Charts 2013
Old: Ind X and MR Charts 2013

Also, don't click the macro # 1, "Update data". You will lose the charting data since you dont have the file it uses to update data.

[aaronp]

Any luck on that? (Sorry for the double post, did it for a bump as well)