How to Make a Bar Graph in Google Sheets Brain-Friendly. First, open a fresh Google Sheet. Create a table of data with one column of categories and one column of measures or metrics. If you’d like, you can make a copy of this a sample data set in Google Sheets by right-clicking on the link to open in a new tab and making a copy. Use a bar chart when you want to compare individual items. For example, compare ticket sales by location, or show a breakdown of employees by job title. Learn how to add & edit a chart. Bar chart example. The bar charts below show 2 different views of Google Analytics web traffic data. The base dimension for both charts is Medium. The left hand chart uses stacked bars to show several metrics (Sessions, Users, and Exits) for medium. The right hand chart uses a second dimension, Country ISO Code, to breakdown each medium according to its country of origin. Instead of stacked bars, this chart use grouped bars: each bar is a data series corresponding to one of the countries.