hi Hangman, is there a sequence you want your data to be seen? if not, 1 way might be to create another table to base your chart on. this table will not have the NA values. you can use formulas to identify non-NA values your current table & the other table will only pick those with numbers. then do a Name Range for them & include in the chart. i've attached an eg for you.
do upload a file if this doesn't help
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
HangMan 
Register To Reply
Bookmarks