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. 🧵

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.

🧭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.