Results 1 to 2 of 2

Thread: How to get multiple XY pairs in Excel 2007 Scatter plot

  1. #1
    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.

  2. #2
    Join Date
    Aug 2011
    Posts
    542

    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.

Similar Threads

  1. How to plot XYZ points in Microsoft Excel
    By Genesee in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 10:38 AM
  2. Replies: 2
    Last Post: 25-02-2012, 10:37 AM
  3. Bug in Microsoft Excel Scatter Plot
    By Jaques Strapp in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 06:22 PM
  4. One Click selecting Multiple Cells in Excel 2007
    By Gridharan in forum Windows Software
    Replies: 3
    Last Post: 04-01-2012, 06:40 PM
  5. Scatter plot in excel
    By Gunner 1 in forum Windows Software
    Replies: 5
    Last Post: 06-01-2010, 01:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •