| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Skipping Text Entries
One of my charts contains "N/A" entries. Right now they are showing as zeros
on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but they are still showing as zeros. Is there any way to skip that week if the entry is non-numeric? Thanks. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Skipping Text Entries
have your text entries return the #NA error, such as:
=IF(A2=0,NA(),A2) The #NA error is ignored by charts. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gingerly" wrote: One of my charts contains "N/A" entries. Right now they are showing as zeros on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but they are still showing as zeros. Is there any way to skip that week if the entry is non-numeric? Thanks. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Skipping Text Entries
Replace your "N/A" text entries by the #N/A error code.
If you are doing it by formula you can use =NA() or =#N/A, but not ="N/A" -- David Biddulph "Gingerly" wrote in message ... One of my charts contains "N/A" entries. Right now they are showing as zeros on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but they are still showing as zeros. Is there any way to skip that week if the entry is non-numeric? Thanks. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Skipping Text Entries
Thank you so much, Luke!
"Luke M" wrote: have your text entries return the #NA error, such as: =IF(A2=0,NA(),A2) The #NA error is ignored by charts. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gingerly" wrote: One of my charts contains "N/A" entries. Right now they are showing as zeros on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but they are still showing as zeros. Is there any way to skip that week if the entry is non-numeric? Thanks. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Skipping Text Entries
Thank you so much, David!
"David Biddulph" wrote: Replace your "N/A" text entries by the #N/A error code. If you are doing it by formula you can use =NA() or =#N/A, but not ="N/A" -- David Biddulph "Gingerly" wrote in message ... One of my charts contains "N/A" entries. Right now they are showing as zeros on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but they are still showing as zeros. Is there any way to skip that week if the entry is non-numeric? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| count text entries | Excel Worksheet Functions | |||
| Skipping Import Text File dialog in a Macro | Excel Discussion (Misc queries) | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| How do I fix Text entries in Excel that get cut off? | Excel Discussion (Misc queries) | |||
Linear Mode
