Stackedcolumn chart not aggregating

[Sridhar]

Hi,
Iam trying to use a OWC10 Chart control to draw a stacked column graph.
I have two values to plot

Y - axis - 500, 1000

I want the graph to show both 500 and 1000 as stacked and total as 1500.
But for me it is showing only the bar for 1000. It is hiding the bar for 500.
How to turn on the aggregation?
Could any of you please help me?

 

[Thao Moua [ms]]

I cannot repro your issue. Can you tell me more about where your data is
coming from? Which stack chart type are you using (bar/column)?

Aggregation only applies when your chart is bound to a pivottable or a SQL
server.
----------------------------------------------------------------------
Thao Moua
OWC Chartspace Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[Sridhar]

Thanks a lot thao moua. Sorry for the late response, as i was out for
vacation, i didn' t look into this issue for a few days. Yes, i can clearly
explain you.

Consider an example, If iam plotting a graph to compare the CPU speed for
various processors. Let's take for example

My X- axis - CPU Speed
Y - axis - Multiple processors

Pentium (GHz) Celeron(GHz) AMD(GHz)
IBM(GHz)
CPU Speed 10 20 30
40

When i plot a stacked column graph in MS-office Excel application, I select
the option, series in column. So i got the graph in a single column, which
shows four processors in four different colours. It showed pentium (10) with
blue. Then above the pentium, it showed the celeron (20) with red. Then above
celeron, AMD(30) with green. Then above AMD, IBM(40) showed with maroon. So
all the four in one column, my y - axis adds up these four, so it goes from 0
to 100.

When i try to plot the same graph in OWC10 chart component through VB.net
Code. My OS is Windows 2000 Professional. Office XP.
Iam getting the graph but it shows only the IBM(40) with maroon. Y-axis goes
from 0 to 40. Iam not able to see the pentium, celeron, AMD. I want my graph
to be as it is in Excel application. My y axis should show 4 colours. It
should be from 0 to 100.
Please help me, should i set any properties to the chart to get the four
colours in one column.

Thanks & Regards,
Sridhar

 

[Sridhar]

One more information i found. When iam plotting the graph using OWC, iam able
to get the four colours in single column. But when iam using OWC10, iam
getting only the maroon colour alone. Can anybody please clarify me, any
change done in OWC10.