Stacked Column Chart Archives - 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.