View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Plotting multiple Y column data versus single X column in Excel 20

Select the column of times, then hold ctrl while selecting the data in
column D, and while selecting the data in F and G. Create an XY chart, using
the option with markers and lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"RossM" wrote in message
...
I have data arranged as Time of day in column B and multiple Y values as
columns D, F, and G
How do I get a multiple line chart with the multiple Y values plotted
versus
the single column of time values in Column B?

Thanks

RossM