Column Chart Archives - Xelplus - Leila Gharani

How to Use Radio Buttons in Excel to Create Interactive Dashboards

Leila Gharani — Thu, 17 Jun 2021 08:00:00 +0000

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.

Top 10 Tips to Make the Most of Google Sheets

Leila Gharani — Sun, 28 Feb 2021 22:02:00 +0000

This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

The post Top 10 Tips to Make the Most of Google Sheets appeared first on Xelplus - Leila Gharani.

How to Create Professional Excel Column Charts – Overlapping Bar Trick

Leila Gharani — Thu, 24 Dec 2020 19:07:00 +0000

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 Clustered Column AND Stacked Combination Chart

Leila Gharani — Thu, 21 Dec 2017 06:49:00 +0000

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.

Excel Dynamic Chart with Drop-Down

Leila Gharani — Mon, 11 Dec 2017 07:36:00 +0000

With these simple steps you can easily create an interactive chart in Excel which will for sure impress your team. Once you learn the basics for dynamic chart ranges, you can create any dynamic graph you need in Excel.

The post Excel Dynamic Chart with Drop-Down appeared first on Xelplus - Leila Gharani.

Stacked Column with Connectors

Leila Gharani — Thu, 27 Jul 2017 11:17:00 +0000

Learn how to add series lines or shaded background to a stacked column chart by combining it with a stacked area chart. It's a good way of displaying the trend for each category (stack).

The post Stacked Column with Connectors appeared first on Xelplus - Leila Gharani.

Excel Charts: Special Excel Graphs (InfoCharts)

Leila Gharani — Thu, 25 May 2017 08:08:00 +0000

If you want your charts to grab attention, it's worth spending some time on customizing the shapes and conditionally formatting them in a dynamic manner, so that the highlighted value changes with the data. In this tutorial, we will walk through an example of customizing a chart in Excel.

The post Excel Charts: Special Excel Graphs (InfoCharts) appeared first on Xelplus - Leila Gharani.

3 Ways to Improve Readability of Excel Stacked Charts

Leila Gharani — Thu, 04 May 2017 10:00:00 +0000

Find out how to format the standard stacked chart to improve readability and comparison between the different categories and stacks. My tips include adding total values outside the last stack, adding percentages to the stacks, and creating a dynamic legend, putting the labels of each of the stacks on the right-hand side of the last category.

The post 3 Ways to Improve Readability of Excel Stacked Charts appeared first on Xelplus - Leila Gharani.

Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows

Leila Gharani — Fri, 14 Apr 2017 06:58:00 +0000

Dynamic column and bar charts are great for showing variances. In this tutorial, you will find 4 methods of visualizing variances in Excel: with conditional formatting - by inverting fill color for negative values, with the help of error bars, and by adding conditionally formatted arrows on top of or under the chart.

The post Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows appeared first on Xelplus - Leila Gharani.