I have a realtime data in a cell, how to create a line graph agains
time automatically

--
Message posted from http://www.ExcelForum.com

Do you mean like one of the examples on the Dynamic Charts page of my
web site?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

In article , netjerk
says...
I have a realtime data in a cell, how to create a line graph against
time automatically?


---
Message posted from http://www.ExcelForum.com/

I have a cell getting updated data from PLC. I need to compile thos
data into a line graph against time. Eg. the data fluctuate from 10 t
15 in an hour. I need to have the line graph showing the value at th
interval of every 5 minutes. So that I can see at which time the dat
is the max and min from the graph

--
Message posted from http://www.ExcelForum.com

Adapt the untested code below. It assumes the incoming data will be in
A1, and puts them in column B. Note that there is no protection
against column B overflowing.

Now, apply the idea on the Dynamic Charts page of my web site to the
contents of column B.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , netjerk
says...
I have a cell getting updated data from PLC. I need to compile those
data into a line graph against time. Eg. the data fluctuate from 10 to
15 in an hour. I need to have the line graph showing the value at the
interval of every 5 minutes. So that I can see at which time the data
is the max and min from the graph.


---
Message posted from http://www.ExcelForum.com/

And the promised code...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Target.Cells.Address < "$A$1" Then Exit Sub
If IsEmpty(Cells(1, 2).Value) Then
Cells(1, 2).Value = Target.Value
Else
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Value = _
Target.Value
End If
End Sub

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , netjerk
says...
I have a cell getting updated data from PLC. I need to compile those
data into a line graph against time. Eg. the data fluctuate from 10 to
15 in an hour. I need to have the line graph showing the value at the
interval of every 5 minutes. So that I can see at which time the data
is the max and min from the graph.


---
Message posted from http://www.ExcelForum.com/