You can set this up in Excel to have all the data in one table, then break out the calculations line by line. Let’s derive the compound annual growth rate of ... years and add them to the ...

You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel. By doing this ...