Table conditional format:
You can realize that Asia is Green and not Red as in the table. Please, I�d like to have the same colors in the table and the graph. See the XML from Skiteam attached.
Sorry for the delayed response.
From what I can tell you have 2 different conditions.
The table says :
"anything below 60 = RED , anything above 60 = GREEN".
So it's either Yes or No. 2 different colors.
But you're then displaying this on the 'Invoiced Amount Column'
Since the chart has the 'AVG Days at camp' as the color field, you cannot use this condition.
The 'range' option you were using, is not a conditional format and works differently, as it's a metric range.
What you want to do is;
1. Create a basic conditional format for the AVG days at camp field
2. On your chart, choose the conditional format as the color.
You will then have this:
I have exported a copy of this report and attached.
Please let me know if this does not give you what you were after.