Bar Chart 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.

How to Create a Project Plan in Excel with Gantt Charts

Leila Gharani — Thu, 25 Jul 2019 09:00:00 +0000

With this complete Excel Gantt chart, you can professionally present your project timeline. It includes task completion, planned timeline versus actual view in one single chart.

The post How to Create a Project Plan in Excel with Gantt Charts appeared first on Xelplus - Leila Gharani.

First Excel Hash Challenge between 6 MVPs

Leila Gharani — Tue, 04 Sep 2018 08:33:00 +0000

This Chick's Trouble is my recipe for Excel Hash. It includes the FREQUENCY & MAX functions, 3D Models & Form Controls. You'll be surprised what comes out...

The post First Excel Hash Challenge between 6 MVPs appeared first on Xelplus - Leila Gharani.

Corporate Report Makeover: Alternative for Excel Doughnut Charts

Leila Gharani — Thu, 19 Oct 2017 14:18:00 +0000

Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

The post Corporate Report Makeover: Alternative for Excel Doughnut Charts 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.

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.