Excel

Stacked Column with Connectors

by Leila Gharani

stacked column chart excel report How do you create this chart in Excel?

In this video you’ll learn how to add series lines to stacked column charts.

Instead of series lines, you might want to add a shaded background to each of the stacked sets.

We can do that using stacked area chart and combine it with our stacked column chart in Excel.

Watch the steps in this video:

Feel free to Download the Workbook HERE.

Published on: July 27, 2017

Last modified: May 28, 2024

Category: Dashboards, Charts & Features,Excel

Tagged as: Chart Design, Chart Formatting, Charts, Column Chart, Combo Chart, Paste Special, Series Line, Stacked Area Chart, Stacked Chart, Stacked Column, Stacked Column Chart

Leila Gharani

Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.

More About Leila Join 500,000+ professionals in our courses

Join the Course

Python in Excel For the Real World

A hands-on course for Excel users: use Python to forecast, apply machine learning, and build charts Excel can’t make. No coding background needed.

Learn More

Featured Course

Business Charts in Excel

Create professional Excel charts that tell a story AND update automatically. Learn the formulas and design techniques that get your reports noticed.

Learn More

First step to Excel

Excel Essentials for the Real World

A hands-on Excel course for professionals who never had formal training. Fill in what got skipped, so you stop doing things the long way without knowing there was a shorter one.

Learn More

This course helped me catch up and put it all together

Featured Course

Visually Effective Excel Dashboards

Learn to design impressive Excel Dashboards. Use smart functions for clear, interactive dashboards. Make them so easy to use that everyone will love them!

Learn More

Featured Course

Master Excel Power Query – Beginner to Pro

Power Query is the most underused tool in Excel. Build the monthly cleanup once, then just refresh. One member took a monthly report from 7 days down to 2 hours.

Learn More

Featured Tutorials

Excel

10 Excel Pivot Table Tips and Tricks (2026 Pro Guide)

Power Excel

You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query

Excel

How To Use Excel FILTER Function With Multiple Criteria

Power BI

What is Power BI – And What is It Used For?

Excel

Excel Settings You Should Change Now

Excel

How to Combine Multiple Sheets in Excel with VSTACK

Accounting & Finance

How to Learn Financial Analysis

Get it all

Black Belt Excel Bundle

This Excel Black Belt Package includes EIGHT of our Popular Courses. You’ll learn high-value, in-depth Excel skills that solve real problems.

Learn More

My Excel knowledge is improved a lot after the courses. My work is much faster and easier prepared and the presentations are much more appreciated.

Join Between the Sheets

Kickstart your week with our free newsletter covering Excel hacks, Power BI tips, and the latest in AI. You get to stay updated and get all the insights you need, delivered straight to your inbox.

Subscribe Now

You can unsubscribe anytime of course.