I've tried playing with Append and AppendCols and I can get what I want, but now have hit a new issue.
If I use an append command at the end of my search this genrates a 'C' row and adds a 0 to 'ColC':-
SEARCH COMMAND WITH CHARTING | append [|stats count AS "ColC" | eval Metric="C"]
This is exactly what I want, as when I plot the graph it has now properly spaces the columns 🙂
However, if there already is a row 'C' in my results, it generates a duplicate row 'C' and corrupts the graph completely 😞
Conversely, if I use "appendcols" instead, it doesn't generate the duplicate row, but doesn't create one if it's missing in the first place.
I'm now into some sort of conditional check to try and switch between append and appendcols depending on whether the results already have a 'ColC' value and am stuck. My search is also about 100x more complex than it needs to be, and I get the feeling I'm missing a simple option somewhere!