How can i automatically update a chart with a new point to be plotted after entering new data?
How can i automatically update a chart with a new point to be plotted after entering new data?
Hi,
If the new data is entered in a new row or column between existing data points then the chart series ranges should adjust automatically.
If not then first create a dynamic range name for your data - say 'mydata' e.g.
Formula:Please Login or Register to view this content.
where rows 1:xx andcolumns A:?? contain the table of data
Then right click in the chart, choose Select Data and replace the rage reference with 'mydata'
This will update the chart. However, and I guess it's an anomaly/bug but when you hit enter the name gets converted back to an A1 reference so although the chart now reflects the latest data, when you add a new data point below or to the right of the data, although the range covered by the name changes since the name has been converted back to the A1 ref. the chart doesn't update.
The work around that I use is to use a sheet change event macro
Please Login or Register to view this content.
so that every time you change a value covered by the name 'mydata' the sheet the chart is forced to update.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
thanks richard.
i don't understand ''dynamic range data''so i will start googling/researching.
in the meantime ... do you have any reference suggestions about ''dynamic range data''?
This is one I frequently recommend: http://peltiertech.com/dynamic-charts/
I will also note that I rarely use this. In the charts I tend to build (scatter charts), I simply extend the range definition so it is large enough to include the maximum amount of data I ever expect to have in the chart. If my current used range goes from 10 to 20, I will define the range in the chart so that it extends from row 10 to row 200. Then, the data automatically appear in the chart as they are added to the list.
Originally Posted by shg
thanks everyone
you guys are one heck of a great resource.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks