ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-04-2005, 01:06 PM
hstaaks
Guest
 
Posts: n/a
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
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 10:03 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0