| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is it possible to display text in charts?
I am creating graphs for results from a survey. Part of this is to graph each
individual's response to every question. If a person did not answer a question, I would like "N/A" to appear in the data for the chart. I am not using formulas -- the numbers are typed directly into the spreadsheet. Is there any way to have the text "N/A" display in the chart data? Currently, if I enter text in the corresponding cell, it displays as "0" in the chart data. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
| How can I make Excel display HTML code as text | Excel Discussion (Misc queries) | |||
| Don't won't charts to display Zeroes | Charts and Charting in Excel | |||
| How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
Threaded Mode
