Can I Hyperlink Pie Chart Segments?

skinnea

Board Regular
Joined
Mar 15, 2003
Messages
135
Office Version
  1. 365
Platform
  1. Windows
I want to Pie Chart a set of closure codes (Successful, Failed, Cancelled, Rejected), each of which has 5 sub-codes (Failed with backout, Failed with impact, Rejected due to Conflict, etc etc).

When I Pie Chart the main codes I'd like to be able to click on, say, the Failed segment and have it take me to a Pie Chart for the Failed sub-codes.

Any way I can do this? :confused:

The alternative is of course just to have hyperlinks in cells to take me to the sub-code Pie Charts, but it isn't as funky! :cool:
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
I've been thinking of this since I first saw your post yesterday. There is a way to do it. However, the methods (PivotTables or array formulas) I would use to do this kind of analysis would not be amenable to drill down via VBA.

Nonetheless, how are your data organized and how do you create the subcharts and the main chart?
 
Upvote 0
I was planning to use Pivot Tables, but would be open to other suggestions or ideas?

My data is organised as a straight extract from a reporting tool, so is rows and rows of data split by the same column heading (a standard data extract in fact).
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top