Multiple charts in ChartSpace; problems with double Categories

H

hstaaks

Jon said:
Office Web Components.

This is an issue I need to investigate for one of my clients, but I
haven't gotten
that far down the list yet.

- Jon

John Mansfield wrote:-
It would help to know if you are using Excel VBA, .NET, or something
else.
Also, what do you mean by Chartspace? Are you trying to build
embedded
charts, chart sheets, or some combination of the two?

Regards,
John Mansfield
http://www.pdbook.com


:

-
hstaaks Wrote:
-
I want to show two or more charts with different categories and data
in
one chartspace, so I did the following:

1. Create Chartspace
2. Add Chart1 in Chartspace
3. Add Series in Chart1
4. Series.SetData chDimCategories 'A,B,C'
5. Series.SetData chDimValues '5,2,6'

Now I see a chart with categories A (value=5), B (value=2) and C
(value=6). So everything okay. Next thing I do:

6. Add Chart2 in Chartspace

Now I see a second empty chart, BUT WITH already filled categories A,B
and C!! I don't want this, because I want to use other categories in
this second chart2.

And when I SetData chDimCategories 'F,G' on this chart2, I see
'A,B,C,F,G' in categories in this chart2. But also 'A,B,C,D,F,G' in
chart1!!!!!!!

Please could someone explain to me how this works and if and how I can
make two different charts with different categories??? Please help...-

Nobody any idea or help?? I need a solution very quick, because it's
needed in our software.
Okay.. thank you.. guess nobody knows an answer to my problem then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top