Method 1: Use the built-in histogram chart type Since Excel 2016, there is a built-in chart type called “histogram”. It easily inserts a histogram. Just follow these steps: • Select your data.
![Creating a histogram in excel Creating a histogram in excel](https://support.content.office.net/en-us/media/f4b3be7f-515f-44a4-a159-f6742ea80051.png)
• Click on the histogram icon in the center of the “Insert” ribbon. Select the histogram chart. • That’s it, you already got a histogram. • Now you can start fine-tuning your histogram. To achieve this, double click on the x-Axis. • On the right-hand side, you’ll see the “Format Axis” pane. Under “Axis Options”, you can set the main preferences.
• Most important is probably the “Bin width”. By default, it’s “Automatic”. You could switch it to “Bin width” and set the desired class width, e.g. • Alternatively, you can let Excel define the bins automatically or define the number of bins.
Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data,.
• Also important: Do you want to set an individual “underflow” bin or and “overflow” bin. Excel then summarizes all items below the underflow bin into one column on your chart. • Number 6 on the screenshots shows the result, if you set the bin width to “1.0”, the overflow bin to “6.0” and the underflow bin to “2.0”.
Now you can proceed defining the layout, e.g. Colors, fonts and titles. Method 2: Use a PivotTable and group the data The second method also works with Excel versions before 2016. You insert a PivotChart and use the function to group the data. Follow these steps (the numbers relate to the pictures). • Select your data.
Feeling the same thing as very hard to get on Windows. Mac video converter online.
• Click on “PivotChart” in the “Charts” section of the “Insert” ribbon. • Make sure the settings are correct (the correct table range and the location is selected).
Confirm with OK. • You now see a blank PivotTable range and an empty PivotChart. Also, the “PivotChart Fields” pane on the right-hand side opens. If you can’t see the “PivotChart Fields” pane on the right-hand side, right-click into the empty PivotTable and click on “Show Field List”. Drag and drop the numeric values into the “Rows” section. Then drag and drop the item names (here: “Country”) into the “Values” section.
Make sure, that it says “Count of Country” instead of “Sum of Country”. If it doesn’t say “Count of” (e.g. “Sum of”), right-click into your PivotTable in the column of “Sum of Country”, click on “Summarize Values By” and check “Count”. • Now right-click on any cell of the the “Row Labels” column.
• Click on “Group”. • Define your classes: • “Starting at” is the minimum value, ending at the maximum value. • “By” defines the class width. To change the values later on, repeat from step 5 above. • After clicking on OK, you see a chart similar to number 8. You can proceed with the layout of your chart. Advantages Disadvantages • More flexible than the histogram chart type in method 1.
• It’s comparatively easy to insert a histogram chart (compared to the manual method 3 below). • Works with Excel versions before Excel 2016. • When you insert a PivotChart, a PivotTable is automatically created as well. • PivotChart fields are always shown. Method 3: Prepare your data manually The concept of the third method is to prepare your data in a way that you only have to insert a simple column chart. Therefore, you have to prepare a table with the class limits and insert the class into your existing data. Please look at the image on the right-hand side.