Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Macro for multiple charts | Excel Worksheet Functions |