Open the Excel file that has the chart you want to convert. Click on the chart to display the Chart Tools tab, and then click the "Design" tab. Click "Change Chart Type" in the Type group to open ...

You could always convert it into a chart, but thats not dynamic, so let's convert it into a table first. Click and drag to select all the cells containing your data, including the header row.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.