Charts Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/charts/ Bestselling Excel and Power BI Courses Tue, 25 Apr 2023 14:02:30 +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 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 Radio Buttons in Excel 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 Radio Buttons in Excel 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.

]]> 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 Professional Excel Column Charts – Overlapping Bar Trick https://www.xelplus.com/professional-excel-column-chart/ Thu, 24 Dec 2020 19:07:00 +0000 https://www.xelplus.com/?p=8984 Learn how to create a Professional Clustered Column chart in Excel. This Excel chart is not any column chart. It has overlapping bars. It's a column chart with an overlay. Using an existing chart, we will recreate it step-by-step.

The post How to Create Professional Excel Column Charts – Overlapping Bar Trick appeared first on Xelplus - Leila Gharani.

]]> Excel vs. Google Sheets – Is Excel Better? https://www.xelplus.com/excel-vs-google-sheets/ Thu, 01 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10646 These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel Histogram Chart 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 Use Excel Histogram Chart 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.

]]>