The problem is that the cells that I am asking the chart to plot have formulas in them and even if the cell in the source data has a formula it recognizes it as zero and plots as such. How do I get the chart to not plot a value with a formula in the cell within the defined source data?
Sorry I didn't explain this well in my post: VLOOKUP previously. Mike
If you make the formula return #N/A error instead of blank, I think it will break at that entry instead of plotting a 0.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks