Hello friends. I found a nice 2006 Mary Richardson post </article/create-an-excel-chart-that-automatically-updates-with-new-data/> about automated charts in Excel. It is nice and works well as it automatically expands the chart when new data is added to the table. My question is, rather than the chart getting more and more data, how to make it limit itself to the last four rows of the table? It will begin using A2:B5, but when I enter data for row 6, I'd like it to use A3:B6. Any assistance is greatly appreciated.
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Automated Excel 2016 Charts
I found a nice 2006 Mary Richardson post </article/create-an-excel-chart-that-automatically-updates-with-new-data/> about automated charts in Excel. It is nice and works well as it automatically expands the chart when new data is added to the table.
My question is, rather than the chart getting more and more data, how to make it limit itself to the last four rows of the table? It will begin using A2:B5, but when I enter data for row 6, I'd like it to use A3:B6.
Any assistance is greatly appreciated.