Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to get multiple XY pairs in Excel 2007 Scatter plot

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-02-2012
Member
 
Join Date: Sep 2005
Posts: 185
How to get multiple XY pairs in Excel 2007 Scatter plot

I want to create a trajectory plot and 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 With Quote
  #2  
Old 25-02-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: How to get multiple XY pairs in Excel 2007 Scatter plot

I am assuming the x-values for the two sets of data are not same. If they are then there is a simple solution for that:
  • 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: data is on different sheet same layout (number of points) in all cases.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to get multiple XY pairs in Excel 2007 Scatter plot"
Thread Thread Starter Forum Replies Last Post
How to plot XYZ points in Microsoft Excel Genesee MS Office Support 1 25-02-2012 11:38 AM
How to point label in Excel scatter plot with text associated to it Kanshin MS Office Support 2 25-02-2012 11:37 AM
Bug in Microsoft Excel Scatter Plot Jaques Strapp MS Office Support 2 03-02-2012 07:22 PM
One Click selecting Multiple Cells in Excel 2007 Gridharan Windows Software 3 04-01-2012 07:40 PM
Scatter plot in excel Gunner 1 Windows Software 5 06-01-2010 02:14 PM


All times are GMT +5.5. The time now is 06:39 AM.