Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
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 | |||
Copy multiple charts from Excel to Power Point | Charts and Charting in Excel | |||
Multiple charts | Charts and Charting in Excel | |||
Macro for multiple charts | Excel Worksheet Functions |