Graph help please?

Question

I need to make two pie graphs on excel. I know how to- but it's not working out. One graph title has to be Sank In Regular Water and it has to be 100% and the other graph title is Floated In Salt Water and it has to be 100%. How do I do this? Thanks in advance! :)

Answer 1

Well...
In box A1 type 1
In box A2 type 1
Go to Insert, Chart
Pick the Pie chart option
Pick the subchart you want and click next (at the bottom)
Go to the Series tab
Click the box to the right of the values window
Click on the A1 box
Click the box to the right of the values window again
Click next
Go to the Data Labels tab
Click the percentage box
Go to the Legend tab
Unclick the show legend box
Go to the Titles tab
Type in either Sank In Regular Water or Floated In Salt Water
Click Finish
To change the color:
Right click the chart and choose Format Data series