Adding a button on a Pivot Table Chart

[jqzhang]

Hi,
I tried to add a button on a pivot table chart (like RETURN or GO BACK) but failed because the Excel wouldn't let me.
Is there any way we can make it doable?
Thanks and happy holidays.
jqzhang

 

[SkipVought]

Hi,

On any Chart Sheet, you cannot add a Control Toolbox Control. However, you can add a Forms Control, which has fewer control properties, but enough to do what you are looking for, I believe.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[jqzhang]

Skip,
I will try what you told me but now I found a second best way of handling it. I cut and pasted a chart to another sheet where I can easily set up buttons. I couldn't believe that the charts functioned well. I thought as I copied the charts, the data behind the charts would be gone but actually they were not.
Thanks.
jqzhang

 

[SkipVought]

You don't have to copy 'n' paste charts.

Just access the Chart/Location property.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]