Hello,
I would like to adjust appearance for my 3D Column Chart which shows weekday distribution of sales/turnover/revenue for an item group (see screenshot).
1. I would like to show the bars stacked (not solid as on the screenshot) with each bar showing slices for contribution of each item (in the itemgrop) to item group's revenue. I know this is possible if I show only one row instead of three (either sales OR turnover OR revenue). Can I show all 3 rows and make the bars stacked?
2. Z-Axis now contains $-values (for turnover and revenue) and unit-values (sales) mixed together on one axis. There are properties (ultraChart.Axis) for a second Z-axis, but changing them doesn't help. Is it actually supported?
Many thanks.
Did you try a 3D Stacked Column Chart?
http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Chart_Working_with_3D_Stacked_Column_Chart_Data.html
Sung Kim"]Did you try a 3D Stacked Column Chart? http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Chart_Working_with_3D_Stacked_Column_Chart_Data.html
Yes. Without success. From my original message:
I know this is possible if I show only one row instead of three (either sales OR turnover OR revenue). Can I show all 3 rows and make the bars stacked?
I really am not sure what you are asking. I have attached an image of the chart I am seeing. Can you tell me what you would like to do differently?
Code used to render chart:
this.ultraChart1.ChartType = Infragistics.UltraChart.Shared.Styles.ChartType.Stack3DColumnChart;
this.ultraChart1.Legend.Visible = true;
DataTable dt = new DataTable();
dt.Columns.Add("Day", typeof(String));
dt.Columns.Add("Amount", typeof(int));
dt.Columns.Add("Revenue", typeof(int));
dt.Columns.Add("Turnover", typeof(int));
dt.Rows.Add("Sunday", 2000, 3000, 4000);
dt.Rows.Add("Monday", 6000, 1000, 11000);
dt.Rows.Add("Tuesday", 4000, 9000, 2000);
dt.Rows.Add("Wednesday", 1000, 5000, 4000);
dt.Rows.Add("Thursday", 6000, 2000, 3000);
dt.Rows.Add("Friday", 2000, 3000, 7000);
dt.Rows.Add("Saturday", 4000, 6000, 8000);
this.ultraChart1.Data.DataSource = dt;
this.ultraChart1.Data.DataBind();
For your 2nd question in your original post, multiple axis is only supported in 2d charts.
Here is a similar 2D chart(which I'm trying to achieve in 3D. But if I can build it with Infragistics WinChart in 2D, that will also do).
Low/Average/High/Maximum earners are days of week in my case (Monday, Tuesday etc.)
Private/FERS/CSRS are Sales/Turnover/Revenue
TCP/DS, Social Security, Base Pension are individual items (Nivea etc.) in the item group (Shampoos). These are the slices that constitute the bars
First of all, thank you for your help. Secondly, a short update on the issue "Secondary Z axis in 3D Charts":
David Negley has answered a similar question on Infragistics forums: http://forums.labs.infragistics.com/forums/p/13373/49411.aspx#49411"i see this was entered into our bug tracking system (#7677) by Infragistics Developer Support. i agree that it should be possible to show the Y2 axis labels here, although when I first looked at this issue, this seemed the 3D line chart was not designed to use that axis.anyway, we will fix this issue soon and Developer Support will let you know. "
I do not believe you can group the stacked columns. Your best bet is to use four different charts for each group of stacked columns, four different chart areas (would limit it to 2d, since composite charts are only in 2d, would also be more complex to create than 1st option), or you could do some sort of drilldown feature, where you can show the four groups in some high level view, which you can drill down further into by clicking on a specific column(i believe only 2d also).
If you do need different axis as well, you would be limited to 2d charts for that requirement as well.