Hi,

Assume that your data is in columns A:B of sheet1 and sheet2.

1. Extend the dates on sheet1 through Dec 31, 2008 for example. Insert blank rows above the date on sheet2 and enter the dates Jan 1, 2008 and fill down so that your dates end with Jun 30, 2008 and the next row starts the 2nd half's data.
2. Select the data in A:B including the extra dates which have no adjacent data
3. Plot this as a line chart (or if you are using a stock chart type include the additional columns for open, high, low, and volume as needed):
a. Click the Chart Wizard and select the appropriate chart type, click Next
b. Click the Series tab and click Add
c. Highlight the entry in the Values box (={1}) and click on the Sheet2 tab and highlight all the data NOT including the first half dates. Include cell which are blank for the 1st half of the year. Click Finish
4. Change the second series markers to match those of the 1st half - double-click the series and on the Format tab set the Marker and Patterns to match the first series.
5. Single click the legend, then single click the second series legend and press Del.

Assuming you have a lot of data the lack of a visual connection from series 1 to series 2 will not be visible. But if that is a problem simple copy the data for Jun 30, 2008 from sheet1 to the last blank line before the 2nd half data.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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