Forum Discussion
live chart
Good morning to all.
Can anybody teach me how i can plot a live line chart in excel sheet taking values of say cell A1 and B1 as two axes of line chart where A1 shows current clock time and B1 shows a live value fetched from another excel sheet which keeps changing every second.
Also kindly say how i can stamp current clock time showing hour,minute and second in cell A1.
2 Replies
Tutorial: Visualize Streaming Data in Excel
Creating a chart from streaming data helps maximize the visual impact of your data for your audience. Learn below how to create dynamic charts from your streaming data.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Thanks a lot for your inputs.
(assume a value changes every second and i want a data table of time vs value)
It will be so kind of you if you can tell how i can stamp updated time in hr:min:sec format in cells of succesive rows in every second.
Similarly how i can stamp updated value(numbers with decimals) in cells of successive rows every second.
