Read: How to create a Line Chart and Scatter Plot Graph in Excel.. How to calculate CPI in Excel? To calculate CPI in Excel, you need to use a formula like this: =[(Cumulative price of basket of ...

This part of the Graph Makeover Contest was much more challenging than the redesign of the donut chart, but readers suggested a variety of ways to visualize the data in the table. Figure 1 shows ...