Need to show percentage in a column chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a column chart showing 2 quarterly totals - (1) Total requests
and (2) Urgent requests. I need a formula that will calculate the percentage
of Urgent requests in relation to the number of total requests.

I checked the two (PERCENTRANK and PERCENTILE) that I found in the Insert
Function dialog, but neither of these provided the percentage that I'm
looking for.

Any informtion you can provide would be greatly appreciate.
 
You just need to divide urgent requests by total requests, and format as a
percentage.

- Jon
 
Jon,

thanks for taking the time to reply back. Please allow me to clarify my
question.

I know which figures to use to get the percentage, but what I'm looking for
is a formula that will do this for me - divide one cell (Urgent requests) by
the other (Total requests). I can manually figure out the percentage, but
the values in these two cells will increase on a daily basis. I'd rather let
the formula figure out the percentage.

Do you know if there is such a formula?

Thanks again for taking the time to write.

--
Thanks,
getravel (Mike)


Jon Peltier said:
You just need to divide urgent requests by total requests, and format as a
percentage.

- Jon
Click to expand...
 
Jon,

thanks for taking the time to reply back. Please allow me to clarify my
question.

I know which figures to use to get the percentage, but what I'm looking
for
is a formula that will do this for me - divide one cell (Urgent requests)
by
the other (Total requests). I can manually figure out the percentage, but
the values in these two cells will increase on a daily basis. I'd rather
let
the formula figure out the percentage.

Do you know if there is such a formula?

Thanks again for taking the time to write.
Click to expand...

The formula is simply =(Urgent requests)/(Total requests)

For (Urgent requests) put the reference of the cell which has your number of
urgent requests, and for (Total requests) put the reference of the cell
which has your number of total requests.
 
Thank you David (and Jon, if you happen to view this post).

I can't help but laugh at myself ... at how simple this really was!!! It
really couldn't be any simpler!!!

In my original formula, I was looking for a function, such as DIV, to
indicate a cell was to be divided. But obviously, I was making my formula
more difficult than necessary.

Once again, thank you so much for all your assistance.
 
Back
Top