How To Make A Histogram With Two Sets Of Data In Excel

Create multiple serial histogram or bar chart quickly in Excel

Normally, nosotros are using column chart to compare values across a few categories in Excel. If you don't want to compare the series information and just desire to group and show values in the categories individually side by side in the aforementioned chart (every bit the below screenshot shown), a multi Series Histogram Chart can meet your needs. Kutools for Excel supports an like shooting fish in a barrel tool – Multi Serial Histogram Chart to create a multi series histogram or bar chart hands in Excel.

Create multiple series histogram or bar chart speedily in Excel

Create multiple series histogram or bar nautical chart quickly in Excel

To create a multiple serial histogram or bar chart, please practise with post-obit steps:

one. Click Kutools > Charts > Category Comparison > Multi Series Histogram Chart.

2. In the Multi Series Histogram Chart dialog box, configure as follows.

two.one) Chart Type: Two chart types can be selected: Cavalcade chart and Bar nautical chart;

2.two) Data range: Select the information range that you will create the chart based on;

ii.3) Axis Labels: Select the cells that contain the characterization text you lot want to show as the X-axis data in the chart;

2.4) Series name: Select the cells that contain the series names;

two.5) Click the OK push

3. And then a Kutools for Excel dialog box pops upwardly, click Yes to go ahead.

At present a multiple serial histogram chart has been created equally beneath screenshot shown:

If selected Bar Chart in the Chart Type section, you will get a multi-series bar chart as the below screenshot shown.

Notes:

1. You can click the Case button in Multi Series Histogram Nautical chart dialog box to open the sample workbook

2. A hidden sheet is generated to store the intermediate data when creating the multi serial column or bar nautical chart. You can testify the sheet to get the subconscious data as follows:

(1) Right click any sail tab in the Canvas Tab bar, and select Unhide from the context menu.

(2) In the Unhide window, click to select Kutools_Chart canvass, and click the OK button.

Productivity Tools Recommended
The post-obit tools can profoundly save your time and money, which one is correct for you?
Office Tab : Using handy tabs in your Office , equally the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel : More than 300 Avant-garde Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Part 365.