I have a client that has MS Excel 2000 bar charts made from worksheet data
series.
He wants to be able to click on a chart object such as a bar and have the
source data come to the front.
I have tried to put buttons over the chart but I can't change the button
color to match the chart.
I can change the chart bar to be the gray color of the button but that is
not desirable.
Is their a way to send the button to the back behind the chart and still get
the button to respond to a click?

Is there any way to turn a worksheet cell into a button?
The only way I can see is to place a button over a cell and make it
transparent with no caption.
Also there seems to be no way to change the button border to transparent or
match cell.

I have used a ActiveX button, but also tried a Form button.
The ActiveX is switched from design to run mode via the Control Toolbox
Design Mode button.
But the Form button remains in design mode. How do I get it out of design
mode?

Sorry for all the questions. Have search Help but can't get answers.

Skillman Hunter