Problem with Data Labels in Pivot Chart

[Shweta]

Hi All,

I have the data in below format.

Subject	Name	Marks
English	A	10
English	B	16
English	C	20
English	D	11
Math	A	17
Math	B	14
Math	C	15
Math	D	18

<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>

I created a pivot table on this data. Subject and Name in Row Labels and Sum of Marks in Values. Pivot will look like this:

Row Labels	Sum of Marks
English	57
A</SPAN>	10</SPAN>
B</SPAN>	16</SPAN>
C</SPAN>	20</SPAN>
D</SPAN>	11</SPAN>
Math	64
A</SPAN>	17</SPAN>
B</SPAN>	14</SPAN>
C</SPAN>	15</SPAN>
D</SPAN>	18</SPAN>
Grand Total	121

<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>

Then I created a pivot chart on the above pivot table and added data labels to it. Now the problem is with the data labels.

Data Labels look like "English A 10", "Math A 17" and so on. while this should be like "A 10", "A 17" and so on...

I am unable to find any option for this. Please help me out with a appropriate solution.

Thanks in advance!

Regards,
Shweta

 

[pbornemeier]

What version of Excel are you using? What type of pivot chart are you using?
If you have two columns (or segments) with data labels "A 10" & "A 17", how do you know which is Math and which is English