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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"getravel" wrote in message
...
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