+ Reply to Thread
Results 1 to 2 of 2

line chart

Hybrid View

  1. #1
    Registered User
    Join Date
    03-26-2008
    Posts
    19

    line chart

    hi guys,
    i need help with line charts.
    here is the data i have and i need the Date on the x axis and the calls on the y.Two lines,one for each city.I've tried and not working for me.Anyone who can help me with this please?

    Date City Calls
    1/2/2013 NYC 38
    1/2/2013 London 5
    1/3/2013 NYC 49
    1/3/2013 London 4
    1/4/2013 NYC 2
    1/4/2013 NYC 115
    1/4/2013 London 6
    1/5/2013 NYC 2
    1/5/2013 NYC 337
    1/5/2013 London 18
    1/6/2013 NYC 1
    1/6/2013 London 21
    1/7/2013 NYC 1204
    1/7/2013 NYC 125
    1/7/2013 London 6
    1/8/2013 NYC 41
    1/8/2013 London 3

  2. #2
    Registered User
    Join Date
    08-13-2012
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: line chart

    Try rearranging your data as shown below; select the data; insert the line graph.

    Date London NYC
    1/2/2013 5 38
    1/3/2013 4 49
    1/4/2013 6 117
    1/5/2013 18 339
    1/6/2013 21 1
    1/7/2013 6 1329
    1/8/2013 3 41
    http://www.mrspreadsheets.com

+ 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