Chart to report frequency of a value as a percentage of values

J

johnnyrover

I have a column of information, I would like to create a pie chart which
outlines the number of times a value exists as a percentage of the total
number of values.

Thanks

John
 
T

Tushar Mehta

Check out XL's PivotTable capability. It is well suited to the kind of
analysis you want to do.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 Data Labels options not saving 0
Pie Chart that Shows Values instead of Percentages 1
Pie charts - 0 values 2
Pie Chart 4
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0
Requesting help to generate progress reports in Excel ... 0

Top