Negative Values Archives - 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.

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