Stacked Column Category display

[Jo Inferis]

I'm using OWC10 to generate a dynamic chart in my web application and a user
has come across a curious issue. They've developed a report which has 3
columns e.g.

A B C
a1 b1 c1
etc.

but the stacked column chart I'm generating is only based on the first two
columns. Each row of the table is distinct when you take into account all
three columns, but when plotting only A vs B there are repetitions on the
category axis. Is there a way to make OWC plot these repetitions?

i.e.

I want to do :

myDataSet.SetData(chDimCategories, chDataLiteral, "a1,a2,a3,a1,a2");
myDataSet.SetData(chDimValues, chDataLiteral, "b1,b2,b3,b4,b5");

but have the last two columns displayed along with the rest, when currently
they're just ignored.

any help greatly appreciated!

 

[Alvin Bruney [MVP]]

Did you resolve this issue?

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc