The easiest way is to have both sets of data on one (a new?) worksheet. Then
you can plot as with one or two series. Copy and Paste (or Copy Paste
Special as Values) to a new worksheet is a quick process.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave" wrote in message
...
I have stock portfolio info for January thru June, which plots easily.
After portfolio changes, I have another plot for July thru December. Plots
easily.
These data are on 2 separate worksheets.

Now I would like to plot a single curve for the year. The first 6 months
is easy. How can I plot a continuous curve for the whole year without
having to insert the first 6 months worth on the last 6 months worksheet?

Not sure I explained this very well, but ---

Dave