5 Replies Latest reply on Jan 10, 2019 6:10 AM by Marco Peters

    Comparing 2019 values with last year MEDIAN

    Marco Peters

      After unsuccessfully wrapping my head around this all day, I will need your help.

      I am trying to add the MEDIAN per category from 2018 (tab 'BoxPlot Values 2018') to the values from 2019 in this tab (Comparison_Values_2019_with_MEDIAN_2018) for comparison. The 2018 MEDIAN should have a different color/shape to highlight this value (comb attached).

       

      Any ideas how this can be achieved without adding helper values to the source Excel file?