Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

Create multiple series histogram or bar chart quickly in Excel

Author Xiaoyang Last modified

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.

shot-multiple-series-bar-chart-0

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.

shot-multiple-series-bar-chart-1

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

shot-multiple-series-bar-chart-2

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

shot-multiple-series-bar-chart-3

Now a multiple series histogram chart has been created as below screenshot shown:

shot-multiple-series-bar-chart-0

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

shot-multiple-series-bar-chart-4

Notes:

1. You can click the Example button in Multi Series Histogram Chart dialog box to open the sample workbook

shot-multiple-series-bar-chart-5

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.

shot-multiple-series-bar-chart-6

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon