Google Sheets provides you with many of the same options that you would find in Microsoft Excel, including the ability to create charts and graphs.
But if you have added a chart to your Google Sheets spreadsheet, you may have found that you don’t initially have the option of changing the chart type to something else, such as a histogram.
Fortunately you can make a histogram in Google Sheets, although the method is slightly different than you may have experienced with Excel.
How to Make Histogram in Google Sheets
- Open your Google Sheets spreadsheet.
- Select the data for the histogram.
- Click Insert, then Chart.
- Select the Chart type dropdown.
- Choose Other, then Histogram.
Our article continues below with additional information on making a histogram in Google Sheets, including pictures of these steps.
How to Create a Histogram in Google Sheets (Guide with Pictures)
The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Mozilla Firefox or Microsoft Edge.
Use these steps to make a histogram in Google Sheets.
- Go to Google Drive and open the Sheets file.
Visit https://drive.google.com to view your Google Drive files.
- Select the data to include in the histogram.
- Click the “Insert” tab at the top of the window, then choose the “Chart” option.
- Click the “Chart type” dropdown menu at the right side of the window.
- Scroll down to the “Other” section, then click the “Histogram chart” option.
How to Customize Your Histogram in Google Sheets
You can then adjust the settings in the “Chart Editor” column at the right side of the window to change the various options for displaying the histogram chart.
The Customize column in the Chart editor includes tabs for:
- Chart & axis titles
- Horizontal axis
- Vertical axis
- Gridlines and ticks
Under each of those tabs are assorted ways that you can affect the display of your chart data.
Note that you can modify the chart type at any time, to one of many other options, using these same steps above. However, in many cases, you will need to make adjustments to the setting to accommodate the new chart type.
More Information on Making a Histogram Chart in Google Sheets
- Note that one of the options available to you after creating your histogram charts is to switch the vertical axis and the horizontal axis. Sometimes Google Sheets has some trouble determining which data should be used on which axis, so you may need to change their selection in the chart editor.
- While you can manually choose which data to use in the X axis and the Y axis, there is also a button at the bottom of the chart editor column that lets you switch rows and columns.
- The Setup tab in the Chart Editor includes some of the more basic settings that you need for the chart. However, if you are looking for some more in depth customization options that you can click the Customize tab in that column and really take control when you create a histogram in Google Sheets.
- After you are finished with your histogram chart you might want to use it in another application, such as Google Docs or Microsoft Word. If you click the three dots at the top right corner of the chart you can select the Download option, then choose an image type. That downloaded picture can then be added to a document in the same way as any other image.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.