Chart Series Over Time are overlapping

[yyyghb4]

I've tried searching with little luck, probably because I don't exactly know how to word what I'm looking for, so sorry if this has already been answered.

Here's what I've got...
A pivot table with values per day, and the days grouped into weeks. So for example:

7/4/2010 - 7/11/2010 | 4
7/11/2010 - 7/18/2010 | 6
7/18/2010 - 7/25/2010 | 12
7/25/2010 - 8/1/2010 | 8
ect...

I have records for each week going up to present. I want to create three series for sequential groups of records. Then, on the graph, the X axis would be time, and Y would be values. Then Series 1 would run from it's start date to finish, where Series 2 would pick up, and likewise run to the end of it's time, and then Series 3 would pick up.

Right now, all I seem to get is three series, all starting at the begining of the X axis and running in parallel, rather than sequentially. I've tried using Line Charts, XY Charts, and even hybrid charts where one series is a Line type and the other are XY types.

Can someone help me?
Thanks,
George

 

[Derek Brown]

I am not sure that I fully understand the problem but I wonder if you should be having all Series with the same start and end dates - then using #N/A where the dates are not applicable to a series. Using "=NA()" will give you that 'error' and Excel charts will ignore them completely.

 

[yyyghb4]

Sorry for the confusion. I was able to create what I wanted, but not how I need to. I had to spilt my data into three different columns, with zero values around my data to get the segments spaced where I needed in the XY chart. Then, when I added trend lines, it of course, wanted to trend then entire X axis for each segment. So I actually used the line tool to draw over the trend lines, and then deleted the trendlines, leaving the drawlings.

Problem is, this is WAY to much work for me to do on a weekly report. Anyone have any easier way to help me get my end results?

Data:

Graph:

 

[Derek Brown]

Whenever I have an unusaul chart requirement and need a few ideas, there is only one place to go:
http://peltiertech.com/Excel/Charts/ChartIndex.html


In particular, have a look at the following where you will find an example of what I think you are trying to do:
http://peltiertech.com/WordPress/plot-two-time-series-and-trendlines-with-different-dates/