Thread: Percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Percentage

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