I have some graphs that auto populate from data stored in a sheet. for instance B:B is errors and C:C is how many times that error happens. sometimes the amount is 0. all i need is the graph to populate errors that have 1 or greater and ignore the ones that have 0 can some one help?
=if(source cell ref=0,na(),source cell ref) will convert 0s to #N/A, which Excel will ignore. If you don't like the look of them, you can always use conditional formatting to make #N/A appear as white text (and therefore be invisible...).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
where would I enter this formula
you need to use a diferent column for your data series using that formula
see attached
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
okay got that part but your sample graph is still plotting B which has 0 but it still show up on the axis. I am looking to have it show up if its about 0. so if B has 0 errors than i don't want B on the graph at all. Thanks for all the help so far
I just noticed that oyu hadn't quite got what you wanted. Does this help?
I must be an idiot cuz i can't get this to work with my count if statements
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks