Link embedded chart to a commandbutton?

[Bob]

I have a embedded chart which I wish to show the chart when I press a
commandButton and hide the chart when I press either the same button or
another one.

 

[Andy Pope]

Hi,

The basic code would be, which will toggle visibility of first chartobject
on sheet.

Sub Button2_Click()

ActiveSheet.ChartObjects(1).Visible = Not
ActiveSheet.ChartObjects(1).Visible

End Sub

Cheers
Andy

 

[Bob]

Many thanks Andy, I shall try that out on friday when i am back at work

 

[Bob]

Andy,
Tried it and I get a syntax error message

 

[Andy Pope]

Probably because of the email formatting.

The syntax should be on 1 line.

Sub Button2_Click()

ActiveSheet.ChartObjects(1).Visible = _
Not ActiveSheet.ChartObjects(1).Visible
End Sub

Cheers
Andy

 

[Bob]

Andy thanks for that.
At the moment when I press the commanbutton(3) I can see the chart
underneath the active page?

 

[Andy Pope]

Sorry I don't understand what you mean?

On a worksheet enter 1,2,3 in cells A1:A3
Select A1:A3 and insert a chart on to the worksheet.
Using the Forms toolbar add a button to the worksheet.
Right click the button and assign macro.

The code should be in a standard code module.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy thanks for that.
At the moment when I press the commanbutton(3) I can see the chart
underneath the active page?

 

[Bob]

Andy,
I works well now Thanks very much
--
Bob

Sorry I don't understand what you mean?

On a worksheet enter 1,2,3 in cells A1:A3
Select A1:A3 and insert a chart on to the worksheet.
Using the Forms toolbar add a button to the worksheet.
Right click the button and assign macro.

The code should be in a standard code module.

Cheers
Andy