composite charts | Infragistics Forums

I modified the code in the past few days and have reached a point where I am able to plot the charts. I have a problem and it could be becoz I am probably unaware of what to use for my specific purpose. I have a dataset X = datetime , Y = numeric , Y2 = numeric. Fill in any values you want its just that Y is always positive and Y2 is always negative with a few 0 values. My problem is even though I get both lines and both the Y axis have the ranges I set, the Y2 line doesnt originate from Y2 axis, it still belongs to Y axis. So for the longest time I couldnt se the y2 line and then I changed the Y axis range to from e.g. 0 to 20 to -20 to 20. Following is the code

protected void Page_Load(object sender, EventArgs e)

{

chart.ChartType = ChartType.Composite;

// Add the chart area.

ChartArea myChartArea = new ChartArea();

chart.CompositeChart.ChartAreas.Add(myChartArea);

AxisItem xAxis = new AxisItem();

xAxis.OrientationType = AxisNumber.X_Axis;

xAxis.Labels.Orientation = TextOrientation.Custom;

xAxis.Labels.OrientationAngle = -26;

xAxis.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near;xAxis.Labels.VerticalAlign = System.Drawing.StringAlignment.Near;

xAxis.DataType = AxisDataType.Time;

xAxis.SetLabelAxisType = SetLabelAxisType.ContinuousData;

xAxis.Labels.Visible = true;

xAxis.Labels.ItemFormat = AxisItemLabelFormat.ItemLabel;

xAxis.TickmarkStyle = AxisTickStyle.Smart;

xAxis.MajorGridLines.Visible = true;xAxis.Visible = true;

chart.CompositeChart.ChartAreas[0].Axes.Add(xAxis);

AxisItem y2Axis = new AxisItem();

y2Axis.OrientationType = AxisNumber.Y2_Axis;

y2Axis.DataType = AxisDataType.Numeric;

y2Axis.TickmarkStyle = AxisTickStyle.Smart;

y2Axis.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near;

y2Axis.Labels.VerticalAlign = System.Drawing.StringAlignment.Near;

y2Axis.Labels.Layout.Behavior = AxisLabelLayoutBehaviors.Auto;

y2Axis.Labels.Visible = true;

y2Axis.Labels.ItemFormat = AxisItemLabelFormat.DataValue;

y2Axis.MajorGridLines.Visible = true;

y2Axis.RangeType = AxisRangeType.Custom;

y2Axis.RangeMin = -15;

y2Axis.RangeMax = 0;

chart.CompositeChart.ChartAreas[0].Axes.Add(y2Axis);

AxisItem yAxis = new AxisItem();

yAxis.OrientationType = AxisNumber.Y_Axis;

yAxis.DataType = AxisDataType.Numeric;

yAxis.TickmarkStyle = AxisTickStyle.Smart;

yAxis.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near;

yAxis.Labels.VerticalAlign = System.Drawing.StringAlignment.Near;

yAxis.Labels.Layout.Behavior = AxisLabelLayoutBehaviors.Auto;

yAxis.Labels.Visible = true;

yAxis.Labels.ItemFormat = AxisItemLabelFormat.DataValue;

yAxis.MajorGridLines.Visible = true;

yAxis.RangeType = AxisRangeType.Custom;

yAxis.RangeMin = -20;

yAxis.RangeMax = 20;

myChartArea.Axes.Add(yAxis);

// Create a data series.

NumericTimeSeries series = new NumericTimeSeries();

series.Key = "Value";

series.Label = "Value";

series.Data.DataSource = getData();

series.Data.TimeValueColumn = "Date";series.Data.ValueColumn = "Value";

chart.CompositeChart.Series.Add(series);

NumericTimeSeries series2 = new NumericTimeSeries();

//NumericSeries series2 = new NumericSeries();

series2.Visible = true;

series2.Key = "Value2";

series2.Label = "Value2";

series2.Data.DataSource = getData();

series2.Data.TimeValueColumn = "Date";series2.Data.ValueColumn = "Value2";

chart.CompositeChart.Series.Add(series2);

// Create a ChartLayerAppearance for the series.

ChartLayerAppearance seriesLayer = new ChartLayerAppearance();seriesLayer.ChartType = ChartType.LineChart;

seriesLayer.ChartArea = chart.CompositeChart.ChartAreas[0];

seriesLayer.AxisX = xAxis;

seriesLayer.AxisY = yAxis;

//seriesLayer.AxisY2 = y2Axis;

chart.CompositeChart.ChartLayers.Add(seriesLayer);

seriesLayer.Series.Add(series);

seriesLayer.Series.Add(series2);

ChartLayerAppearance y2layer = new ChartLayerAppearance();

y2layer.ChartType = ChartType.LineChart;

y2layer.ChartArea = chart.CompositeChart.ChartAreas[0];

y2layer.AxisX = xAxis;

y2layer.AxisY2 = y2Axis;

chart.CompositeChart.ChartLayers.Add(y2layer);

y2layer.Series.Add(series2);

y2layer.Visible = true;

}

private DataTable getData()

{

DataTable table = new DataTable();

table.Columns.Add("Date", typeof(DateTime));

table.Columns.Add("Value", typeof(double));

table.Columns.Add("Value2", typeof(double));

table.Rows.Add(new object[ { "11/01/2007", 5 , 0 });

table.Rows.Add(new object[ { "11/05/2007", 8 , 0});

table.Rows.Add(new object[ { "11/10/2007", 15 , 0});

table.Rows.Add(new object[ { "11/21/2007", 10 ,-5});

table.Rows.Add(new object[ { "11/22/2007", 19 ,0});

table.Rows.Add(new object[ { "11/23/2007", 13,-6});

table.Rows.Add(new object[ { "11/24/2007", 7 , -12});table.Rows.Add(new object[ { "11/25/2007", 9 ,-10});

return table;

}