Average Line for Clustered Column Chart

[cbrydon]

Hi,

I'd like to be able to draw an "Average Line" for each argument group in a clustered column chart similar to what is in the attached image.
Using Constant Lines almost does the trick except the constant lines are drawn across the entire chart. I don't have a sample chart to send
you yet as I'm not sure how to go about this. If you can point me in the right direction, I don't mind sending a report and sample data along
if I have any issues.

Thanks,
Carl

[Edward]

Hi Carl,

Please try using the stepped line type of the Series as an Average Line.

SteppedLine.PNG (116.71 KiB) Viewed 1441 times

AvgAsSteppedLine.mrt

(17.27 KiB) Downloaded 355 times

Thank you,
Edward