+ Reply to Thread
Results 1 to 4 of 4

Multiple Lines/Series in One Graph

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Nederland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Multiple Lines/Series in One Graph

    Hi,

    I want to create a graph which contains multiple lines (each line represents 200 untill 204) from the data below.
    The dates are as the horizontal axis and the values in column 3 are the vertical axis.

    I have tried to create the graph but I only get the first line (which represents 200) in it and I don't know how to add the other ones.

    13-3-2012 200 4046
    13-3-2012 201 8
    13-3-2012 202 3701
    13-3-2012 203 16
    13-3-2012 204 60
    14-3-2012 200 5000
    14-3-2012 201 20
    14-3-2012 202 3000
    14-3-2012 203 20
    14-3-2012 204 55

    Could you please help me?


    Thanks and best regards,
    Adi

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

    Re: Multiple Lines/Series in One Graph

    You need to change the layout of the data.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Multiple Lines/Series in One Graph

    test.xlsHi
    note sure what you want here - do any of these three fit what you're after?

  4. #4
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Multiple Lines/Series in One Graph

    Hi,
    May be a variant with pivot table and pivot chart if you have a lot of data
    Transform your data in table
    Insert a pivot chart and format vertical axis to logarithmic base 10 as proposed by Andy Pope
    Refresh pivot table when adding or inserting data in your table
    Hope this helps
    Best regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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