How to make a bar graph in Excel. First, open the Excel application and retrieve the spreadsheet you're pulling the data from. The bar graph needs to have a range of data before you can make it.

To convert the values to a percentage, select all of them, and hit the Percentage symbol. Create a graph for CPI values in Excel The best graph type for CPI values is the bar graph.