Pie charts

H

HillsinHolland

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pie chart areas reflect magnitude 5
Pie chart-remove series w/out changing percent in pie 1
Pie Chart and Table Query 2
How can I customise colours used in charts and keep those colours. 2
Excel 2003 dynamic named range for the values in a pie chart 1
Pie Chart 4
excel charts 0
Excel 2010 Data Labels options not saving 0

Top