View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
Posts: 128
Default Connecting missing points with a dotted line

Hi,

I have a question about charts. I have a solid line connecting each of my
points in a time-series (days in a month). However, I am missing several
points. For example, lets say Tuesday-Friday of the first week is missing. I
want to connect Monday to Saturday using a dotted line. Right now the cells
for Tuesday-Friday are blank, so it does not draw anything. How can I do this
dotted line most efficiently? Thank you very much!