I have a numeric series with the same value for the Y-axis. When I show the chart as a line it works, but when I show the chart as a bar chart, it has no Y-axis values and no bars.
I can avoid the problem by explicitly setting the Y-axis range.
.Axis.Y.RangeType = AxisRangeType.Custom
.Axis.Y.RangeMax = Math.Ceiling(maxValue * 1.2)
.Axis.Y.RangeMin = Math.Floor(minValue * 0.8)
Is this behavior a defect, or intentional?
What is the formula used by the default AxisRangeType?
The default behavior for automatic axis range is to take the lowest and the highest values from your datasource. So, if low and high are equal, the columns won't show. You can also set chart.Data.ZeroAligned = true to force the axis to start from 0, but your workaround is the best way to force the columns to display in a friendly manner.