Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
what cell is your start date and end dates in?
i will give you a formula in a second
first you will have to add the following to another cell
lets say add to cell F9
im working out the formula
that will give you percent from today until end date
assuming you put
then you can subtract that value from 100%
in another cell
to create your pie chart from that data
let me know if you need anything else
you do so with the smileys underneath this chat
subtract what value
the value you get from the
that is the percentage diference of today and end date
pie charts always add up to 100#
so 100% minus the value of that formula
give you remaining percentage to complete the pie chart
ok. which cells would I need to select to graph that?
i put that formula in G9
and got .256...
maybe it would be better if i sent an example
is it going my email?
i will post it here
so you can download it
click that link to download
let me send it a different way
The requested URL /uploads/TH/thepcguy/2013-10-17_002759_example.xlsx was not found on this server.
try this link
ok i understand that better. thanks. :).
please remember to rate