Add detail on hover in a pie

**libby1** · 10-20-2009, 11:30 AM

Hi.

I want to find a way to get a detail hover over in a summary pie.

In the attached xls I created a pie from a summary. When I hover over I get the series, point, etc. For example:
Series fruit, point apples, value 40 (8%)

But what I really want is the detail broken apart by type. For example, if I hover over apples, I want to see:

delicious, 10
macintosh, 15
gravenstein, 2
braeburn, 8
ida red, 5

Am I using the right approach with a pivot table? Is there a better way without using vb?

I appreciate your help.
Libby

**Andy Pope** · 10-20-2009, 11:43 AM

Changing the contents of the chart tooltip requires complex VBA code and is not that good.

You need to change the style of chart so you can make sense of the numbers.
If you add Type to the Row Fields you will get multi-level grouping,

**libby1** · 10-20-2009, 03:08 PM

Thanks Andy.
However that does not give me a view that compares the apples to other fruit, the primary goal of the pie. The type subtotals for the hover are secondary.

Is there any other way to make a pie in excel that would afford that kind of flexibility without using vb? Any way to make an array that might be input with master detail info to show on the hover?
Thanks
Libby