did you ever get a response? see the attached
it returns this
is a bit of a hack - i changed the chart type to square and added the color code
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim, that worked perfectly for me.
Glad to help out