View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
TinleyParkILGal TinleyParkILGal is offline
external usenet poster
 
Posts: 5
Default Charts for 2008 with No Values

Professionals, I want to continue my 2007 charts through 2008 but without
values until the time arrives. My charts just show 0's for all of 2008 even
though I clicked on tools, options, chart, and plot emty cells as not plotted
(leave gaps).

How can I do this?

Oct 2007 - 2
Nov 2007 - 5
Dec 2007 - 9
Jan 2008 - NOT PLOTTED
Feb 2008 - NOT PLOTTED

Thanks in advance.