11 Replies Latest reply on Mar 14, 2016 10:12 AM by Harnish Patel

    Multiple marks and editing stacked columns

    Harnish Patel

      Hi all,

       

      I've attached a sample workbook to illustrate my problem. I am trying to stack 2015 and 2016 into a column but i do not want it to be additive. I would the colors to separate the years but the axis to only represent the max of two years.  So if Jan 2016 is '10 units' and Jan 2015 is '15 units' I would want one color to go up until 10 and the other to go until 15, not the full thing to go until 25.

       

      Also, I would like the 2014 trend line to run on the same axis as a comparison point.

       

      Thank you for your help in advance!