Jan
100
120
20.00%
Feb
130
-23.08%
Mar
160
70
-56.25%
Apr
200
-50.00%
May
180
140
-22.22%
Jun
170
190
11.76%
I have got the datas Month in the X- axis and Sales1 and Sales2 as the bar columns. I also need to have the growth marked on the graph. The growth values should be marked on the right Y-axis along with the growth points connected in the graph. I am using the following code which gives me a partial result.
Cmd = new SqlCommand (Procedure, Conn);
Reader = Cmd.ExecuteReader();
DT =
new DataTable();
DT.Columns.Add(
"Month", typeof(System.String));
"Sales1", typeof(System.Int32));
"Sales2", typeof(System.Int32));
"Percentage", typeof(System.String));
while(Reader.Read())
{
DT.Rows.Add(
new object[] { Reader.GetSqlValue(0), Reader.GetValue(1), Reader.GetValue(2), Reader.GetSqlValue(3) });
}
Reader.Close();
ultraChart1.Axis.Y.RangeType = Infragistics.UltraChart.Shared.Styles.
AxisRangeType.Custom;
ultraChart1.Axis.Y.RangeMin = 0;
ultraChart1.Axis.Y.RangeMax = 200;
ultraChart1.Axis.Y2.Visible =
true;
ultraChart1.Axis.Y2.LineDrawStyle = Infragistics.UltraChart.Shared.Styles.
LineDrawStyle.Solid;
ultraChart1.Axis.Y2.LineColor =
Color.White;
//ultraChart1.Axis.Y2.RangeType = Infragistics.UltraChart.Shared.Styles.AxisRangeType.Custom;
//ultraChart1.Axis.Y2.RangeMin = -70.00;
//ultraChart1.Axis.Y.RangeMax = 30.00;
//ultraChart1.Axis.Y2.TickmarkInterval = 10;
ultraChart1.DataSource = DT;
ultraChart1.Data.DataBind();
Any suggesstions?
Thanks & Regards
Ferdin
In order to format the appearance of the data value, such as font size or color, you can use FillScenegraph event to do get reference of the primitive and customize it. For more information please refer to the following help topic:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2009.1/CLR2.0/html/Chart_FillSceneGraph_Event.html
Hi, I iterated dinamically throught all columns and added the ChartTextAppearance for every column. Now I want to format values, in the same way, for the following chart types, but there is not the .ChartText.Add() method!
BarChart3DCylinderBarChart3DCylinderColumnChart3DLineChartLineChart3D
Which property/method must I use in this case?
I forget to tell you that I want to format all bars at the same time, not only one.
Thanks.
I want to format bars in the same way you do int this example. Could you post your code here? Thanks in advance!
Sam,
Thank you for the support which you gave me.
Sam atlast i got the chart as expected using the Composite chart which includes Column Chart as first layer and Scatter Chart as the Second layer.
Once again i thank you for the support.
Thanks