Pivot Chart only charting one series when Pivot Table shows two C# and ASP.net

[Chance1234]

I have my pivot table

I have two dataaxis in my pivot table


sb.Append("<script>document.all.pTable.ActiveView.DataAxis.InsertTotal(document.all.pTable.ActiveView.Totals('[Measures].
[Result]'))</script>");

sb.Append("<script>document.all.pTable.ActiveView.DataAxis.Totals('[Measures].
[Result]').NumberFormat = '##%'</script>");


sb.Append("<script>document.all.pTable.ActiveView.DataAxis.InsertTotal(document.all.pTable.ActiveView.Totals('[Measures].
[KPI Target]'))</script>");

sb.Append("<script>document.all.pTable.ActiveView.DataAxis.Totals('[Measures].
[KPI Target]').NumberFormat = '##%'</script>");


Next I am creating my pivot chart object and linking it ot my pivot
table

sb.Append("<object id='pChart' classid='clsid:0002E55D-0000-0000-
C000-000000000046' style=width:100%;height:80%></ ></object>");
sb.Append("<script>document.all.pChart.DataSource =
document.all.pTable</script>");


But on the Chart I only get The Result Dataaxis being charted.

Going through the object model , I cant work out whetheri need to code
this as a seriescollection.add or something else ?