Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pie chart with text data
I'm a newbie at some of the functions of Excel and this is one of
them. I need to take the responses to a survey that have been saved as an excel sheet and make them into a pie chart. There are 5 answers and 4 categories. Is there any way to do that? I would appreciate any help I can get on this one. Do I need to assign a numeric value to each response and another to each category? Like I said, I haven't used some of the functions in excel and this is one of them. Thanks for any help. Mitch |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
pie chart with text data
It isn't clear what you want to do.
Do you have many responsdents, each responding to 5 answers, each with 4 categories? Or, do you have 5 responses, each of whom provided an answer to the 4 categories? Also, what do you want to make into a pie chart? What, specifically, would each wedge in the chart represent? -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu " wrote: I'm a newbie at some of the functions of Excel and this is one of them. I need to take the responses to a survey that have been saved as an excel sheet and make them into a pie chart. There are 5 answers and 4 categories. Is there any way to do that? I would appreciate any help I can get on this one. Do I need to assign a numeric value to each response and another to each category? Like I said, I haven't used some of the functions in excel and this is one of them. Thanks for any help. Mitch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fix a text box to a chart data point? | Charts and Charting in Excel | |||
Chart data from text file | Charts and Charting in Excel | |||
Creating a chart of text data | Excel Discussion (Misc queries) | |||
pivot-like chart for text data | Excel Discussion (Misc queries) | |||
Bar Chart for Text Data | Charts and Charting in Excel |