Oct 02 2023 03:58 AM
Hi,
I need a digram with 3 curves,
- Uper values
- Optimum values
- Lover values
How should I do this?
Best regards
- Geir
Oct 02 2023 04:02 AM
Create a source range with x-values in the first column, lower values (where available) in the second column, optimal values in the third column, and upper values (where available) in the fourth column.
Create an XY Scatter chart from the source range.
Oct 02 2023 04:29 AM
Thank you @Hans Vogelaar They are "always" available. It should excactly like the example.
Al I get is a stright line.
Best regards
- Geir
Oct 02 2023 04:58 AM
The data in your workbook look completely different from the data behind the chart in the picture!
Nedre grense and Øvre are completely blank, and Optimal = x verdier, so you get a straight line indeed.