Worksheet Change Issue

[fish]

Hello

I am doing a date / time update to a cell per worksheet with the following code.

Private Sub Worksheet_Change(ByVal Target As Range)

Range("o2").Value = Format(Now, "[$-409]dd/mmm/yy h:mm AM/PM;@")

End Sub


The problem I am having is the work sheets have Graph's whose source data is on a different worksheet. When the source data changes, the Graph updates but it does not update the current worksheet_change event.

Any ideas on how to make a Graph change trigger this event.

Thanks