Excel Dynamic Charts - Easily Create Dynamic Charts using FILTER & SORT functions

If you need to create a chart in Excel based on changing criteria, it is easy to do with a dynamic chart using the FILTER function. You can even add the SORT function to get your chart sorted from highest to lowest or lowest to highest. We also show the UNIQUE function to create a data validation list that automatically updates.

Chapters:
0:00 Intro
0:32 Create a Table (CTRL+T)
1:39 Data to chart
2:10 FILTER function
4:15 Format numbers
4:30 Create chart
5:30 SORT function ascending
6:58 SORT function descending
7:45 Data Validation list by typing
9:20 UNIQUE function
9:45 SORT and UNIQUE function
10:08 Data validation list from dynamic range

Version for Dynamic array functions:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones

#exceltraining #msexcel #chrismenardtraining #chrismenard

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[kyuopjm]

You are a fantastic teacher! Thank you very much. Very useful and informative. Thank you
Chris!

[Robert_]

Good stuff Chris. The Dynamic Array formulas changed my life! No more Ctrl+Shift+Enter!

[ClaudioCP]

Great overview about some key dynamic array functions. Very cool and useful examples. Thanks Chris!

[rudisteenhuis]

Hi Chris. TX for your great vids.
An improvement you could make to the validation list is to place the following into the source box of the list validation: =$K$2#
The above will always extract the whole list coming from the SORT(UNIQUE(...)) formula. If you place a hard-coded range in there, as you did when highlighting with your mouse, the list gets truncated if it grows longer.
Keep up the great vids.
Cheers 👍

[ittghgw]

Thank you for this training material. Can you show how to add "All" option in filter?

[hollyfrench]

Hi Chris, these dynamic functions are new to me but I just have to ask a logical question...isn't this creating the same thing as a pivot table and a pivot chart would do or is there something I'm missing in the use of these dynamic functions? Love your videos! You keep me learning!

[jojothegigolo]

Can you make a trend from this function ?

[daninega]

Chris please can you help me to unlock password protected word document or any suggestions??? Thanks

[frankclaeys]

Hi Chris, why doesn't my chart change but my filter data does. I can see the data (made with filter function) but the graph deosn't?

[markpodesta]

Thank you Chris. So no more named ranges needed to create dynamic charts?

[DarylHawkins-zhww]

How do you the same thing but ignoring and not creating a column for no values?

[daninega]

Hello Chris, is there a new method to open password protected word to open

[NashvilleFanatic]

Help! This isn't working for me - the chart's range is staying static based on the dynamic formula spill range when I create the chart. Any idea what I'm doing wrong? Thank you!!!

[mchllwoods]

U don't need to highlight the whole dynamic list in data validation. Just highlight the first cell then put # after it. It will highlight the whole list on it's own. Also, u don't need a 1 in sort function. It's in ascending order by default.