Chart Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/chart-formatting/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:38:23 +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 Learn Excel Macros in 10 Minutes 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 Learn Excel Macros in 10 Minutes appeared first on Xelplus - Leila Gharani.

]]> How to Create Conditional Bar 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 How to Create Conditional Bar Charts in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Create a Progress Circle Chart using Doughnut Chart as the Basis 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 using Doughnut Chart as the Basis 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.

]]> Excel Dynamic Map with Drop-Down https://www.xelplus.com/dynamic-map-chart-with-drop-down/ Sun, 28 Jan 2018 21:41:00 +0000 https://www.xelplus.com/?p=11145 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.

]]> Excel Clustered Column AND Stacked Combination Chart https://www.xelplus.com/excel-clustered-column-and-stacked-chart/ Thu, 21 Dec 2017 06:49:00 +0000 https://www.xelplus.com/?p=11213 Learn how to combine clustered column and stacked column in the same chart in Excel. There are many workarounds to achieve that, but we find that our method is the most comprehensive.

The post Excel Clustered Column AND Stacked Combination Chart appeared first on Xelplus - Leila Gharani.

]]>