Problem with Data Labels in Pivot Chart

[Shweta]

Hi All,

I have the data in below format.

[TABLE="width: 144"]
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]Subject[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Name[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Marks[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]English[/TD]
[TD="class: xl63, bgcolor: transparent"]A[/TD]
[TD="class: xl63, bgcolor: transparent"]10[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]English[/TD]
[TD="class: xl64, bgcolor: transparent"]B[/TD]
[TD="class: xl63, bgcolor: transparent"]16[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]English[/TD]
[TD="class: xl63, bgcolor: transparent"]C[/TD]
[TD="class: xl63, bgcolor: transparent"]20[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]English[/TD]
[TD="class: xl63, bgcolor: transparent"]D[/TD]
[TD="class: xl63, bgcolor: transparent"]11[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Math[/TD]
[TD="class: xl63, bgcolor: transparent"]A[/TD]
[TD="class: xl63, bgcolor: transparent"]17[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Math[/TD]
[TD="class: xl64, bgcolor: transparent"]B[/TD]
[TD="class: xl63, bgcolor: transparent"]14[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Math[/TD]
[TD="class: xl63, bgcolor: transparent"]C[/TD]
[TD="class: xl63, bgcolor: transparent"]15[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Math[/TD]
[TD="class: xl63, bgcolor: transparent"]D[/TD]
[TD="class: xl63, bgcolor: transparent"]18[/TD]
[/TR]
</TBODY>[/TABLE]

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:

[TABLE="width: 184"]
<TBODY>[TR]
[TD]Row Labels[/TD]
[TD]Sum of Marks[/TD]
[/TR]
[TR]
[TD]English[/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]A</SPAN>[/TD]
[TD="align: right"]10</SPAN>[/TD]
[/TR]
[TR]
[TD]B</SPAN>[/TD]
[TD="align: right"]16</SPAN>[/TD]
[/TR]
[TR]
[TD]C</SPAN>[/TD]
[TD="align: right"]20</SPAN>[/TD]
[/TR]
[TR]
[TD]D</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[/TR]
[TR]
[TD]Math[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]A</SPAN>[/TD]
[TD="align: right"]17</SPAN>[/TD]
[/TR]
[TR]
[TD]B</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD]C</SPAN>[/TD]
[TD="align: right"]15</SPAN>[/TD]
[/TR]
[TR]
[TD]D</SPAN>[/TD]
[TD="align: right"]18</SPAN>[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]121[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]

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