Closed Thread
Results 1 to 4 of 4

Line Graph: multiple lines from multiple data sets?

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    West Coast US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Line Graph: multiple lines from multiple data sets?

    Hi,

    I'm looking to make multiple lines from multiple data sets so I can see them lay over each other.

    I can also have the different data sets in the same worksheet to pull from, in fact that's easier.

    What I'm trying to do is calculate my hourly spend over a 24 hour period, but have a different line stretching over a 24 period... for each day

    Does that make sense?

    Cheers

  2. #2
    Registered User
    Join Date
    05-27-2011
    Location
    West Coast US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Line Graph: multiple lines from multiple data sets?

    I've attached the csv file as a zip file. Not sure why it wouldn't allow me to upload it as a csv file but it wasn't doable.

    As you can see in the date/time column I have multiple days. I would really appreciate help with creating a line for each day- x axis being the hourly time and y axis being the cost column.

    Please help me out I've spent over 2 hours with it trying to figure it out.

    Cheers
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-27-2011
    Location
    West Coast US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Line Graph: multiple lines from multiple data sets?

    You guys are a worthless forum. Thx

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

    Re: Line Graph: multiple lines from multiple data sets?

    You don't expect much from a free service do you.
    Cheers
    Andy
    www.andypope.info

Closed 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