+ Reply to Thread
Results 1 to 4 of 4

Combined line chart and scatter chart

  1. #1
    Registered User
    Join Date
    09-30-2012
    Location
    amman
    MS-Off Ver
    Excel 2010
    Posts
    8

    Combined line chart and scatter chart

    hello,

    I need to create a combined chart :
    - Line chart for columns A, B & C
    - Scatter with only markers chart for column D
    - 8, 10 & 15 on the X axis

    a b c d X Axis
    100 150 170 200 8
    300 8
    400 8
    200 250 270 150 10
    250 10
    350 10
    300 350 370 230 15
    330 15
    340 15



    i would really appreciate it if anyone could help

    thanks in avance.
    Last edited by sara ghaith; 12-13-2012 at 05:45 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,729

    Re: Combined line chart and scatter chart

    create a line chart with all the data (A thru D) and then change the chart type of the last series.
    You will need to move it to the secondary axis and add secondary horizontal axis
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-30-2012
    Location
    amman
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Combined line chart and scatter chart

    thanks for the quick response, but maybe the data was miss understood in the table, so please find the attachment. I draw the 2 graphs that I need to combine to make it clearer
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,729

    Re: Combined line chart and scatter chart

    Use different X values to align scatter on Line chart
    Attached Files Attached Files

+ 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