Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove text values from graphs
I have several graphs put together from data on another tab, however
sometimes this data will come up "N/a" or "No Data" which the graph recognizes as ZERO. Can this be avoided? I only want the graph to graph numberical values. Please assist. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove text values from graphs
Have your formulas return the #N/A error
Example: =IF(A1=B1,A1+B1,NA()) XL graphs ignore the NA error, as it is, by definition, not applicable. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JAbels001" wrote: I have several graphs put together from data on another tab, however sometimes this data will come up "N/a" or "No Data" which the graph recognizes as ZERO. Can this be avoided? I only want the graph to graph numberical values. Please assist. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove text values from graphs
No can do... They must return the values they are.. "N/a" or "No Data" must
come up in order for my workbook to meet other criteria... Suggestions? "Luke M" wrote: Have your formulas return the #N/A error Example: =IF(A1=B1,A1+B1,NA()) XL graphs ignore the NA error, as it is, by definition, not applicable. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JAbels001" wrote: I have several graphs put together from data on another tab, however sometimes this data will come up "N/a" or "No Data" which the graph recognizes as ZERO. Can this be avoided? I only want the graph to graph numberical values. Please assist. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove text values from graphs
Could you setup a hidden table somewhere that duplicates your original data
using formulas similar to: =IF(ISNUMBER(A1),A1,NA()) And then create your graph from this hidden table? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JAbels001" wrote: No can do... They must return the values they are.. "N/a" or "No Data" must come up in order for my workbook to meet other criteria... Suggestions? "Luke M" wrote: Have your formulas return the #N/A error Example: =IF(A1=B1,A1+B1,NA()) XL graphs ignore the NA error, as it is, by definition, not applicable. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JAbels001" wrote: I have several graphs put together from data on another tab, however sometimes this data will come up "N/a" or "No Data" which the graph recognizes as ZERO. Can this be avoided? I only want the graph to graph numberical values. Please assist. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove text values from graphs
As Luke points out, it's very easy to set up multiple data ranges. They can
all be linked to a central table, so they update when the underlying data changes. The drawbacks? You use extra worksheet space. This hasn't been a practical issue since we stopped using COBOL in the mid-80s. The benefits is that you can make ranges which are optimized for charting, display, and further analysis, and save the time it might take to try to make one range fit all needs. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "JAbels001" wrote in message ... No can do... They must return the values they are.. "N/a" or "No Data" must come up in order for my workbook to meet other criteria... Suggestions? "Luke M" wrote: Have your formulas return the #N/A error Example: =IF(A1=B1,A1+B1,NA()) XL graphs ignore the NA error, as it is, by definition, not applicable. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JAbels001" wrote: I have several graphs put together from data on another tab, however sometimes this data will come up "N/a" or "No Data" which the graph recognizes as ZERO. Can this be avoided? I only want the graph to graph numberical values. Please assist. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I ignore Graphs zero values. | Charts and Charting in Excel | |||
paste values with graphs | Excel Discussion (Misc queries) | |||
move values text in graphs all series at once. Excel | Charts and Charting in Excel | |||
Removing 0 or none 0 values from graphs | Charts and Charting in Excel | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) |