Percentage

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ruben09" wrote:

> 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
>
>