generate chart with excel

[netjerk]

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

 

[Tushar Mehta]

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

 

[netjerk]

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

 

[Tushar Mehta]

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

 

[Tushar Mehta]

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