how do i create a pie chart in excel with non-numerical values?
|
how do i create a pie chart in excel with non-numerical values?
In article ,
says... What does that mean? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
how do i create a pie chart in excel with non-numerical values?
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/ _______ "feirin" wrote in message ... |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com