Last seen: May 22, 2025
That definitely looks like a bug to me. If you right click the chart, Select Data, and edit the category labels to make them point somewhere else, the...
There are additional Unicode characters in your 'numbers'. Sometimes there is a char 8237 at the start and there appears to always be a char 8236 at t...
One way would be: 1. Unpivot the data using the 4 'WK...' columns. (this will add new Attribute and Value columns) 2. Remove the existing Total ...
In an Alphanumeric comparison, the comparison works left to right, character by character. So W2 is greater than W18 because it compares the 2 to the ...
There's no attached worksheet but it sounds like more than a formatting issue. Your category values have actually gone missing and you've ended up wit...
That I totally agree with! 🙂
Reddick is in large part based on the popular misunderstanding of the intent of Simonyi's ("Hungarian") notation, which is unfortunate and best avoide...
You could just group the items? Or create an additional column in the source data that returns the same name for both items you want grouped.
I'd imagine this can be simplified, but it's been a long day! let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" ...
It looks like you are using FSA Status for the count and also as a column header. As per the message you are getting, you cannot use any field in the ...
In what sense are ThisWorkbook and Worksheet code modules not class modules? They may inherit from another class that we don't have access to but that...
If your code runs through error handling, then it terminates normally, so we're back to the original situation. My point was that the only real danger...
What I mean is that it will only cause a problem if you terminate your code early (eg an error occurs and you press End rather than debug). In cases l...
It is not actually necessary to reset Screenupdating to True, unless you specifically need to force a screen redraw at some point within your code. Th...
Personally, I'd suggest a module with functions (or property procedures) that return the relevant values. For object variables, you'd use a Static var...