Here is one I use to chart a column from a double click event in sheet code.
This is more complicated that you need. I must leave the office for the day
but can help tomorrow.
Modify to suit.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column 1 And Target.Row = 3 Then
[f1] = ActiveCell.Column - 1
'[f2] = Replace(UCase(Cells(3, ActiveCell.Column)), "^", "") _
'& " From " & [symbols!b2] & " To " & [symbols!c2]
[F2] = Cells(3, ActiveCell.Column) & " From " & [symbols!b2] & " To " &
[symbols!c2]
Sheets("Chart").Select
End If
End Sub
--
Don Guillett
SalesAid Software

"Patti" wrote in message
...
I'm sure I saw a web page that showed how to create a dynamic chart that
allowed you to move your cursor to any row and have the chart update with
the
data from that row. Does anyone know of a URL for something like this?

Thanks!

Patti