I'm trying to make a scatterchart with values on the y-axis, and dates on the x-axis. De date range can be a few days, but also a few hundred.
Using autoArrange=true, the pointmarks are plotted, but the x-axis is a mess (especially with a big date range). (x-axis.isDate="True")
Using autoArrange=false and setting other x-axis as follows:
this.RadScatterChart1.DefaultView.ChartArea.AxisX.MinValue = startDate.ToOADate();
this.RadScatterChart1.DefaultView.ChartArea.AxisX.MaxValue = endDate.ToOADate();
this.RadScatterChart1.DefaultView.ChartArea.AxisX.Step = ((endDate.ToOADate() - startDate.ToOADate())/20);
this.RadScatterChart1.DefaultView.ChartArea.AxisX.LabelStep = 5;
this.RadScatterChart1.DefaultView.ChartArea.AxisX.LabelStep = Convert.ToInt32(Math.Round((this.RadScatterChart1.DefaultView.ChartArea.AxisX.Step * 2), 0));
this.RadScatterChart1.DefaultView.ChartArea.AxisX.StepLabelLevelCount = 2;
I've tried loads of variations of above, with no effect
Now the x-axis is ok, but no pointmarks are plotted at all....
Help needed, too much time wasted already.
Erwin
Using autoArrange=true, the pointmarks are plotted, but the x-axis is a mess (especially with a big date range). (x-axis.isDate="True")
Using autoArrange=false and setting other x-axis as follows:
this.RadScatterChart1.DefaultView.ChartArea.AxisX.MinValue = startDate.ToOADate();
this.RadScatterChart1.DefaultView.ChartArea.AxisX.MaxValue = endDate.ToOADate();
this.RadScatterChart1.DefaultView.ChartArea.AxisX.Step = ((endDate.ToOADate() - startDate.ToOADate())/20);
this.RadScatterChart1.DefaultView.ChartArea.AxisX.LabelStep = 5;
this.RadScatterChart1.DefaultView.ChartArea.AxisX.LabelStep = Convert.ToInt32(Math.Round((this.RadScatterChart1.DefaultView.ChartArea.AxisX.Step * 2), 0));
this.RadScatterChart1.DefaultView.ChartArea.AxisX.StepLabelLevelCount = 2;
I've tried loads of variations of above, with no effect
Now the x-axis is ok, but no pointmarks are plotted at all....
Help needed, too much time wasted already.
Erwin