Forum Discussion
Dynamic Formatting Area chart
Not the full solution, but half a solution:
Conditional formatting is available for bar charts, but I can't see it for line or area charts.
You can start with a column chart and set the conditional formatting under Visual > Columns > Color as follows, using a field with the color hex in your table (click on the FX button and select field value and then the hex color from your table).This will give you a bar graph with conditional coloring as follows:
If you then change the graph to Line, it retains the colors as the markers, but not for the line.
There doesn't appear to be a marker setting, but it does seem to work.
Not the full solution, but half a solution:
Conditional formatting is available for bar charts, but I can't see it for line or area charts.
You can start with a column chart and set the conditional formatting under Visual > Columns > Color as follows, using a field with the color hex in your table (click on the FX button and select field value and then the hex color from your table).
This will give you a bar graph with conditional coloring as follows:
If you then change the graph to Line, it retains the colors as the markers, but not for the line.
There doesn't appear to be a marker setting, but it does seem to work.