generate chart with excel
 

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

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

generate chart with excel
 

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/

generate chart with excel
 

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

generate chart with excel
 

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/

generate chart with excel
 

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/