Charts Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/charts/ Bestselling Excel and Power BI Courses Tue, 15 Oct 2024 07:42:46 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Charts Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/charts/ 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.

]]> Create Beautiful Charts in PowerPoint with Think-Cell https://www.xelplus.com/think-cell-in-powerpoint/ Sun, 04 Sep 2022 15:31:00 +0000 https://www.xelplus.com/?p=9035 With the think-cell add-in for PowerPoint, you can create beautiful charts with just a few clicks. Some of my favorites are Gantt charts, Mekko charts and adding automatics totals to stacked columns or bars.

The post Create Beautiful Charts in PowerPoint with Think-Cell appeared first on Xelplus - Leila Gharani.

]]> How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel Radio Buttons to Create Interactive Dashboards https://www.xelplus.com/excel-dashboards-with-radio-buttons/ Thu, 17 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9999 Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Excel Radio Buttons to Create Interactive Dashboards appeared first on Xelplus - Leila Gharani.

]]> Introduction to Office Scripts https://www.xelplus.com/office-scripts-macros-on-the-web/ Fri, 28 May 2021 11:09:00 +0000 https://www.xelplus.com/?p=10010 This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

The post Introduction to Office Scripts appeared first on Xelplus - Leila Gharani.

]]> Excel Advanced Pivot Table Techniques for Serious Data Analysts https://www.xelplus.com/excel-advanced-pivot-tables/ Thu, 08 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10162 These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

The post Excel Advanced Pivot Table Techniques for Serious Data Analysts 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.

]]> Progress Chart: Excel Clustered Column Chart with Overlapping Bars https://www.xelplus.com/professional-excel-column-chart/ Thu, 24 Dec 2020 19:07:00 +0000 https://www.xelplus.com/?p=8984 Create impactful progress charts in Excel using a clustered column chart with overlapping bars. Free download chart template included!

The post Progress Chart: Excel Clustered Column Chart with Overlapping Bars appeared first on Xelplus - Leila Gharani.

]]> How to Make a Histogram in Excel https://www.xelplus.com/excel-histogram-chart/ Thu, 03 Sep 2020 09:00:00 +0000 https://www.xelplus.com/?p=10774 Histogram charts are easy to make in Excel. It might not be straightforward though how to adjust the bin numbers. It's really easy once you know. Check out this quick tutorial.

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

]]>