4 Replies Latest reply on May 11, 2016 12:16 PM by rabeeh.elhussein

    Merging 2 charts with different time-based x axis ?! (workbook attached)

    rabeeh.elhussein

      Dear all,

       

      I need to mix 2 charts in one graph .. one is a monthly basis analysis of discount by month ( the x axis is months) .. please check worksheet attached.

      The second graph is the sales split as well by months .. but also by year .. ...

       

      I want to merge sheet 1 and 2 in one graph .. to achieve the result you can see in the image I attached (Done using Excel)

       

      However i am not able to do so with the dual axis option . as the x axis has to be the same !

       

      Really appreciate any hint you can give ..