How to Create CAGR Graph in Excel (2 Easy Ways)

Method 1 – Utilizing Combo Chart

The sample dataset below contains the following known values.

Utilizing Combo Chart to Create CAGR Graph in Excel


  • Enter the following formula in cell D11 to get the CAGR value.


  • Enter the following formula to get the slope value.


Finding Slope to Create CAGR Graph in Excel

  • Insert another formula to find the CAGR graph values. We will plot these values in the secondary axis in a line chart to create the CAGR graph. Fill the formula down.


  • Select the cell range B4:D10.
  • From the Insert tab ➤ Insert Combo Chart ➤ select Clustered Column – Line.

Insert Tab to Create CAGR Graph in Excel

  • A default combo chart will pop up.

Basic Chart in Create CAGR Graph in Excel

  • Select the chart and from the Chart Design tab, click on “Select Data”.
  • A dialog box will appear.
  • Deselect “Year” and edit the horizontal axis labels.

  • Set the Axis Labels to the cell range B5:B10 and press OK.

  • The CAGR graph will be inserted.

Read More: Excel Formula to Calculate Average Annual Compound Growth Rate

Method 2 – Inserting Column Chart to Plot CAGR Graph in Excel


  • Select the dataset range.
  • From the Insert tab ➤ Insert Column or Bar Chart ➤ select Clustered Bar.

Inserting Column Chart to Plot CAGR Graph in Excel

  • A basic chart will appear.

  • You can change the chart properties to make it look better.

Read More: How to Calculate Future Value When CAGR Is Known in Excel

Download Practice Workbook

Related Articles

<< Go Back to Compound Interest in ExcelExcel for Finance | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF