Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting or constructing a graph, from a row with list validation
I am attempting to construct a chart from survey data I have entered
into Excel 2003. Basically, each question equates into a row. The first column contains the text of the question, and each of the following columns contain the specific response from each instance of the data (survey taker). The answers are available from a drop-down validation list, like this: Agree Maybe Disagree Yet, when I use the charting function and highlight the entire row including the actual question, I have no idea how to make that chart graph along the dimensions already outlined by the validation list like I would expect it to, like this: Agree --------------------- 15 Maybe --------- 8 Disagree------------------------- 23 Instead I get a bunch of gibberish, and the chart seems to want to graph along a 0-1 dimension, with no way I can see to reference the validation list. Help !!!!! Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting or constructing a graph, from a row with list validation
Describe what the data looks like.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... I am attempting to construct a chart from survey data I have entered into Excel 2003. Basically, each question equates into a row. The first column contains the text of the question, and each of the following columns contain the specific response from each instance of the data (survey taker). The answers are available from a drop-down validation list, like this: Agree Maybe Disagree Yet, when I use the charting function and highlight the entire row including the actual question, I have no idea how to make that chart graph along the dimensions already outlined by the validation list like I would expect it to, like this: Agree --------------------- 15 Maybe --------- 8 Disagree------------------------- 23 Instead I get a bunch of gibberish, and the chart seems to want to graph along a 0-1 dimension, with no way I can see to reference the validation list. Help !!!!! Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting or constructing a graph, from a row with list validation
I thought I did, but here it goes again -
Agree Maybe Disagree These three choices are all that is available from a drop-down validation list. If you attempt to enter anything other than those three items into one of the corresponding cells, Excel will not allow it. So those three items are the only possibilities available. Agree On Feb 4, 3:30 pm, "Jon Peltier" wrote: Describe what the data looks like. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ wrote in message ups.com... I am attempting to construct a chart from survey data I have entered into Excel 2003. Basically, each question equates into a row. The first column contains the text of the question, and each of the following columns contain the specific response from each instance of the data (survey taker). The answers are available from a drop-down validation list, like this: Agree Maybe Disagree Yet, when I use the charting function and highlight the entire row including the actual question, I have no idea how to make that chart graph along the dimensions already outlined by the validation list like I would expect it to, like this: Agree --------------------- 15 Maybe --------- 8 Disagree------------------------- 23 Instead I get a bunch of gibberish, and the chart seems to want to graph along a 0-1 dimension, with no way I can see to reference the validation list. Help !!!!! Can anyone help?- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting or constructing a graph, from a row with list validation
I thought I asked, but here it is again.
How is your data structured? The chart doesn't care about your data validation, nor do I. How is the data arranged in the worksheet? How do you want it displayed in the chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I thought I did, but here it goes again - Agree Maybe Disagree These three choices are all that is available from a drop-down validation list. If you attempt to enter anything other than those three items into one of the corresponding cells, Excel will not allow it. So those three items are the only possibilities available. Agree On Feb 4, 3:30 pm, "Jon Peltier" wrote: Describe what the data looks like. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ wrote in message ups.com... I am attempting to construct a chart from survey data I have entered into Excel 2003. Basically, each question equates into a row. The first column contains the text of the question, and each of the following columns contain the specific response from each instance of the data (survey taker). The answers are available from a drop-down validation list, like this: Agree Maybe Disagree Yet, when I use the charting function and highlight the entire row including the actual question, I have no idea how to make that chart graph along the dimensions already outlined by the validation list like I would expect it to, like this: Agree --------------------- 15 Maybe --------- 8 Disagree------------------------- 23 Instead I get a bunch of gibberish, and the chart seems to want to graph along a 0-1 dimension, with no way I can see to reference the validation list. Help !!!!! Can anyone help?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation for list in a different workbook | Excel Discussion (Misc queries) | |||
Can Validation against a list do auto-fill in a cell? | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
validation list | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |