7 Replies Latest reply: Mar 29, 2017 4:17 AM by Ibrahim ElShafei RSS

    Displaying data for last 13 month

    Ibrahim ElShafei

      Hi,

       

      I searched many times in the forum but I could not find the answer. Please advise if I'm using the wrong keywords.

       

      I have two charts:

      • Guage chart: To present the SLA (Met vs. Breached) for last month only
      • Pivot chart: To present the SLA (Met vs. Breach) per month for the last 13 month

       

      Sample data of the pivot table:

      MonthSLA MetSLA Breached
      Jan-1696%4%
      Feb-1695%5%
      Mar-1695%5%
      Apr-1694%6%

       

      How can I achieve this on one sheet?

       

      Thank you,

       

      Ibrahim