how do i make a chart follow the active cell
 

I have a worksheet that has frozen panes. I need the chart that is on the
worksheet to be visible wherever the cursor is. is this possible?

how do i make a chart follow the active cell
 

Hi,

That would require VBA code. This example places the chart to the right
of the active cell.
Add this to the sheet code module which contains the chart object.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

With Target.Parent.ChartObjects(1)
.Top = Target.Cells(1).Top
.Left = Target.Cells(1).Left + Target.Cells(1).Width
End With

End Sub

Cheers
Andy

mepetey wrote:
I have a worksheet that has frozen panes. I need the chart that is on the
worksheet to be visible wherever the cursor is. is this possible?

how do i make a chart follow the active cell
 

Thanks!

"Andy Pope" wrote in message
...
Hi,

That would require VBA code. This example places the chart to the right of
the active cell.
Add this to the sheet code module which contains the chart object.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

With Target.Parent.ChartObjects(1)
.Top = Target.Cells(1).Top
.Left = Target.Cells(1).Left + Target.Cells(1).Width
End With

End Sub

Cheers
Andy

mepetey wrote:
I have a worksheet that has frozen panes. I need the chart that is on the
worksheet to be visible wherever the cursor is. is this possible?