4 Replies Latest reply on Aug 4, 2016 10:08 AM by John Sobczak

    Double Bar Chart

    Chris Kimberley

      Hi all,

       

      I have two worksheet bar charts that I would like to merge into one.  One worksheet bar chart shows tickets created monthly, and the other shows tickets closed monthly.

       

      Here is the created bar chart:

       

      created.PNG

       

      Here is the closed bar chart:

       

      closed.PNG

       

      Please note that they use the same filter for Project, but ONLY the closed bar chart has the AVG function.

       

      Also, they both use different date fields.  It's possible that a ticket created, is also closed in the same month so is added to both bar charts.

       

      Any ideas how to merge these together so that we see open vs closed bar charts side by side?

       

      Thanks,

      Chris