How To Use Google Sheets To Make A Bar Graph

How to create a bar graph in google sheets we ll start with a simple two column spreadsheet.

How to use google sheets to make a bar graph. Below are the steps to create the bar graph in google sheets. This will insert a suggested chart in the worksheet. You can use the chart editor tool if you want to change your chart type. Double click the chart you want to change. Click insert chart to create your chart and open the chart editor tool.

In the first column of your spreadsheet add a label for each row in your series. By default a basic line chart is created using your data with the chart editor tool opening on the right to allow you to customize it further. 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. A gantt chart is a commonly used type of bar chart that illustrates the breakdown of a project s schedule into tasks or events displayed against time. Now for the written tutorial you can create a bar graph in google sheets in 3 simple steps.

Click the chart icon in the google sheets toolbar. If you like you can add a category in the top cell and that category will appear as the title of your graph s horizontal y axis. To start open your google sheets spreadsheet and select the data you want to use to create your chart. Highlight the cells containing the data you d like to visualize. Google sheets has a handy feature to help you create a gantt chart for your project.

Change chart type using the chart editor tool. At the right click customize. Create a table of data with one column of categories and one column of measures or metrics. Select the dataset including the headers in the toolbar click on the insert chart icon. How to make a bar graph in google sheets brain friendly first open a fresh google sheet.

Change how the chart looks. Fire up google sheets and open a new spreadsheet.