3. If your clustered column chart didn’t come out quite the way you wanted it to, try switching the rows and columns.This can make the chart easier to read. I want the horizontal axis to show months, then show clustered bars for 2013, 2014 and 2015 that show column 1 (sessions). The combination chart uses a column chart type for the vertical bars and vertical axis of frequencies, and it uses an XY scatter chart type for the horizontal axis. There's also a PDF file available on that web page that explains the way I originally constructed the histogram manually using a pre-2007 version of Windows Excel. I would like a lines to show column 2 (inqs) Here's the pivot table: Here's a sample of the chart I'd like to get. Result: Note: only if you have numeric labels, empty cell A1 before you create the column chart. On the Insert tab, in the Charts group, click the Column symbol. 2. Click Clustered Column. Here’s how to get a stacked and clustered column bar chart done in excel (tested on Excel 2011 for Mac): Create your first stacked bar chart. (You can have as many clusters as … It’s hard to understand when it’s written out, so let’s take a look at an example. A stacked bar chart shows both the total of a different categories and the proportion of each constituent value. Specify major and minor axis ticks, so they are consistent between the charts you are going to merge later. I have a dataset I would like to visualize in Excel 2016 Mac.