View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default scatter plots with multiple series

In article ,
says...
I am trying to plot in excel a scatter plot with mulitple xy settings..All
the x setting are time. I am wondering if there is a way with in excel to
select the columns and then plot them accordingly

Thanks

[If the below doesn't work for you, you will have to address the kinds of
questions Andy raised. {grin}]

Yes, you can create a XY Scatter chart with multiple sets of (X,Y) values.
And, the X values can be time as long as they are time as XL understands it.

Simply create the chart with any one pair of X and Y values (time + whatever
it is you are measuring).

Then, select each subsequent pair and drag it onto the chart (or copy,
select the chart and select Edit | Paste Special...) In the resulting
dialog box, make sure XL knows that the first column contains category (X)
values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions