View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Multiple series not plotting in their respective data ranges

If you want to plot one variable (price) as a function of another variable
(date), you should be using XY (confusingly named scatter) chart, not line
chart. You can include a line as well as (or instead of) point markers.
--
David Biddulph

"Mike" wrote in message
...
I have a price comparison chart (line chart) that has multiple prices for
multiple dates.

Price 1 has a date range of 01/01/07 - 02/06/07.
Price 2 has a date range of 01/19/07 - 01/31/07 (a subset of the Price 1
range). When Price 2 plots, it starts at the left of the overall range
(01/01/07) and stops at 01/13/07 instead of plotting in the middle of the
chart starting at 01/19/07 and ending at 01/31/07.

Is this a bug or is there a parameter setting I need to tweak?

Thanks, Mike