Skip to main content

Explore the new, free version of Kutools for Outlook today!

 

Create multiple series histogram or bar chart quickly in Excel

Author: Xiaoyang Last Modified: 2021-01-21

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Normally, we are using column chart to compare values across a few categories in Excel. If you don't want to compare the series data and just want to group and show values in the categories individually side by side in the same chart (as the below screenshot shown), a multi Series Histogram Chart can meet your needs. Kutools for Excel supports an easy tool – Multi Series Histogram Chart to create a multi series histogram or bar chart easily in Excel.

Create multiple series histogram or bar chart quickly in Excel

Create multiple series histogram or bar chart quickly in Excel

To create a multiple series histogram or bar chart, please do with following steps:

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

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

2.1) Chart Type: Two chart types can be selected: Column chart and Bar chart;
2.2) Data range: Select the data range that you will create the chart based on; 
2.3) Axis Labels: Select the cells that contain the label text you want to show as the X-axis data in the chart;
2.4) Series name: Select the cells that contain the series names;
2.5) Click the OK button

3. Then a Kutools for Excel dialog box pops up, click Yes to go ahead.

Now a multiple series histogram chart has been created as below 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 Example button in Multi Series Histogram Chart dialog box to open the sample workbook

2. A hidden sheet is generated to store the intermediate data when creating the multi series column or bar chart. You can show the sheet to get the hidden data as follows:
(1) Right click any sheet tab in the Sheet Tab bar, and select Unhide from the context menu.
(2) In the Unhide window, click to select Kutools_Chart sheet, and click the OK button.

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase