Want to display value and difference on one chart

[JMH]

I am trying to create a chart that displays x and 10-x on the same chart. I
want the chart to show a meaured value and the difference of that value to 10
in a different color.

 

[Del Cotter]

I am trying to create a chart that displays x and 10-x on the same chart. I
want the chart to show a meaured value and the difference of that value to 10
in a different color.

Use your spreadsheet to calculate the values, then use the chart to
graph them. Never try to use a chart for calculation.