If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|