On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
JMH said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.