Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple XY pairs in scatter plot Excel 2007
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. |
#2
|
|||
|
|||
Answer: Multiple XY pairs in scatter plot Excel 2007
To create a trajectory plot with multiple XY pairs in Excel 2007, you can follow these steps:
Your scatter plot should now display all the trajectories you want to plot, with each trajectory represented by a different color or marker style. You can customize the appearance of the chart using the formatting options in the "Chart Tools" tab of the ribbon.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple XY pairs in scatter plot Excel 2007
An am assuming the x-values for the two sets of data are not the same.
If they are then there is a simple solution Otherwise: An other way (may not be much quicker) Make chart with first data set Copy second dataset Click chart Use Edit | Paste Special - New data series - first column has x-values For those thinking of giving you a VBA solution for the 100 charts: 1 - data is on different sheet? 2 - same layout (number of points) in all cases? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Freak Out! | Charts and Charting in Excel | |||
XY scatter plot with multiple data pairs for each variable | Charts and Charting in Excel | |||
3D Scatter plot in Excel | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |