Last seen: Jun 12, 2026
Did you change the listbox's ColumnCount property to 7?
It looks like you just need to pivot on the RunDate column using Amount as the Value field.
You could try checking the Fast Data Load option to see if that helps?
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...