LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 39
Default How can I work out percentages of a particular column?

Hi

I have 1160 rows of client information listing the addresses and country.
The last column is the country and what I would like to do is to show a
graph that calculates how many times a country is listed in the column and
then work out the percentage of it's use.

For example, assuming it was 100 clients and only United Kingdom, USA and
France were listed with UK being listed 41 times, USA listed 36 times and
France listed 23 times, I would like to see a chart that says United Kingdom
41%, USA 36% and France 23%

I don't care what sort of chart can prioduce this but there may be quite a
lot of countries in the actual column.

Can this be done, and if so, how can I do it. I have absolutely no idea.

One final thing, it doesn't have to be a chart - It could just be a list
stating the percentage values.

If anyone can help with this, it would be greatly appreciated.

Thanks in advance

Mal
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help pulling percentages from all work pages lumbergirl Excel Worksheet Functions 1 June 19th 08 07:27 PM
Validation of Percentages Does Not Appear To Work VScott @ McWane Excel Discussion (Misc queries) 1 May 8th 07 11:34 PM
In Over My Head - Multiple Column Percentages cybergardener Excel Discussion (Misc queries) 8 August 11th 06 09:01 PM
I can't get the percentages to work in a bar chart data label. C. Rizzo Charts and Charting in Excel 1 February 24th 06 11:39 PM
How do i work out percentages using excel? Fern Excel Discussion (Misc queries) 1 April 12th 05 11:54 AM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"