Post

In the most recent AKA session, a student asked about a frustrating #DataVisualization problem: a carefully formatted combo #PivotChart looked perfect until new forecast data was added. One refresh later, the formatting was gone. 😠 I reproduced the issue and was upfront that there's no clean fix. 🧵

Ken Puls, FCPA, MS MVP

@excelguru.ca

PivotCharts built on the #DataModel are notoriously fragile when a refresh adds new series, because the chart loses track of what it's supposed to format. I offered practical workarounds: 🟢 Layer separate combo and line charts, OR 🟢 Try driving the chart from #DynamicArrays so it works off formulas.

28/9/26, 5:03 pm0 reposts0 likes

Ken Puls, FCPA, MS MVP

@excelguru.ca

🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting. That's what the AKA is for: real problems from your own files, worked through live with someone who will tell you honestly what works and what doesn't.

Ken Puls, FCPA, MS MVP

@excelguru.ca

My #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies at @skillwave.training include access to our semi-monthly AKA sessions, or join just the AKAs at skw-t.com/aka

skw-t.comExcel Fundamentals AcademyIn the Excel Fundamentals Academy, you’ll learn all the core skills for the Excel analyst, beginning with a refresher on Excel formulas and functions (including the daunting VLOOKUP), and then moving…