Forum Discussion
Line Chart - Multiple numeric values on the same X point
Alright. If you consider the data you provided and specifically look at these four datapoints:
(07-06 / 125)
(10-06 / 130)
(10-06 / 135)
(15-06 / 120)
There is no natural way for these the system to know the path between these datapoints as it could be either:
(07-06 / 125) -> (10-06 / 130) -> (10-06 / 135) -> (15-06 / 120)
or:
(07-06 / 125) -> (10-06 / 135) -> (10-06 / 130) -> (15-06 / 120)
The line chart logic uses the X-axis values as the pathing between datapoints and as this is the same value you are going to have this issue.
Either way, to my knowledge there is no way to have more than one datapoint on the same X-axis value on a line-chart. I might be wrong here hut i've never seen it.
I have a potential solution in mind, but it's really complicated and messy. It involves combining columns with lines in a column/line chart and essentially making the increases as very thin columns and then using two lines to draw the changes between the days.
I'm not sure if it's possible but it might π
Br,
J