Last seen: May 22, 2025
As Catalin said earlier, those two properties belong to the slicer, so they need to be in the With theSlicer block, not related to its Shape
Did you amend the FormatSlicer code to actually use those new settings?
There has never been a definitive cause identified that I know of but to correct it you need to modify the Normal style (under cell styles on the Home...
Which version of Excel is it? That sounds like a bug that first appeared in (I think) Excel 2007 where the normal style's number format would be chang...
It appears to be down to any chart that has no data - in your original sample file, the Velocity chart had all data filtered out. A simple fix is to a...
I'd use something like this in the worksheet: Private Sub Worksheet_Activate() ' this code is replicated in multiple sheets On Error Resume Next...
Try amending the Chart_Burndown_Axis formula to: =IF(COUNTA(ReportBurndown!$X$2:$X$2)>0, OFFSET(ReportBurndown!$W$2,,,MAX(2,COUNTA(ReportBurndow...
You can write UDFs to use regex. Depending on the nature of the regex, a fair bit can be done with FILTERXML, or new functions like textsplit, textbef...
Hi Shawn, I think you misunderstood my point. In the Select Data dialog, select the PPM series in the series list, then edit the Category axis labe...
Hi Mynda, That was true for the Low and Differential series, but the PPM series was different - see pics: Low series - note axis label values. ...
The axis label range for the PPM series was set to Chart_TPM_Axis, not Chart_PPM_Axis
Generally when I've seen this nonsensical error, the solution involves doing something to force a recompile of the VBA project. For example, add a new...
If you start Excel in safe mode - hold the Ctrl key while starting Excel and answer yes to the prompt - do you still see those items? If not, it's due...
FYI, cross-posted here:
You're welcome. 🙂 I'm no master though - still mostly making it up as I go along where DAX is concerned!