![stack columns of data in excel for mac stack columns of data in excel for mac](https://cdn.extendoffice.com/images/stories/doc-excel/stack-columns-left-to-right/doc-stack-columns-left-to-right-5.png)
In the Format Legend pane, select the position you need from the Legend Options tab, see screenshot: Right click the legend, and choose Format Legend, see screenshot:ĥ. Then, the stacked clustered column chart has been created successfully, now, you can move the bottom legend to right or other position as you need. In the Format Data Series pane, under the Series Options section, change the Gap Width to 0, see screenshot:Ĥ. Right click the data series bar, and then choose Format Data Series, see screenshot:ģ. After arranging the data, select the data range that you want to create a chart based on, and then click Insert > Insert Column or Bar Chart > Stacked Column, see screenshot:Ģ. You will get the new layout of data as below screenshot shown:ġ. To create a stacked clustered column chart, first, you should arrange the data with blank rows, and put the data for different columns on separate rows.įor example, put the Q1 and Q2 data in separate rows, and then insert blank row after each group of data row and header row, please remember to delete the first cell header.
![stack columns of data in excel for mac stack columns of data in excel for mac](https://www.lifewire.com/thmb/E0NQ0tnFcWl7h3S_xJZFpNakXHw=/1064x527/filters:no_upscale():max_bytes(150000):strip_icc()/Excel_03-674a233d08ec4ea0bcf80e3bec90d68b.jpg)
![stack columns of data in excel for mac stack columns of data in excel for mac](https://www.smartsheet.com/sites/default/files/styles/900px/public/ic-excel-stacked-bar-charts-part-to-hole.png)
#Stack columns of data in excel for mac how to#
This article, I will talk about how to create a stacked clustered column chart in Excel as below screenshot shown.Ĭreate a stacked clustered column chart in Excel How to create a stacked clustered column / bar chart in Excel?