Variance 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.

How to Create Conditional Bar Charts in Excel

Leila Gharani — Thu, 23 Jul 2020 09:00:00 +0000

Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.

The post How to Create Conditional Bar Charts in Excel appeared first on Xelplus - Leila Gharani.

Smart Uses of Custom Formatting in Excel – Part 2

Leila Gharani — Wed, 30 Aug 2017 14:36:00 +0000

Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. In part 2, learn how to add any symbol to custom number format, how to use up/down arrows for percentage variances, and how custom formatting works with thresholds and icons.

The post Smart Uses of Custom Formatting in Excel – Part 2 appeared first on Xelplus - Leila Gharani.

Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows

Leila Gharani — Fri, 14 Apr 2017 06:58:00 +0000

Dynamic column and bar charts are great for showing variances. In this tutorial, you will find 4 methods of visualizing variances in Excel: with conditional formatting - by inverting fill color for negative values, with the help of error bars, and by adding conditionally formatted arrows on top of or under the chart.

The post Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows appeared first on Xelplus - Leila Gharani.

Excel Companion Charts

Leila Gharani — Fri, 27 Jan 2017 11:32:00 +0000

With this tutorial, you will improve your chart design. I share a few different methods used for visualizing performance comparisons, deviations, as well as future estimated performance.

The post Excel Companion Charts appeared first on Xelplus - Leila Gharani.