greengo204
Technical User
I have created a Pie chart from an existing Pivot table. The chart itself is working fine my question is that when i hover over the pie chart segment to see the total figure that makes up that segment, excel displays the figures for the first period that ive selected and not the total of the periods.
e.g.
Period Count
1 100
2 150
3 175
4 200
if i select Period 1,2,3,4
and i hover over the segment excel displays "period 1 100" instead of ~ "Total Periods 625".
The pie chart segment are apportioned correctly for the totals, its just when you hover over them to see the breakdown that the figures aren't represented correctly.
Does anyone know how i can get excel to display the correct figures without setting up a pivot table that only uses totals?
e.g.
Period Count
1 100
2 150
3 175
4 200
if i select Period 1,2,3,4
and i hover over the segment excel displays "period 1 100" instead of ~ "Total Periods 625".
The pie chart segment are apportioned correctly for the totals, its just when you hover over them to see the breakdown that the figures aren't represented correctly.
Does anyone know how i can get excel to display the correct figures without setting up a pivot table that only uses totals?