Post

Skillwave Training
@skillwave.training

In last week’s ‘Ask Ken Anything’ (AKA) session, one of our students 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. 😠 @excelguru.ca reproduced the issue live.🧵

Skillwave Training
@skillwave.training

Unfortunately , 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. 😢 Ken offered practical workarounds: You can ayer separate combo and line charts (one with a transparent background) together, OR

Skillwave Training
@skillwave.training

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.

0 reposts2 likes

Skillwave Training
@skillwave.training

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. Our #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies include access, 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…