Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hstaaks
 
Posts: n/a
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 04:45 AM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 2 May 3rd 05 02:23 AM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 0 May 2nd 05 11:50 PM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 0 April 29th 05 01:06 PM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 04:44 AM


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"