how do i create a pie chart in excel with non-numerical values?

J

Jon Peltier

Use a pivot table or use some kind of COUNTIF formulas to compile the data
into a list of item and frequency, then construct the chart based on this
calculated data.

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

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

Can you combine an Excel Cluster Bar Graph with a Stacked Bar Grap 1
how do I set up a outlier in excel graph? 2
Built in excel 2007 formats via VBA 2
How can I plot a data series from multiple worksheets 1
How do I sum the lowest n numbers in an array with n variable? 0
is there any sample of an excel dashboard ? 2
Excel 2003 dynamic named range for the values in a pie chart 1
union array 14

Top