Chart drilldown to data
 

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

Chart drilldown to data
 

Hi,

Read Jon Peltier's article on chart events.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

Cheers
Andy

Skillman Hunter wrote:
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

Chart drilldown to data
 

You can make a rectangle that responds to clicks by assigning a macro to it.
The rectangle can be formatted much more flexibly that a button, you could
even make it transparent.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Skillman Hunter" wrote in message
...
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