View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Multiple XY pairs in scatter plot Excel 2007

Would this utility be of any help?

http://peltiertech.com/Excel/ChartsH...rtUtility.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DSO" wrote in message
oups.com...
I want to create a trajectory plot, being that each trajectory is a
set of XY pairs (2 columns).

For that I've been using the scatter plot, however if I select more
then one pair of XY columns Excel creates multiple Y series using the
first column as X axis values for all the series. So I have been
forced to add series one by one in the Select data menu.

Since I have hundreds of trajectories to plot, I'm searching for a
more practical way to add series to the graph.

I would greatly appreciate any help on this issue.