Thread: [Solved] Empty cells plotted as zero.
View Single Post
 
Old 03-03-2013, 06:52 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi Colin
Go to FILE > OPTIONS > ADVANCED
And untick the "Show a Zero in cells that have a zero value.
Good luck.
Tony
Reply With Quote