updating prices for a line chart
Don't let the other program obliterate the previous prices. Charts only
chart data that is in the source data range, not what may once have been
there. Either move the previous data prior to the update, or have the update
place the new numbers in the next row.
- Jon
Thanks for that. That is the problem i have.
The prices can update every second, so copy and paste is not an
option.
There must be some code that lets the data feed the chart and then
move the data or let the chart be updated from different rows ?
|