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.
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.
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
1. My chart contains information about some item group (Shampoos). I have sales/turnover/revenue data about items which belong to this item group (Head&Shoulders, Pantene Pro-V, Nivea etc.).
2. Your chart contains only one row. My original chart contains 3 rows. I would like to keep this layout with 3 rows, i.e. revenue, turnover, and sales should not be stacked. They should be placed in 3 separate rows as originally
3. Instead of that I would like the bars to be stacked, providing the information given in (1). This means that each bar should have slices which show how much Head&Shoulders, Pantene Pro-V, Nivea etc. have contributed to the total turnover (for Sunday, Monday, Tuesday etc.).
Hope it helps
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.