{"id":1967,"date":"2014-11-24T12:53:00","date_gmt":"2014-11-24T12:53:00","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=1967"},"modified":"2026-01-06T08:55:00","modified_gmt":"2026-01-06T08:55:00","slug":"how-to-split-a-stacked-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-split-a-stacked-chart-in-excel\/","title":{"rendered":"How To Split A Stacked Chart In Excel"},"content":{"rendered":"

How to create AND split a stacked chart in Excel<\/p>\n

Amongst the many charts available in Excel, some of the most popular are column charts, and the main variants being clustered and stacked. The sort of thing we teach in advanced Excel courses London<\/a>. We’ll look at how to split a stacked chart in Excel, and to do this let’s start by creating a basic column chart.<\/p>\n

Creating a column chart<\/h2>\n

In this example we are looking at regional sales data.<\/p>\n

\"Sample<\/a><\/p>\n

Let’s create a clustered column chart of the above data.<\/p>\n

Step 1<\/strong>\u00a0Select the range of data (as above, which will be A1:B4).<\/p>\n

Step 2<\/strong>\u00a0Now select chart type, and “Clustered Column” from Charts options on the Insert ribbon.<\/p>\n

\"a<\/a><\/p>\n

Step 3<\/strong>\u00a0The following chart is now created.<\/p>\n

\"regional<\/a><\/p>\n

This is all well and good we can compare regional\u00a0sales performance, but it’s not so easy to compare how well each region performed against total sales. That’s where stacked column charts come into their own, let’s see how to build one.<\/p>\n

Creating a stacked column chart<\/h2>\n

Step 1\u00a0<\/strong>Simply select the above chart then\u00a0choose “Change Chart Type” from the Design ribbon.<\/p>\n

\"change<\/a><\/p>\n

Step 2<\/strong>\u00a0In the “Change Chart Type” dialogue box just choose the “Stacked Column” option as below.<\/p>\n

\"changing<\/a><\/p>\n

We now have a single stacked column chart for regional sales.<\/p>\n

<\/a>
\n\"Excel<\/a><\/p>\n

How to split a stacked chart in Excel<\/h2>\n

Now supposing we want to compare North & South as a stacked column against West and East as a stacked column. This can be achieved by splitting the above stacked chart.<\/p>\n

Step 1<\/strong> We need to change the layout of our data. So in this case we are going to select the two cells containing the “West” and “East” sales figures, then move them one column to the right. See below.<\/p>\n

\"preparing<\/a><\/p>\n

Step 2<\/strong> Now select the new range of data, in this case A1:C4, and as before when creating our original column chart but this time selecting the “stacked column” option. We end up with the following.<\/p>\n

\"how<\/a><\/p>\n

We now have our regional sales in a split stacked column chart.<\/p>\n

By learning\u00a0how to split a stacked chart in Excel you can now visualise data in a new and useful way.<\/p>\n

More Excel chart related information:<\/h3>\n

How do you add a piechart and a bar \/ column chart on one worksheet?<\/span>
\nRead more<\/a><\/span><\/p>\n

How do I create a Floating Column Chart in Excel?<\/span>
\nRead more<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

How to create AND split a stacked chart in Excel Amongst the many charts available in Excel, some of the most popular are column charts, and the main variants being clustered and stacked. The sort of thing we teach in advanced Excel courses London. We’ll look at how to split a stacked chart in Excel, […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[96,187,213,260,509],"class_list":["post-1967","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-clustered-column-charts","tag-excel-charts","tag-excel-stacked-column-charts","tag-formatting-a-chart-style","tag-split-a-stacked-chart-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1967"}],"version-history":[{"count":5,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1967\/revisions"}],"predecessor-version":[{"id":7839,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1967\/revisions\/7839"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}