Create multiple series histogram or bar chart quickly in Excel
Kutools for Excel
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.
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.
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.
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 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.