+ Reply to Thread
Results 1 to 3 of 3

combined scatter plot and line data

  1. #1
    Registered User
    Join Date
    06-24-2006
    Posts
    2

    combined scatter plot and line data

    Hello

    How I display a line graph and a scatter plot on the same chart?

    Barry

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    1. Create a Scatter chart with the scatter data.
    2. Highlight your line data and drag and drop the data onto the scatter chart. Select New Series as the option then click OK
    3. Click on of the line chart datapoints, then right click. Select Chart Type and change it to Line chart
    4. If you want to, you can put the line chart on the second Y axis by right clicking the line chart, and selecting Axis Second Y axis

    Matt

  3. #3
    Jon Peltier
    Guest

    Re: combined scatter plot and line data

    Is this what you need, or do you simply need to remember that series in both
    XY and Line series can be formatted to have lines or no lines, markers or no
    markers.

    The difference between line and XY charts is in the treatment of the X axis:
    http://peltiertech.com/Excel/ChartsH...ValueAxis.html
    http://pubs.logicalexpressions.com/P...cle.asp?ID=190

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


    "Mallycat" <Mallycat.29xv0b_1151206502.2574@excelforum-nospam.com> wrote in
    message news:Mallycat.29xv0b_1151206502.2574@excelforum-nospam.com...
    >
    > 1. Create a Scatter chart with the scatter data.
    > 2. Highlight your line data and drag and drop the data onto the scatter
    > chart. Select New Series as the option then click OK
    > 3. Click on of the line chart datapoints, then right click. Select
    > Chart Type and change it to Line chart
    > 4. If you want to, you can put the line chart on the second Y axis by
    > right clicking the line chart, and selecting Axis Second Y axis
    >
    > Matt
    >
    >
    > --
    > Mallycat




+ 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