Your histogram chart now contains two data series side-by-side.To use it, select “Add Series,” highlight the series you wish to add, and click “OK.” Series – Add Series: This feature is also used to add additional columns or rows in the histogram.For example, you can change this value to “A1:A16,B1:B16” to include rows 1 through 16 in both columns A & B. Data Range: This feature is helpful if you want to include multiple columns and multiple rows in your histogram.
Other features help orientate the data based on how to interpret the columns and rows. Some of the options on this tab are helpful in expanding the scope of your histogram. You’re already familiar with this tab because we used it to set the chart type. We’ll take a high-level look at what each of the chart editor features does. Google Sheets offers a wide range of customization and formatting options you can use to better showcase information. How to customize the histogram in Google Sheets
Congratulations! You’ve created a histogram.Select the Histogram graph option type from the list under the “Other” section (see yellow rectangle).On the chart “Setup” tab, select the drop menu under “chart type,” unless Google Sheets has automatically selected “Histogram.”.
Next, open the “Insert” drop menu and select “Chart” from the options list (see blue arrows).In the example case, we’ve highlighted the “Age” header and 15 values (see yellow rectangle). Highlight the data you want to use to populate the histogram including the heading text.The following steps explain how to create a histogram in Google Sheets: In the following example, we’ll use the ages of 15 hypothetical people who responded to a survey. You May Also Like the Following Tutorials:īefore you can make a histogram in Google Sheets, you need some data to work with.How to customize the histogram in Google Sheets.How to make a histogram in Google Sheets.