Excel Stacked Column chart

The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.

For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then this is the chart for you.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select the table on where we want to create the chart on.  

Excel Stacked Column chart

 

STEP 2: Go to Insert > Column > 100% Stacked Column 

Excel Stacked Column chart

 

Your chart is now ready:

Excel Stacked Column chart

 

Excel Stacked Column chart

Helpful Resource:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. DOWNL...
Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts: #1 - COPYING A CHART Click on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want. When you are done, let go of the ...
Sparklines: Column Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points. You can style them in different colors and add a marker for the High and Low points of your data.  As your da...