|
|||||||||||||||||||||
|
|||||||
![]() |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Multiple charts in ChartSpace; problems with double Categories
Jon Peltier Wrote: > 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: > > - > 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. > > > -- > hstaaks > -- Okay.. thank you.. guess nobody knows an answer to my problem then -- hstaaks |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|