View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dave Dave is offline
external usenet poster
 
Posts: 55
Default 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