Thanks so much for your help.
To be clear, I can change the text color using conditional formatting in the A column, but I can't get it to reflect on the chart.
Basically: A2:A52
Colors:
Massachusetts - Red
Conn - Blue
VT - Green
NH (black, so leaving it since I believe there can only...
I am working to create an XY Graph that shows XY value, but also has different data types called out by region(i.e. Values for each State). I have created conditional formatting to create custom data labels.
My challenge is there is a drop down menu where the state the value comes from is...