The bar graph needs to have a range of data before you can make it. 1. Highlight the range of data you want to represent. You can either click and drag for several neighboring columns.