I have a s/s where a formula assigns the value blank ("") in some cases. When I chart this, the line series takes the value as zero, and draws the line. How do I make the chart ignore these blank values? Thanks
I have a s/s where a formula assigns the value blank ("") in some cases. When I chart this, the line series takes the value as zero, and draws the line. How do I make the chart ignore these blank values? Thanks
Make the formula assign the #N/A error instead. It's ignored.
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Welcome to Excel forum,
Try
Right click on chart and choose select data ->>>> left corner on the open window there is tab for Hidden and empty cell setting click on the same.- >>> check mark on connect data points with line ->>> then ok and ok.
May be this will you .
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks