Thread: 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

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" <getravel(takethisout)@comcast.net> wrote in message
news:3B882819-6B54-486A-8228-625710FCAE7F@microsoft.com...
> 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

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" wrote:

> 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" <getravel(takethisout)@comcast.net> wrote in message
> news:3B882819-6B54-486A-8228-625710FCAE7F@microsoft.com...
> > 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
>
>
>

"getravel" <getravel(takethisout)@comcast.net> wrote in message
news:369BAF8E-F953-4D16-ACFA-0A958A8DC40B@microsoft.com...
> "Jon Peltier" wrote:
>> "getravel" <getravel(takethisout)@comcast.net> wrote in message
>> news:3B882819-6B54-486A-8228-625710FCAE7F@microsoft.com...
>> > 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,
>
> 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.

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.
--
David Biddulph

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.

--
Thanks,
getravel (Mike)


"David Biddulph" wrote:

> "getravel" <getravel(takethisout)@comcast.net> wrote in message
> news:369BAF8E-F953-4D16-ACFA-0A958A8DC40B@microsoft.com...
> > "Jon Peltier" wrote:
> >> "getravel" <getravel(takethisout)@comcast.net> wrote in message
> >> news:3B882819-6B54-486A-8228-625710FCAE7F@microsoft.com...
> >> > 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,
> >
> > 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.
>
> 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.
> --
> David Biddulph
>
>
>