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!

Janine,

You can try applying a custom format to those entries that are coming across
as zero. To do so, select one of the entries that has a zero value on your
worksheet. Go to the Standard Toolbar and select Format Cells. In the
Format Cells dialog box, go to the Number tab. Scroll down to the bottom
untill you see the "Custom" format. In the Type input area for the Custom
format, enter "N/A" - be sure to enter the quotes with it.

If you add a data table or labels to your chart, the text value N/A will
come across for zero values.

--
Regards,
John Mansfield
http://www.pdbook.com


"Janine" wrote:

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!