Percentage

[Ruben09]

Hi all,

This is probably a simple question, but can't seem to do it correctly. I'm
trying to create a Pie Chart showing the percentage of hours that have been
completed in a project.

Eg) Total project hours is 3,000 and so far 150 has been completed. I want
the Pie Chart to reflect the 3,000 hours and the slice being the 150. How do
I go about doing this? Thanks in advance.
-Ruben

 

[Luke M]

In a2:
Amount completed
in a3:
Amount done

In B1:
3000
In B2:
150
in B3:
=B1-B2

Now, create a pie chart using A2:B3. As you increase the amount of hours
completed, the total value of the pie will remain 3000.

 

[Ruben09]

Hi Luke,

is a2=b2?
is a3=b1?

In a2:
Amount completed
in a3:
Amount done

In B1:
3000
In B2:
150
in B3:
=B1-B2

Now, create a pie chart using A2:B3. As you increase the amount of hours
completed, the total value of the pie will remain 3000.

Hi all,

[quoted text clipped - 6 lines]

I go about doing this? Thanks in advance.
-Ruben

 

[Gklass]

Hi Luke,

is a2=b2?
is a3=b1?

In a2:
Amount completed
in a3:
Amount done

In B1:
3000
In B2:
150
in B3:
=B1-B2

Now, create a pie chart using A2:B3. As you increase the amount of hours
completed, the total value of the pie will remain 3000.

[quoted text clipped - 6 lines]

I go about doing this?  Thanks in advance.
-Ruben

what he meant was:
A | B
3 Amount completed | 3000
4 Amount done | 150

jsut highlight the four cells and insert the chart