Help with "clusters" of plotted data

Marshall · External Since: Sep 17, 2006 Posts: 8

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?

Herbert Seidenberg · External Since: Jan 08, 2009 Posts: 57

Excel 2007 X Y Chart
No weekend gap.
http://www.mediafire.com/file/mmzzdzy4nzy/10_27_09a.xlsx

Jon Peltier · External Since: Feb 01, 2004 Posts: 179

In your data range, list every date, and keep the cells next to weekend
dates empty. By default, Excel skips empty cells in a line or XY chart,
leaving a gap.

Note that a formula that returns "" is not empty, because the cell
contains a formula.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

Marshall wrote:
> 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?