View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] chazzer709932317@aol.com is offline
external usenet poster
 
Posts: 3
Default 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 ?