Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click on a Pie Chart
Hi,
I'm pretty sure this isn't possible but..... I've been asked if it's possible to click (or double click) on a slice of a pie chart and jump to the data it represents (the same as you can in a pivot table). Many thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click on a Pie Chart
I can't speak for 2007, but I recall a few years ago I was looking at making
a pie chart clickable to "drill down" in 2003, updating the pie chart to show the component measures of the wedge that was clicked on. It appeared to be possible using VBA, but then the project was terminated before it really started. I can't find a reference for pie charts, but take a look at the solutions provided here http://www.excelforum.com/excel-char...clickable.html and look under dynamic charts (along with plenty of other useful links) and VBA charting techniques at http://peltiertech.com/Excel/Charts/ChartIndex.html The basic premise is figuring out what was clicked on (under the VBA charting techniques in the second link), and then just grab the source range and activate it. HTH, Keith "Dazed&Confused" wrote: Hi, I'm pretty sure this isn't possible but..... I've been asked if it's possible to click (or double click) on a slice of a pie chart and jump to the data it represents (the same as you can in a pivot table). Many thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double click on chart column to get another chart | Charts and Charting in Excel | |||
Click Chart to go to data? | Charts and Charting in Excel | |||
Zooming in chart by 2 click ?? | Charts and Charting in Excel | |||
Get a value out off a chart just by a mouse click | Excel Programming | |||
Right Click disabled for Chart only | Charts and Charting in Excel |