Results 1 to 10 of 10

combining two different graphs into one (superimposing)

This is a discussion on combining two different graphs into one (superimposing) within the Excel Questions forums, part of the Question Forums category; Hi there! So I have two graphs (x-y line graph) that I would like to combine/superimpose from two separate excel ...

  1. #1
    New Member
    Join Date
    Dec 2010
    Posts
    7

    Default combining two different graphs into one (superimposing)

    Hi there!
    So I have two graphs (x-y line graph) that I would like to combine/superimpose from two separate excel spreadsheets.
    They both have year as x-axis, and one chart has rain accumulation in mm, and the other has population abundance in # of organisms.
    Is there a way to plot this together? (like, y-axis can represent both rain+population abundance)


    screenshot of the graphs below.
    please help!
    thank you


  2. #2
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,866

    Default Re: combining two different graphs into one (superimposing)

    Copy your second set of data. Activate the first chart, Edit > Paste Special, select New Series and click OK.
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Dec 2010
    Posts
    7

    Default Re: combining two different graphs into one (superimposing)

    I don't understand what you mean by copy the second data set.
    Also, under edit, I don't have an option for Paste special.
    Can you please walk me through this a bit more thoroughly please? I'm really bad at excel...

  4. #4
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,866

    Default Re: combining two different graphs into one (superimposing)

    Select the second set of data. Edit > Copy. Click on the first chart to activate it. Edit > Paste Special, tick New Series and follow the prompts.
    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    New Member
    Join Date
    Dec 2010
    Posts
    7

    Default Re: combining two different graphs into one (superimposing)

    there is no special paste under my editing column!!!!
    attached is what i see:

  6. #6
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,866

    Default Re: combining two different graphs into one (superimposing)

    You need to activate the chart by clicking on it.
    HTH, Peter
    Please test any code on a copy of your workbook.

  7. #7
    New Member
    Join Date
    Dec 2010
    Posts
    7

    Default Re: combining two different graphs into one (superimposing)

    I did click on it, but there still is no option to do so


  8. #8
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,866

    Default Re: combining two different graphs into one (superimposing)

    I'm sorry but I don't know how better to explain it. Which version of Excel are you using. Is the chart an embedded chart on a sheet or on a chart sheet?
    HTH, Peter
    Please test any code on a copy of your workbook.

  9. #9
    New Member
    Join Date
    Dec 2010
    Posts
    7

    Default Re: combining two different graphs into one (superimposing)

    I am using excel 2007, probably home or student version (I have windows vista).
    So what I did was I had two shreadsheets with different data in each. I graphed each of those data to get the two graphs. I copy and pasted each graph into a new (3rd) excel worksheet, and that's what you see in the screenshot.

    attached is the screenshots of two separate excel worksheets that I got the graphs from (before I copy and pasted the two graphs into a 3rd worksheet)

    I hope that clarifies a little bit more??? Please please please help...




  10. #10
    VoG
    VoG is online now
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,866

    Default Re: combining two different graphs into one (superimposing)

    Select the data then right click the chart, select Paste Options.
    HTH, Peter
    Please test any code on a copy of your workbook.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com