Skip to main content
15-Moonstone
November 25, 2019
Question

Format line from time series chart

  • November 25, 2019
  • 1 reply
  • 1671 views

Hello.

 

I have a time series chart with a 30-day history of a property, and a target value. I want the line to be coloured differently when it is above/below the target. The State Formatting option only colours the marker from the data point, but not the line.

 

Does anyone know how to colour the line? My purpose is to have it like this:

Red line when below the target

Green line when above the target

 

Thank you

1 reply

5-Regular Member
November 26, 2019

I don't think a line-chart could do this, but a bar chart will.

Radu15-MoonstoneAuthor
15-Moonstone
December 4, 2019

Sadly, the format needs to be an XY chart, because the data points need to be connected to eachother.

5-Regular Member
December 6, 2019

XY chart has the stateFormating field that you can use to change color based on value, but it doesn't quite work in my side. If this doesn't work for you either, then we don't have other options.