View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
marshall marshall is offline
external usenet poster
 
Posts: 14
Default Help with "clusters" of plotted data

I've been looking everywhere and I cannot seem to find a solution to my
problem. I have data in my spreadsheet that is 'test' data from a lab. The
lab doesn't generate data over weekends/holidays, so I'll have a bunch of
data points from M-F dates, but then there is a gap in days then the data
starts flowing again.

10-2-2009
10-5-2009
10-6-2009
10-7-2009
10-8-2009
10-9-2009
10-12-2009

When I plot this data using the X-Y graph (my situation isn't conducive to
using a line graph), I'll have clusters of 5 days worth of data...a 2 day gap
on the x-axis for the weekend and then another cluster. I want to have the
sequential data points connected by a line and not have a line across the
data gaps.

Is there a way to do this?