How to add a Average monthly sales line on to my existing monthly sales bar chart ?

[paulyeo11]

Hi All

I have a Bar Chart in QS.

I like to add one more line to this bar chart , which show the average yearly sales. avg(sales)

Paul

[paulyeo11]

my QVF

[sunny_talwar]

May be using a combo chart

[paulyeo11]

Hi sunny

what i need is to have the average line on the chart .

For example if i select year = 2016 , total amount of sales 1,586 , Average = 1,541/6 = 256.

May i know how to do it ?

Paul