Changing how data is plotted with a PivotChart?

[Joycelet]

Hi

I'm using a pivot table to plot a chart - if I only plot on person the chart works fine, but I will need to plot by numerous people.

The chart is a stacked chart so will show for each month stacked data based on A, B and C for each person.

But when I add a person to my pivot table - the chart doesn't plot a new stacked column for each person by month but combines them?

Example of data
Person A Person B
A B C A B C
Jan 30% 50% 40% 50% 10% 5%
Feb 45% 20% 40% 40% 0% 0%
March 5% 7% 8% 68% 10% 0%

Hope I've explained this OK - I can send sample data if it helps

Thanks in advance
Nicola