12 Replies Latest reply on Oct 6, 2016 10:59 AM by Mike Heenan

    Combining box plot and line graph

    Mike Heenan

      Hi there,

       

      I currently have two separate charts: a boxplot that summarizes sales over time (years). I also have a line graph where you can pick a particular product and it will provide the average line of sales for this product over time. I would like for these two charts to be overlayed, such that the boxplot stays the same (only affected by certain filters, not product) and an average line over top that can be changed by a filter.

       

      I can't figure out how to get two different plot types to work, I can them both on the same worksheet but it makes both charts into box plots.

       

      Any help is appreciated.

       

      Thanks!