I have two charts that I would like to convert to real time. Currently I am using the "link" feature.
I think real time will be a better way for updating the charts?
I read something about "offset" online, but I could not comprehend how to do it.
The data is on tab "DATARUW",
Both charts are on the orange tab "PS".
Data is pulling from DATARUW, row10 and Row 40.
Can you help me with the conversion?
Hi Mymalone,
Thanks for sharing your file, however you don't have a tab called 'PS', but you do have an orange tab called 'SM' with charts on it, so I assume that's what you mean.
Also, the data is not coming from rows 10 and 40 on the DATARUW sheet, it's coming from row 23.
Anyhow, this post explains how to create dynamic named ranges:
https://www.myonlinetraininghub.com/excel-dynamic-named-ranges
And this link will show you how to use them to your chart - see heading "Dynamic Named Ranges in Charts".
See how you get on, and if you get stuck, please come back with your updated file so we can see where things went wrong.
Mynda
