Sorting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sorting/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:37:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Sorting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sorting/ 32 32 How to Create Excel Interactive Charts with Dynamic Arrays https://www.xelplus.com/excel-da-dynamic-sorted-chart/ Thu, 19 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11421 Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

The post How to Create Excel Interactive Charts with Dynamic Arrays appeared first on Xelplus - Leila Gharani.

]]> Excel Sort (by Value, Color, Icon, Own List) & How to Unsort https://www.xelplus.com/excel-sort-by-value-color-icon-own-list-how-to-unsort/ Mon, 22 Oct 2018 16:02:00 +0000 https://www.xelplus.com/?p=9626 Quickly learn how to use Excel's Sort feature to sort your data by value, color, icon and even your own custom list. Use this trick to Unsort your data.

The post Excel Sort (by Value, Color, Icon, Own List) & How to Unsort 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.

]]>