In Calc, how can I add three data series with very different vertical ranges to the same Line-chart or XY-chart?
In one example, I have voltage from 0…200, current from 0…10 and power from 0…2000.
In another example, I have radiant power from 0…1e-3, counts from 0…65536 and ratio from 0…65.
One workaround I can think of is using two axes (which I know how to do) and rescale one of the three series using an extra column (for example, dividing power by 10). The downside is that the units displayed in the chart are deceptive. Another alternative is using multiple charts, which I think is even worse, since the graph lines can’t be visually compared, which is the whole point of charts.