Hi Guys,
I'm wondering if there is a way to create a chart using values only from a single cell, that change throughout the day.
In particular, I have real time data flowing into a single cell which updates approximately every minute. I want to create a chart based on these values for the day. I only want to see data for that data in the chart so would like for it to reset every day - even if I have to do it manually somehow.
I think there might be a way to copy values of this cell into a seperate column every minute and then have a chart linked to that column. However, I'm not quite sure how to do that or if there is a better way to do it.
Any help would be GREATLY appreciated.
I'm wondering if there is a way to create a chart using values only from a single cell, that change throughout the day.
In particular, I have real time data flowing into a single cell which updates approximately every minute. I want to create a chart based on these values for the day. I only want to see data for that data in the chart so would like for it to reset every day - even if I have to do it manually somehow.
I think there might be a way to copy values of this cell into a seperate column every minute and then have a chart linked to that column. However, I'm not quite sure how to do that or if there is a better way to do it.
Any help would be GREATLY appreciated.
