No one seems to know how to do this...do you?

[cjgovi]

I have one cell in excel 07 whose data (it is a number) is fed from an outside source.

this cells data updates every second.

how can i plot the data in a chart so it plots the data live as the data updates every second.

when i tried, it just plots the one point in a graph and as the data updates the point changes too...but it doesnt plot the points together so in one minute for example i should see 60 points on my graph.

i would really appreciate it if someone knew how to do this.

christian

 

[SamTYler]

Put a public counter variable in a standard module then use the

Private Sub Worksheet_Change(ByVal [I]Target[/I] As Range)  [I]Event[/I]

to add the new value to a new sheet using the public counter to keep track of which cell to add it to.

Then point your chart to the new sheet.

 

[tusharm]

"No one" is a very strong claim. If you want to solve a problem just ask. I don't see the value of trying to it seem to be more challenging than something that no one including people like Stephen Bullen with his Previous.zip at http://www.bmsltd.co.uk/Excel/Default.htm have solved in the decades that Excel has been around. {grin}

I have one cell in excel 07 whose data (it is a number) is fed from an outside source.

this cells data updates every second.

how can i plot the data in a chart so it plots the data live as the data updates every second.

when i tried, it just plots the one point in a graph and as the data updates the point changes too...but it doesnt plot the points together so in one minute for example i should see 60 points on my graph.

i would really appreciate it if someone knew how to do this.

christian