LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jennifer
 
Posts: n/a
Default How can I get a data table to recognise and display "N/A"?

I have created a chart to compare figures for the past five years. There
are some categories that started only three years ago. As a result, there
are two years where the category is not applicable.

In the Excel spreadsheet (the source of the graph), I have written "N/A" for
these. In the graph, they are not graphed and the data table says "0".

What I would like is for the data table to read "N/A", so that it is clear
to those who read the graph that we didn't have zero participants, but that
the program was unavailable.

Is there any way to do this?

Jennifer
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum data in cell Rachael Excel Discussion (Misc queries) 12 January 25th 06 05:46 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"