12 Replies Latest reply on Oct 28, 2016 7:45 AM by isa.serah Branched from an earlier discussion.

    Show Total Sales and Average Daily Sales by Month/Year on same chart

    isa.serah

      How to display sales 2015 ,sales 2016 ,Average sales 2015 and average sales 2016 in the same graph.?I could do dual axis for sales 2015 and sales 2016 .How can I achieve the other two?It would be helpful if someone can show that in a workbook.

       

      Ho can I create a chart like the picture below.I need to calculate the daily average sales of 2015 and daily average sales of 2016 and it should be represented as lines shown in the picture and Sales2015 and sales 2016 as 2 bars .But all in same view.Can you please help me in that.

       

       

      dual bar line.PNG

       

      Message was edited by: Simon Runc