If you wish to create a dynamic graph, you would have to use tables for the data. To calculate CPI in Excel, you need to use a formula like this: =[(Cumulative price of basket of commodities in ...