+ Reply to Thread
Results 1 to 2 of 2

Combining Scatter Plots

  1. #1
    TKL
    Guest

    Combining Scatter Plots

    Is there a simple way to combine two sets of X-Y data on one plot. Note here
    that the X values in the two sets are not the same.

  2. #2
    Andy Pope
    Guest

    Re: Combining Scatter Plots

    Hi,

    Assuming you already have a xy scatter chart you can either use the
    Source Data dialog to add a new series and then select the cells for the
    x and y values. Or you can select the 2 columns of data and drag and
    drop them onto the chartobject. The paste special dialog should be
    displayed. Make sure the New Series option is ticked and also check
    Categories X values in first column.

    Cheers
    Andy

    TKL wrote:
    > Is there a simple way to combine two sets of X-Y data on one plot. Note here
    > that the X values in the two sets are not the same.


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1