Is there a way if a zero is in a cell that it is not plotted on a chart. Thanks
Is there a way if a zero is in a cell that it is not plotted on a chart. Thanks
Change the zeros to #N/A.
Thanks shg, I am the same one that you just helped with the #DIV. When I use your #N/A it plots both the zero and ignores it by filling in the line but I do not want the one that still goes down to the 0. I tried to paste a picture of my chart nut could not.
How about posting the workbook, zipped and < 100K?
It works perfectly, I had 2 lines plotted with the same data and only changed to #N/A on one of them. Thanks again. This site never ceases to amaze me.
Nah -- blind hog found an acorn. You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks