I have a SharePoint list with two fields that I am using for a chart:
InspectionId
InspectionStatus
I am using 'Single Series', 'Pie 2D' chart.
1. I group by 'InspectionStatus'.
2. For each group, display following series: one or more fields(s)
3. Choose from the following series: COUNT of InspectionId
Is there a way to specify COLOR for each Pie chart piece:
Failure - color red
Pass - color green
Warning - color yellow
I know, I can use 'Multi Series' - 'Multi Series Column 2D' chart to control color of each series, but I would like to do the same with a Pie chart.
I that possible?