Excel charts with Dynamic Arrays at Excel Virtually Global Conference 2022

Thanks for watching!
-------------------------------
This is a brief introduction on Excel charts with Dynamic Arrays. There's a huge potential with making interactive dynamic charts with this new calculation engine of Excel: spilled ranges. The new functions lower a lot the complexity to implement these types of charts.

Links mentioned on video:
1. My website: Spilled Graphics

2. Bill Jelen's book on Dynamic Arrays:

3. Mark Proctor's book on Dynamic Arrays:

4. Leila Gharani's course on Dynamic Arrays:

5. Link for downloading file shown on video:

-------------------------------

[judyl.]

1:50 develop models, do graphics, data visualization, reporting, dashboard -- analyst.
3:15 keeping the option to the user, creates the user experience.
6:20 the data comes from here
6:45 Ctrl + * :select all tables and Ctrl + T: pop the table creator
8:30 put table name: with a character _
9:40 Tab to autocomplete, then ctrl + Enter
12:20 SUMIF function: beautiful! beautiful!
14:55 Insert > Chart. Microsoft has a feature that you don't need to name all formulas.
15:25 Ctrl + F3: Name Manager box pop up
16:12 # sign, but what is the meaning?
17:20 intention: 2-D chart and right click Select data.
17:30 Series name and edit series with F3.
18:30 all the states being plotted.
19:30 close the brackets and then parentheses. with hashtag All in it.
20:15 we can link the spill array to a pivot table because in case the data grows or shrinks.
20:40 Now we delete it and do F3.
21:15 undock with right click.
22:00 right click the Remove Grand Total.
22:10 Right click and add a slicer
22:20 Pivot table slicer.
23:15 inside the UNIQUE, we go and put FILTER
24:30 with one click, you can just switch a chart or filter it.
24:35 Ctrl + 1: Axis Options and Categories in reverse order.
25:30 may be legible and move forward
25:50 How to sort by ascending or city types
26:00 Backbone array
26:50 LET function
28:20 We already have 2 variables and corresponding formulas.
28:35 SORTBY function
31:50 Ctrl + Z:
33:00 build this array 排列 with this function: headers and rows.
39:30 F3 + Slicer:
40:30 pt_sort_order
41:10 functionally we are done.
44:50 again, it is cosmetics at this point.

[Miss_Resources]

I want to get a sticker with your graphics!

[lirageneve]

Why not create a pvtable directly from the table? What’s the point in creating that spilled range if you would have to refresh the pvtable anyway?