Plotting 1 curve from 2 separate x-axis data
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 |
Plotting 1 curve from 2 separate x-axis data
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 |
Plotting 1 curve from 2 separate x-axis data
OK Bernard-
I guess I knew that - just hoping there was some other clever way. And thank you Dave "Bernard Liengme" wrote in message ... 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 |
Plotting 1 curve from 2 separate x-axis data
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 |
Plotting 1 curve from 2 separate x-axis data
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 "Shane Devenshire" wrote in message ... 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 |
All times are GMT +1. The time now is 03:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com