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


"Andy Pope" wrote:

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
"Bob" wrote in message
...
Andy thanks for that.
At the moment when I press the commanbutton(3) I can see the chart
underneath the active page?
--
Bob


"Andy Pope" wrote:

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bob" wrote in message
...
Andy,
Tried it and I get a syntax error message
--
Bob


"Bob" wrote:

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


"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bob" wrote in message
...
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.
--
Bob