I would like to create a Line Chart with the values from 2 cells.
1. Stock Price
2. Time
These two cells whose values get updated every minute using a Web Query.
How can i accomplish to plot and update the chart continously from the values of just these two cells.
Its easy if i have a range of cells and its straightforward.
Do i have to create a new row for every time the value in these cells updated and these set of rows act as a Data Table.
Please help me.
Thanks in advance.
Bookmarks