Scatter Chart Archives - Xelplus - Leila Gharani

How to Make a Gantt Chart in Excel

Leila Gharani — Thu, 11 Apr 2024 17:08:01 +0000

There is no built-in Gantt chart in Excel, but in this tutorial, you will find an easy workarounds using a scatter plot with a creative error bars technique.

The post How to Make a Gantt Chart in Excel appeared first on Xelplus - Leila Gharani.

How to Create a Progress Circle Chart in Excel

Leila Gharani — Thu, 05 Sep 2019 09:00:00 +0000

Interested to create a progress circle chart infographic in Excel like never seen before? This progress chart has rounded edges. I show you two solutions - you'll love the second one!

The post How to Create a Progress Circle Chart 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.

Excel Dynamic Map with Drop-Down

Leila Gharani — Sun, 28 Jan 2018 21:41:00 +0000

In case you're interested to visualize a KPI on a customized map in Excel which works on any version of Excel, then this tutorial is for you. I show you in easy steps how to find the right map and how to set it up properly.

The post Excel Dynamic Map with Drop-Down appeared first on Xelplus - Leila Gharani.

Gantt Chart with Progress Bars in Excel

Leila Gharani — Wed, 02 Aug 2017 07:17:00 +0000

Excel doesn't have a built-in Gantt chart, but don't worry! In this tutorial, I'll show you a clever workaround using a stacked bar chart. You'll learn how to create a fully functional Gantt chart complete with progress bars that display the percentage completion of tasks. Plus, I'll teach you how to toggle between actual and planned scenarios easily. Get ready to enhance your project management skills with these Excel tricks!

The post Gantt Chart with Progress Bars in Excel appeared first on Xelplus - Leila Gharani.