• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1981
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# i am trying to create a live pie chart to show the percent

i am trying to create a live pie chart to show the percent of day completed. Example: Start date: 4/2/2009 End date:05/13/2015. Now i want to show the percent completed on the Current date that i open the document. is this possible?

The-PC-Guy :

The-PC-Guy :

what cell is your start date and end dates in?

Customer:

d9 e9

The-PC-Guy :

ok

The-PC-Guy :

i will give you a formula in a second

Customer:

ok

The-PC-Guy :

first you will have to add the following to another cell

The-PC-Guy :

=TODAY()

The-PC-Guy :

lets say add to cell F9

The-PC-Guy :

for now

The-PC-Guy :

im working out the formula

The-PC-Guy :

=(E9-F9)/(E9-D9)

The-PC-Guy :

that will give you percent from today until end date

The-PC-Guy :

assuming you put

The-PC-Guy :

=TODAY()

The-PC-Guy :

in f9

Customer:

ok

The-PC-Guy :

then you can subtract that value from 100%

The-PC-Guy :

in another cell

The-PC-Guy :

to create your pie chart from that data

The-PC-Guy :

let me know if you need anything else

The-PC-Guy :

OTHERWISE

The-PC-Guy :

The-PC-Guy :

you do so with the smileys underneath this chat

Customer:

i will

Customer:

subtract what value

The-PC-Guy :

the value you get from the

The-PC-Guy :

8:14 PM

=(E9-F9)/(E9-D9)

The-PC-Guy :

that is the percentage diference of today and end date

The-PC-Guy :

pie charts always add up to 100#

The-PC-Guy :

100%

The-PC-Guy :

so 100% minus the value of that formula

The-PC-Guy :

give you remaining percentage to complete the pie chart

Customer:

ok. which cells would I need to select to graph that?

Customer:

i put that formula in G9

Customer:

and got .256...

The-PC-Guy :

maybe it would be better if i sent an example

Customer:

ok

Customer:

is it going my email?

The-PC-Guy :

i will post it here

The-PC-Guy :

Customer:

ok

The-PC-Guy :

The-PC-Guy :

oops

The-PC-Guy :

let me send it a different way

Apache/2.2 Server at ww2.justanswer.com Port 80
Customer:

ok

The-PC-Guy :

Customer:

ok i understand that better. thanks. :).

The-PC-Guy :

np

Customer:

Excellent service

The-PC-Guy :