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.
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.
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 steps above were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers as well.
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.
- 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