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

Hi Luke,

is a2=b2?
is a3=b1?

Luke M wrote:
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

On Oct 1, 2:29*pm, "Ruben09" <u55173@uwe wrote:
Hi Luke,

is a2=b2?
is a3=b1?

Luke M wrote:
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

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

jsut highlight the four cells and insert the chart