Chart Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/chart-formatting/ Bestselling Excel and Power BI Courses Tue, 06 May 2025 09:55:19 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Chart Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/chart-formatting/ 32 32 How to Make a Gantt Chart in Excel https://www.xelplus.com/gantt-chart-excel/ Thu, 11 Apr 2024 17:08:01 +0000 https://www.xelplus.com/?p=22322 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 Make a Graph in Excel https://www.xelplus.com/how-to-make-a-graph-in-excel/ Tue, 02 Jan 2024 08:40:32 +0000 https://www.xelplus.com/?p=11255 In this tutorial, you will familiarize yourself with the chart environment in Excel. You will learn how to insert and format a chart, where to find various chart elements and options, how to customize axes, series, labels and legends. You will be creating your own charts in no time.

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

]]> How to Use Excel Macros to Save Time and Automate Boring Tasks https://www.xelplus.com/learn-excel-macros/ Fri, 02 Apr 2021 04:48:00 +0000 https://www.xelplus.com/?p=10171 If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. You will see that VBA doesn't have to be scary and that you can easily generate VBA code by recording your actions.

The post How to Use Excel Macros to Save Time and Automate Boring Tasks appeared first on Xelplus - Leila Gharani.

]]> Conditional Formatting for Charts in Excel https://www.xelplus.com/excel-conditional-bar-charts/ Thu, 23 Jul 2020 09:00:00 +0000 https://www.xelplus.com/?p=10848 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.

]]> How to Create a Progress Circle Chart in Excel https://www.xelplus.com/excel-progress-circle-chart/ Thu, 05 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12227 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 https://www.xelplus.com/excel-gantt-chart-actual-plan/ Thu, 25 Jul 2019 09:00:00 +0000 https://www.xelplus.com/?p=12275 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.

]]> How to Best Present Charts in PowerPoint https://www.xelplus.com/powerpoint-excel-chart-animation/ Wed, 19 Jun 2019 09:00:00 +0000 https://www.xelplus.com/?p=12309 Choosing the right Chart animation in PowerPoint is the secret to a professional presentation. In this quick tutorial find out how to link your Excel chart to PowerPoint and how to animate the graph to support your story.

The post How to Best Present Charts in PowerPoint appeared first on Xelplus - Leila Gharani.

]]> How to Present Survey Results in Excel with a Chart https://www.xelplus.com/charting-survey-results-excel/ Sat, 20 Apr 2019 19:24:00 +0000 https://www.xelplus.com/?p=12518 What's an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you'll find an impressive way to chart survey results in Excel. It's not as difficult as you think.

The post How to Present Survey Results in Excel with a Chart appeared first on Xelplus - Leila Gharani.

]]> Highlight Max & Min Values in an Excel Line Chart https://www.xelplus.com/highlight-max-min-values-in-an-excel-line-chart/ Thu, 21 Mar 2019 17:01:00 +0000 https://www.xelplus.com/?p=12775 Can you conditionally format an Excel line chart to highlight the maximum and minimum values? Can you do it in a dynamic way? You can. You just need to use this simple trick.

The post Highlight Max & Min Values in an Excel Line Chart appeared first on Xelplus - Leila Gharani.

]]> How to Create a Sales Funnel Chart in Excel (Not the “usual” Funnel) https://www.xelplus.com/funnel-chart/ Sat, 17 Nov 2018 02:02:00 +0000 https://www.xelplus.com/?p=9876 Quickly learn how to create a funnel chart in Excel that actually looks like a funnel. The trick is so simple but well hidden. It involves transforming SmartArt to a chart.

The post How to Create a Sales Funnel Chart in Excel (Not the “usual” Funnel) appeared first on Xelplus - Leila Gharani.

]]>