excel charts Archives - Xelplus - Leila Gharani

Excel Dashboard to Track Budget and Actuals with Variances

Leila Gharani — Fri, 08 Dec 2023 14:25:28 +0000

Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

The post Excel Dashboard to Track Budget and Actuals with Variances appeared first on Xelplus - Leila Gharani.

Excel Charts: Matrix or Excel Panel Charts

Leila Gharani — Tue, 13 Sep 2016 08:10:00 +0000

When you have too much to tell, don’t tell it all in one overcrowded chart. Instead create a panel chart: ONE chart that looks like mini charts placed beside each other. It's often called small multiples and significantly improves readability. Learn how to set it up in Excel.

The post Excel Charts: Matrix or Excel Panel Charts appeared first on Xelplus - Leila Gharani.

Excel Charts: Dynamic Line Series Labels

Leila Gharani — Mon, 18 Jul 2016 10:34:00 +0000

Default legends often put a lot of effort on the chart reader. Consider how you can improve the readability of your charts so that your readers don't struggle to interpret them. One solution can be replacing the default legend with dynamic series labels.

The post Excel Charts: Dynamic Line Series Labels appeared first on Xelplus - Leila Gharani.

Use This Instead of the Pie Chart

Leila Gharani — Wed, 24 Feb 2016 15:10:00 +0000

A parts-to-whole chart doesn't necessarily have to be a pie chart which has gotten a rather bad rep in recent years. In this tutorial, you will learn an alternative - a bar chart sorted dynamically by rank, created with the help of RANK, and INDEX and MATCH functions.

The post Use This Instead of the Pie Chart appeared first on Xelplus - Leila Gharani.