Alternatively,
Make chart from all the data (two series)
Right click chart; open Source Data dialog
Make y data series have x-values A2:A5 and y-value B2:B5
Make z data series have x-values A5:A9 and y-values C5:C9
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Derfel" wrote in message
...
I made it work. I had to create two new rows in the source spreadsheet and
include the blank cells that correspond to the x values. Now if I can
just
figure out how to get a trendline for each that doesn't spread across the
entire sheet!

"Bernard Liengme" wrote:

Sounds like you made a Line Chart when an XY chart was needed.
Try that and let us know how it goes.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Derfel" wrote in message
...
Elizabeth:

I am trying to do the same thing. Did you get this to work? I wasn't
successful plotting two sets of data on a single x-axis. The second
data
set
plotted from the y-intercept rather than along the end of the
horizontal
axis

"Elizabeth" wrote:

Hello. I am working on a line chart that shows 12 weeks of data for
homework
completion. The X axis is weeks and the Y axis is rate of completion.
Weeks
1-6 were baseline and data was collected for completion. Weeks 7-12
were
experimental where an intervention was used to influence homework
completion.
I would like to be able to insert a trend line for weeks 1-6 and a
separate
trend line for weeks 7-12 on the same graph to compare student
performance.
Right now, when I right-click on a data point in my grapn to create a
trendline, I get a trendline for all 12 weeks of data. Can anyone
help
me
create two seperate trendlines? Thanks

Elizabeth