Hi,

You need to calculate the 3 values before charting them.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"HillsinHolland" wrote in message
...
I am trying to create a pie chart to add up to 100%. I have 2 values which
I
have calculated as students results from tests and I would like to have a
third series which is 100-(the 2 test figures). Can this be done on a pie
chart series range or must I add another cell on the spreadsheet to
calculate
this option and then uses these 3 figures as the series for the pie chart.