Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I graph an auto updating cell
I have a sheet with cells auto updating there contents by linking to a
data source out of excel can I use them as data source for a graph and how? Or saving them in another sheet by time for instance: time cell value 09:00:00 56 09:00:01 54 .............. ............ Reply With Quote |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I graph an auto updating cell
On May 15, 2:52 pm, wrote:
On May 15, 2:03 pm, "Jon Peltier" wrote: It's not too difficult. I usually put a formula in an unused cell that points to the cell with the link (like =B3) so that the change in the link initiates a worksheet recalc. I use a sheet event to act on the recalc. Right click the sheet tab, choose View Code. At the top of the code module that pops up in the VBE, select Worksheet from the left hand dropdown, and Calculate from the right hand dropdown. This code outline appears in the code window: Private Sub Worksheet_Calculate() End Sub Let's say you're taking the value in cell B3, and storing it in column F, and the time in column E. This is the code you would use: Private Sub Worksheet_Calculate() Dim iRow as Long iRow = Me.Range("F65536").End(xlUp).Row Me.Range("E1:F1").Offset(iRow).Value = Array(Now, Me.Range("B3").Value End Sub Of course, a little validation and error proofing would help as well. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... On May 15, 4:39 am, "Jon Peltier" wrote: I have a sheet with cells auto updating there contents by linking to a data source out of excel can I use them as data source for a graph and how? Or saving them in another sheet by time for instance: time cell value 09:00:00 56 09:00:01 54 Some kind of DDE link? This is generally done by capturing the Worksheet_Calculate event when the linked cell updates, then saving the value with a time stamp in another range. This range can then be plotted. Reply With Quote If you'd like a proposal, follow up to my email address: jon at peltiertech dot com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ Thanks Jon Peltier, Yes it's a dde link This is generally done by capturing the Worksheet_Calculate event when the linked cell updates, then saving the value with a time stamp in another range. This range can then be plotted. That's exactly what i need ; but how to do it? Is it a direct or require some tempering ? Jon, thank you very much for your help clear and simple I'll try it Thank you very much indeed It did work very fine as expected |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell auto-updating | Excel Worksheet Functions | |||
auto updating cell values | Excel Programming | |||
auto updating cell values | Excel Programming | |||
auto updating cell values | Excel Programming | |||
auto updating cell values | Excel Programming |