Show average line in bar and line charts

abhipillai

Dear friends,

Is there any way to show an average line in bar and line charts?

Regards
Abhilash.

pricher

Abhilash,

I'm guessing that you want to create a chart that shows SUM and AVERAGE on two separate Y-axes. To do this:

1. In the Chart Wizard, on Select Chart Type, choose Bar as the Chart Type, then Secondary Axis in Multiple Y Axis, and Line Series in Series Type.
2. In Select Data, drag and drop your Category field from the Data Set into Category (X) Series. Then, drag and drop a number field in Value (Y) Series Y Axis 1. Then, drag and drop the same field in Y Axis 2. Click on the Sigma drop down and choose Average for the Aggregate Expression.

Please look at the attached design for more information.

Hope this helps!

P.