Line chart that does not plot zero values
I accumulate daily info (numerical) and totaled by month. The running monthly totals are inserted by formula into other cells that will plotted as cumulative data in a line chart. The cells for future months have zero's due to the formulas. How can zeros not be plotted?
Hi Trolley Dude, welcome to the forum.
Have your formulas produce NA() instead of zero. Then these points will not drop to zero but the line will connect straight through to the next point.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
It Works. Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks