In a data set I have formulas that will give a result of "" if the lookup is false. I would like these to not chart as 0, which is what it is currently doing. I have had charts in the past which if there is no info in the cell the line just stops. For some reason I cannot get it to stop it just defaults an empty cell or "" on formula to a value of 0. How can I stop this?
Take a look at Andy Pope's remedy here
http://www.andypope.info/charts/brokenlines.htm
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks