+ Reply to Thread
Results 1 to 3 of 3

Drawing a simple correlation chart

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    poland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Drawing a simple correlation chart

    Hi Guys,
    I have a simple question.

    I am trying to figure out for hours how to compare GDP growth to number of IPOs (initial public offerings) from year 2005 to 2011, and present it in a plot diagram.

    Attached is the data.

    Year GDP per year (%) No. Of IPOs on the GPW
    2005 3,5 35
    2006 6,5 38
    2007 6,7 81
    2008 4,9 33
    2009 1,8 13
    2010 3,8 34
    2011 3,8 38


    Any help will be greatly appreciated. THANKS
    Attached Files Attached Files

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

    Re: Drawing a simple correlation chart

    You could use xy-scatter with year as marker label.
    Bubble chart.
    Or 2 lines on separate axes.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-16-2012
    Location
    poland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Drawing a simple correlation chart

    Thanksa lot Andy!!!

    You are a G

+ 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