How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1873
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

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

This answer was rated:

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 :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

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 :

PLEASE RATE

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 :

so you can download it

Customer:

ok

The-PC-Guy :

click that link to download

The-PC-Guy :

oops

The-PC-Guy :

let me send it a different way

Customer: Not Found

The requested URL /uploads/TH/thepcguy/2013-10-17_002759_example.xlsx was not found on this server.



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

ok

The-PC-Guy :

try this link

Customer:

ok i understand that better. thanks. :).

The-PC-Guy :

np

Customer:

Excellent service

The-PC-Guy :

please remember to rate

The-PC-Guy and 3 other Microsoft Office Specialists are ready to help you