Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER' | Excel Discussion (Misc queries) | |||
How do I make it so that the active cell follows the cursor keys? | Excel Discussion (Misc queries) | |||
How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
How do I make the fill color of a cell on one sheet follow the co. | Excel Worksheet Functions |