Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help pulling percentages from all work pages | Excel Worksheet Functions | |||
Validation of Percentages Does Not Appear To Work | Excel Discussion (Misc queries) | |||
In Over My Head - Multiple Column Percentages | Excel Discussion (Misc queries) | |||
I can't get the percentages to work in a bar chart data label. | Charts and Charting in Excel | |||
How do i work out percentages using excel? | Excel Discussion (Misc queries) |