Stacked Chart Archives - Xelplus - Leila Gharani

How to Present Survey Results in Excel with a Chart

Leila Gharani — Sat, 20 Apr 2019 19:24:00 +0000

What's an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you'll find an impressive way to chart survey results in Excel. It's not as difficult as you think.

The post How to Present Survey Results in Excel with a Chart appeared first on Xelplus - Leila Gharani.

Excel Clustered Column AND Stacked Combination Chart

Leila Gharani — Thu, 21 Dec 2017 06:49:00 +0000

Learn how to combine clustered column and stacked column in the same chart in Excel. There are many workarounds to achieve that, but we find that our method is the most comprehensive.

The post Excel Clustered Column AND Stacked Combination Chart appeared first on Xelplus - Leila Gharani.

Excel Quick Gantt Chart

Leila Gharani — Wed, 02 Aug 2017 07:17:00 +0000

There is no built-in Gannt chart in Excel, but in this tutorial, you will find two workarounds, one using a scatter plot, and another with stacked bar chart. Error bars come to the rescue in both versions. You'll get a quick version, and a fully featured one, where you can switch between actual and plan scenarios.

The post Excel Quick Gantt Chart appeared first on Xelplus - Leila Gharani.

Stacked Column with Connectors

Leila Gharani — Thu, 27 Jul 2017 11:17:00 +0000

Learn how to add series lines or shaded background to a stacked column chart by combining it with a stacked area chart. It's a good way of displaying the trend for each category (stack).

The post Stacked Column with Connectors appeared first on Xelplus - Leila Gharani.

Excel Charts: Special Excel Graphs (InfoCharts)

Leila Gharani — Thu, 25 May 2017 08:08:00 +0000

If you want your charts to grab attention, it's worth spending some time on customizing the shapes and conditionally formatting them in a dynamic manner, so that the highlighted value changes with the data. In this tutorial, we will walk through an example of customizing a chart in Excel.

The post Excel Charts: Special Excel Graphs (InfoCharts) appeared first on Xelplus - Leila Gharani.

3 Ways to Improve Readability of Excel Stacked Charts

Leila Gharani — Thu, 04 May 2017 10:00:00 +0000

Find out how to format the standard stacked chart to improve readability and comparison between the different categories and stacks. My tips include adding total values outside the last stack, adding percentages to the stacks, and creating a dynamic legend, putting the labels of each of the stacks on the right-hand side of the last category.

The post 3 Ways to Improve Readability of Excel Stacked Charts appeared first on Xelplus - Leila Gharani.