ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Help with pie chart (https://www.excelbanter.com/charts-charting-excel/125841-help-pie-chart.html)

Leonard

Help with pie chart
 
I want to see if there is a way to create a pie or other chart that shows the
percentage of total yes that come from each individual with the below data
table...

Thanks in advance for your assistance...

# of Yes # of Calls % Yes % of Total Yes
Frank - - - 0%
Leo 3 3 100% 60%
Shammy - - - 0%
Rosalia - - - 0%
Katie - - - 0%
Hector 2 2 100% 40%
Arash - - - 0%
Abdool - - - 0%
Alvaro - - - 0%
Totals 5 5 100%


Jon Peltier

Help with pie chart
 
You can either plot the percentages, or plot the #Yes column and select the
data labels option to show percentages.

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


"Leonard" wrote in message
...
I want to see if there is a way to create a pie or other chart that shows
the
percentage of total yes that come from each individual with the below data
table...

Thanks in advance for your assistance...

# of Yes # of Calls % Yes % of Total Yes
Frank - - - 0%
Leo 3 3 100% 60%
Shammy - - - 0%
Rosalia - - - 0%
Katie - - - 0%
Hector 2 2 100% 40%
Arash - - - 0%
Abdool - - - 0%
Alvaro - - - 0%
Totals 5 5 100%




Leonard

Help with pie chart
 
Worked... Thanks for your help.

"Jon Peltier" wrote:

You can either plot the percentages, or plot the #Yes column and select the
data labels option to show percentages.

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


"Leonard" wrote in message
...
I want to see if there is a way to create a pie or other chart that shows
the
percentage of total yes that come from each individual with the below data
table...

Thanks in advance for your assistance...

# of Yes # of Calls % Yes % of Total Yes
Frank - - - 0%
Leo 3 3 100% 60%
Shammy - - - 0%
Rosalia - - - 0%
Katie - - - 0%
Hector 2 2 100% 40%
Arash - - - 0%
Abdool - - - 0%
Alvaro - - - 0%
Totals 5 5 100%






All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com