Or you can try driving the chart from #DynamicArrays so it works off worksheet formulas instead of a #PivotTable.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.

Using #SVGs to give a hand shaded/sketched feel to bar charts in PowerPoint by generating flexible fill code in #Excel using #DynamicArrays and RANDBETWEEN(). Pretty pleased with this. Learnt a lot getting to this point.

Excel GROUPBY and PIVOTBY functions: What you need to know to use them effectively, pros and cons versus Pivot Tables, and how I managed to crash Excel with PIVOTBY!
youtu.be/eykj3O4XCiQ

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #pivottables #dynamicarrays

If you need to distribute an Excel-based Gantt chart within your project team, here's one more useful than most of the basic templates available.

youtu.be/5dGEiWbaHYM

#microsoft #ms365 #msoffice #office #excel #gantt #project #projectplan #dynamicarrays

The New Excel Toolkit: From LET to MAKEARRAY
#excel #microsoftexcel #excel #microsoftexcel #excel365 #excelfunctions #advancedexcel #exceltutorial #exceltips #exceltricks #dynamicarrays #lambdaexcel #letfunction #mapfunction #scanfunction #reducefunction #byrow #bycol
www.youtube.com/live/2HpwpkY...

In an upcoming video, an in-depth look at GROUPBY and PIVOTBY, I managed to get one of these functions to repeatedly crash Excel. Something to watch out for!

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #dynamicarrays

The intersect operator is a hidden gem in Excel. In this video I break down how to replace complex nested XLOOKUPs with a more elegant solution using just a single space character.
youtu.be/kEr9aJ3age8

#excel #exceltips #exceltutorial #financialmodelling #xlookup #dynamicarrays #intersect

How to Use the RANDARRAY Function in Excel

#Excel #MicrosoftExcel #ExcelTips #ExcelFunctions #ExcelLearning #ExcelTutorial #Spreadsheet #DataAnalysis #RANDARRAY #ExcelFormulas #DynamicArrays #ExcelFunctions #RandomNumbers #ExcelTricks

We're super excited to have Microsoft MVP and charting legend, Jon Peltier, back to present at our June 4 meet-up! 🥳 He's going to describe some of the challenges with using #DynamicArrays for Dynamic #ExcelCharts, and how to work around them. 📊
Sign up at the link below.

#Excel #DataVisualization

Dynamic Arrays in Excel — Intro
One formula → multiple results. No more dragging.

If this is new to you, you're right on time.
▶️ Watch now: www.youtube.com/watch?v=R38R...
#Excel #DynamicArrays #HowToLearnExcel

If you missed charting legend Jon Peltier's presentation at last week's Vancouver #PowerBI and Modern #Excel meet-up, the recording is now available: youtu.be/FiYEtyLtQCs
We had a great time diving into how to use Lambda #DynamicArrays to create Statistical Process Control charts.
#DataVisualization

Reshape Tables with TOCOL & WRAPROWS in Excel

Transform messy tables effortlessly! Learn to reshape tables using Dynamic Array Formulas like TOCOL, WRAPROWS, and VSTACK. Ideal for Excel 365/2021 users.

🎥 Watch now: www.youtube.com/watch?v=5GHb...

#ExcelTips #DynamicArrays #HowToLearnExcel