How to make multiple colour per category in Pie Chart

[POR160893]

Hi,

I need to create a pie chart .... however, the query sets all BOTH categories the SAME colour.

How can I make them different?


Thanks

[ITWhisperer · Accepted solution]

You have a Completion Status value of an empty string - this is not the same as a null value nor just a space. Convert the empty string to a space (or some other more useful value).

| eval "Completion Status"=if('Completion Status'=""," ",'Completion Status')

[POR160893]

This worked 🙂

But, how can I standardize the 3 pie charts to have the same color scheme as the pie chart on the right:

The following is my code:

Many thanks as always and I have given you Karma again 🙂

[ITWhisperer]

Include the same charting.seriesColors option in all three charts.