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
Bookmarks