Difference Chart Archives - Xelplus - Leila Gharani

Conditional Formatting for 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 Conditional Formatting for Charts in Excel appeared first on Xelplus - Leila Gharani.

BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1)

Leila Gharani — Thu, 19 Oct 2017 13:47:00 +0000

In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on some of the tables and graphs used in the report. When comparing sales volume difference year over year, a cleverly formatted bar chart will be much more effective in telling the story than a simple table.

The post BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1) 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.