Plotting 1 curve from 2 separate x-axis data

[Dave]

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

 

[Bernard Liengme]

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

 

[Dave]

OK Bernard-
I guess I knew that - just hoping there was some other clever way.

And thank you

Dave

 

[Shane Devenshire]

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]

Hi Shane - thank you for the tip

When I try to arrange the data as you suggest, the second half year plot
wants to start in January rather than essentially continue on from June.
After fooling around with some options, it may be because all my transaction
(data) dates) are irregular. I think the second curve dates confuses the
date intervals for the first curve, and the end result is unsatisfactory.

Any thoughts on that?


Dave

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