How to Make a Histogram in Google Sheets | Scribe

    How to Make a Histogram in Google Sheets

    • Alai Umerez |
    • 11 steps |
    • 28 seconds
      1
      Look for the Google Apps icons at the top right corner of your browser
      2
      To access the Google Sheets application, simply click on the "Sheets" option
      3
      Open Google Sheets and create a new spreadsheet or open an existing one
      4
      Organize your data in two columns: - **Column A**: Contains the raw data values (e.g., test scores, ages, or sales figures). - **Column B (optional)**: If you prefer to manually define bins (ranges like 0–10, 11–20), list them in this column
      5
      Click and drag to select the range of cells that contain your data. For example: - If using raw data only, select Column A - If using both data and predefined bins, select both Column A and Column B
      6
      With the data selected, navigate to the top menu bar and click on "Insert"
      7
      From the dropdown menu, select "Chart" This will insert a default chart (usually a column chart) and open the Chart Editor panel on the right
      8
      In the Chart Editor, click on the "Setup" tab and look for the "Chart type" dropdown menu
      9
      Scroll down and select "Histogram chart" If the histogram option doesn’t appear, make sure your data is properly formatted and numeric
      10
      Still in the Chart Editor, you can switch to the "Customize" tab to modify visual elements like: - **Chart title**: Add or edit the title for clarity - **Colors**: Change the bar colors to match your preferences - **Axes labels**: Add labels for the x-axis and y-axis
      11
      Click anywhere outside the chart to close the Chart Editor
      information ordinal icon
      Tip! If you want more control over the histogram bins, you can create a frequency table manually using the `FREQUENCY` function and use that data to create a bar chart instead