Using the Stacked Column Chart Helper

    Video Tutorials

    Option 1 - Creating charts and adding growth rates with the 'one click' approach

    Option 2 - Creating charts 'step by step' and adding growth rates

    Formatting charts

    Formatting Data Labels

    Adding shapes with highlighted values

    Ribbon

    Ribbon Menu of the Stacked Column Chart Helper
    Ribbon Menu
    • Create the chart: calls a menu
    • Add growth rates: calls a menu
    • Format data labels: calls a menu
    • CAGR formula: Runs a procedure on the selected cells and inserts a formula for Compound Annual Growth Rate
      1. Pop up menu: Select range with starting values
      2. Pop up menu: Select range with ending values
      3. Pop menu: Number of years