2 Replies Latest reply on May 16, 2018 12:40 PM by Lakshay Akula

    How to add a CAGR to the right of a stacked bar chart (in a way that dynamically changes)?

    Lakshay Akula

      I have a stacked bar chart of sales over time where I can use some filters to change the data being displayed. I want to be able to display the CAGR on the right like this:

       

       

      The main criteria is that the CAGR needs to dynamically move so it's to the right of the series it's relevant to, even if those series move up and down depending on the filter. If it's impossible to make it look like this, what's the next best alternative?

       

      I've attached an example workbook using the superstore data. Thanks!