+ Reply to Thread
Results 1 to 5 of 5

Need help creating a line graph from a data set.

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    7

    Need help creating a line graph from a data set.

    I have a spreadsheet with Data in 5 columns (State, Date, % of A, % of A late, % of B, % of B Late)

    I am looking to create 2 charts with Dates along the X axis and 0%-100% on the Y axis:

    1. Displays 2 lines for each state ( % of A and % of A late)
    2. Displays 2 lines for each state ( % of B and % of B late)

    I am not sure why but I can't seem to get it to work properly. Any guidance would be appreciated

    Thank you
    Last edited by olivetwist; 04-17-2013 at 04:19 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Chart help

    Hi,

    Some sample data will help you get a swift answer on this.

    Also, in accordance with the forum rules, your post title will have to be changed to something a little more descriptive of the actual problem.

    S.
    If I've been of help, please hit the star

  3. #3
    Registered User
    Join Date
    01-17-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Chart help

    sample.xls

    Here is a small sample of how the data is set up.

    changed title
    Last edited by olivetwist; 04-17-2013 at 04:20 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Need help creating a line graph from a data set.

    Are you able to change the data layout or does it have to stay this way?

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Need help creating a line graph from a data set.

    I could change it, i would just have to adjust a few formulas

+ 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