i have been struggling, googling and searching my problem to no avail.
i am using reporting v5.3.11.1116 for exporting a chart. The axis are dates. I have played around with autoscale and setting step and label step, min value, and max value.
However, it seem to get the same result: The line is constructed and scaled properly, but the x-axis labels are always spaced evenly apart even when the time between points is varied. Please see my attachment.
You will notice that one major tick is 2 months, but the next is 12 days. It conitnues like that.
Here are some of my current settings that wil not work.
chart1.PlotArea.XAxis.MinValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedStartDate.AddDays(-1).ToOADate();
chart1.PlotArea.XAxis.MaxValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedEndDate.AddDays(1).ToOADate();
chart1.PlotArea.XAxis.Step = (chart1.PlotArea.XAxis.MaxValue - chart1.PlotArea.XAxis.MinValue)/10;
this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.Top;
this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 45F;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.Color = System.Drawing.Color.Gainsboro;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.EndCap = System.Drawing.Drawing2D.LineCap.Flat;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;
this.chart1.PlotArea.XAxis.Appearance.MajorTick.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Reporting.Charting.Styles.ChartValueFormat.ShortDate;
this.chart1.PlotArea.XAxis.AutoScale = false;
this.chart1.PlotArea.XAxis.AxisLabel.Appearance.Visible = true;
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Observation Date";
this.chart1.PlotArea.XAxis.AxisLabel.Visible = true;
this.chart1.PlotArea.XAxis.DataLabelsColumn = "ObservationDateOADate";
this.chart1.PlotArea.XAxis.IsZeroBased = false;
how do i get the x axis labels to display evenly spaced out values. It is okay if the labels do not match up with the points. For example, a data point on 1/15/12 could be by the actual label of 1/12/12. we are printing out a separate report for the raw values in a different report.
i am using reporting v5.3.11.1116 for exporting a chart. The axis are dates. I have played around with autoscale and setting step and label step, min value, and max value.
However, it seem to get the same result: The line is constructed and scaled properly, but the x-axis labels are always spaced evenly apart even when the time between points is varied. Please see my attachment.
You will notice that one major tick is 2 months, but the next is 12 days. It conitnues like that.
Here are some of my current settings that wil not work.
chart1.PlotArea.XAxis.MinValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedStartDate.AddDays(-1).ToOADate();
chart1.PlotArea.XAxis.MaxValue = dataSeriesDisplayChartViewModel.DataSeriesDisplay.SelectedEndDate.AddDays(1).ToOADate();
chart1.PlotArea.XAxis.Step = (chart1.PlotArea.XAxis.MaxValue - chart1.PlotArea.XAxis.MinValue)/10;
this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.Top;
this.chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 45F;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.Color = System.Drawing.Color.Gainsboro;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.EndCap = System.Drawing.Drawing2D.LineCap.Flat;
this.chart1.PlotArea.XAxis.Appearance.MajorGridLines.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;
this.chart1.PlotArea.XAxis.Appearance.MajorTick.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Reporting.Charting.Styles.ChartValueFormat.ShortDate;
this.chart1.PlotArea.XAxis.AutoScale = false;
this.chart1.PlotArea.XAxis.AxisLabel.Appearance.Visible = true;
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.Black;
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.chart1.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Observation Date";
this.chart1.PlotArea.XAxis.AxisLabel.Visible = true;
this.chart1.PlotArea.XAxis.DataLabelsColumn = "ObservationDateOADate";
this.chart1.PlotArea.XAxis.IsZeroBased = false;
how do i get the x axis labels to display evenly spaced out values. It is okay if the labels do not match up with the points. For example, a data point on 1/15/12 could be by the actual label of 1/12/12. we are printing out a separate report for the raw values in a different report.