data visualization Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-visualization/ Bestselling Excel and Power BI Courses Mon, 08 Jul 2024 14:41:00 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png data visualization Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-visualization/ 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.

]]> PowerPoint Design Tips for Memorable Presentations https://www.xelplus.com/powerpoint-slide-design-tips/ Thu, 08 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10631 How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don't notice when we watch presentations we love. I've broken it down into 5 tips which you can apply to your PowerPoint slides.

The post PowerPoint Design Tips for Memorable Presentations 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.

]]> How to Create an Excel Infographic https://www.xelplus.com/creative-infographics-excel-male-female/ Thu, 05 Jul 2018 08:56:00 +0000 https://www.xelplus.com/?p=10250 Download the infographics Excel template for a quick start. I'll show you how to create this with male, female icons. Update it easily for your needs.

The post How to Create an Excel Infographic appeared first on Xelplus - Leila Gharani.

]]> Infographics in Excel: NOT your Usual Bar Chart https://www.xelplus.com/infographics-in-excel-bar-chart-icons-symbols/ Fri, 27 Apr 2018 08:39:00 +0000 https://www.xelplus.com/?p=10303 If you'd like to modernize your Excel reports, check out this tutorial which shows you some simple chart tricks to create a bar chart that doesn't quite look like a bar graph. It uses icons and shapes in a dynamic way.

The post Infographics in Excel: NOT your Usual Bar Chart appeared first on Xelplus - Leila Gharani.

]]> Excel VBA: Control WordArt Fill with Macros https://www.xelplus.com/excel-vba-wordart-fill-with-macros/ Thu, 15 Feb 2018 17:37:00 +0000 https://www.xelplus.com/?p=11079 Find out how you can use Excel Macros to control the fill color of Word Art showing a percentage value connected to a cell with a formula. Pick up plenty of VBA techniques while you're at it.

The post Excel VBA: Control WordArt Fill with Macros appeared first on Xelplus - Leila Gharani.

]]> Dynamic WordArt in Excel with Bar in Bar Chart https://www.xelplus.com/dynamic-wordart-in-excel-with-bar-in-bar-chart/ Fri, 09 Feb 2018 07:38:00 +0000 https://www.xelplus.com/?p=11110 Learn how to have dynamic Word Art that is controlled with a formula and how to create bar-in-bar Excel charts. You don't need VBA, you just have to get creative.

The post Dynamic WordArt in Excel with Bar in Bar Chart appeared first on Xelplus - Leila Gharani.

]]> Corporate Report Makeover: Alternative for Excel Doughnut Charts https://www.xelplus.com/excel-report-makeover-alternative-for-doughnut-charts/ Thu, 19 Oct 2017 14:18:00 +0000 https://www.xelplus.com/?p=11866 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) https://www.xelplus.com/bmw-report-makeover-graph-versus-table/ Thu, 19 Oct 2017 13:47:00 +0000 https://www.xelplus.com/?p=11882 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.

]]> Gantt Chart with Progress Bars in Excel https://www.xelplus.com/gantt-chart-with-progress/ Wed, 02 Aug 2017 07:17:00 +0000 https://www.xelplus.com/?p=12058 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.

]]>