How can I match the Y and Y2 ranges so that the column chart has the same scale as the line chart (or visa versa, depending on the higer value)?
I have set two different data sources, one holding current values for the column chart and one holding average values over time for the line chart.
This is the current chart. It is a bit deceiving because of the scale differential.
you can either create a composite chart and assign the line chartlayer and column chartlayer to the same y-axis, or you can continue using the ColumnLineChart and set:
Axis.Y.RangeType = Axis.Y2.RangeType = AxisRangeType.Custom;
Axis.Y.RangeMin = Axis.Y2.RangeMin = 0;
Axis.Y.RangeMax = Axis.Y2.RangeMax = 100;
Excellent suggestion. I ended up sticking with the ColumnLineChart and matching the axis values AFTER cycling through the dataset to find the highest and lowest values, then setting the MIN and MAX accordingly.