View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
getravel
 
Posts: n/a
Default Need to show percentage in a column chart

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.
--
Thanks,
getravel