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.