Results 1 to 15 of 15
  1. #1
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Wink *** Simple Muti-Series Line Graph ***

    Goal: produce a line graph with these conditions

    * multiple lines (series) of K

    ** going across the graph using X data (horizontal axis)

    *** by Y (vertical axis)

    i don't know what to look for. the information out there is a mess, and it's hard to separate the garbage from the quality, so i really really prefer a link to a guide/article/video. if you could link that, it would be great

    there are many ways to do this, but is the best way?

    excel 2010, win
    Last edited by computerbabyproblems; 2013-08-05 at 17:35.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you post an example workbook with some representative data and perhaps (if nothing else) a "drawing" of what the chart should look like.

    Steve

  3. #3
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    i'll try to do a drawing...

    so basically you have a box
    inside the box you have a line going from left to right
    you have mutiple lines and they can overlap each other so it would look like "insert --> line --> and under 2d line"

    that's basically it

    so just how do you make a line graph that has mutiple lines

    hope that helps

  4. #4
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    it's like http://www.telerik.com/help/aspnet-a...le-example.png -- only it has a lot of lines

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    How is what you're looking for different from a multi-line graph as created here:

    Clip.jpg

  6. #6
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    it's the same, just how do you do it without this method -- "insert --> line --> and under 2d line"

    how do you do it manually (inputting data into those "series" boxes)?

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    I think you're asking for the legend to be on the bottom?

    Clip2.jpg

  8. #8
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    im asking how to create the chart in the first place

    the data is not in the clean format you have

    when you right click on an empty chart, you have to put in data "select data"

    i don't know how to use this.

    it's very confusing, and i couldn't find any guides, they were all about the easy way --> insert, etc.

    i just need to know conceptually what to put where and i can do it

    also there are many ways to do that line graph thing, and i needed to know what would be the most flexible way

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Creating a chart by its very nature implies that you have data that should populate the chart.

    When you right click and use "select data" you can see that the dialog box is expecting you to select the range of data to be charted.

    You should first build the data in the spreadsheet, select it, and insert a chart of your choice.

    Maybe this will help:

    http://office.microsoft.com/en-us/ex...001233728.aspx

  10. #10
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    none is about "select data" -- the first part is just about the easy way and the rest is just about presentation. it completely skipped the "select data" part

    the only thing related to "select data" is how to select, but it doesn't tell you what or where

    any better guides?

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Are you relatively new to Excel?

    You need to enter the data to be charted, cell-by-cell, in the cells similar to what my last posted pic was.
    Then, drag over those cells (select them) and click on insert, whatever chart you want, and Excel will use that data selection to chart the information.

    If I'm not understanding what you're saying, please try to clarify.

  12. #12
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    yes im new, in that i haven't done these kind of things

    though misunderstanding is pretty high. i clearly said that i did not want to do it the easy way -- "click on insert, whatever chart you want, and Excel will use that data selection to chart the information" -- for the reasons already mentioned

    here are the specifics so you can see what im stuck on:
    after right-clicking on an empty line chart,
    *what am i suppose to put in "chart data range" at the top of the popup?
    *when adding a "series" why does "series Y values" have ={1}? this is so confusing. am i suppose to replace the whole thing, or just replace the {1}, or not just add *whatever after this? very confusing. need a guide.
    *how do i "edit" the "horizontal axis labels"?? it's blanked out

    i really just need a guide or good links in how to create a chart (manually, which means not the easy way)
    Last edited by computerbabyproblems; 2013-08-05 at 22:51.

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In chart data range you enter the range of where the data is located. This is the location of the cells containing your x and y data. If you do this the series will be filled in automatically. If you select the data first (before creating the chart) it will fill in automatically as well.

    If you are going to manually fill in a series, just leave chart data range blank, and click on Edit. The series name is the name/description of the series
    Weeek15
    . The series value is an array of values (the Y values). Either enter a range (you can actually enter equal and then select the range) or enter an array of values in squiggly brackets like:
    ={0.15,0.23,#N/A,0.71,0.93,0.43,0.23}

    You can add a new series
    series name:
    ="Week 16"
    Series value:
    ={0.35,0.42,0.18,0.39,0.64,0.1,0.06}

    You would then enter the Horizontal category x axis and enter the array:
    ={"Monday","Tuesday","Wednesday","Thursday","Frida y","Saturday","Sunday"}

    I do not recommend the manual method. I would enter the values Monday through Sunday in the cells A2 through A8, then enter "Week 15" in B1 and enter the respective values (0.15, 0.23 ,=na(), 0.71, 0.93, 0.43, and 0.23 into the cells B2 through B8 and enter "Week 16" into C1 and in C2 through C8 enter: 0.35,0.42,0.18,0.39,0.64,0.1, and 0.06 respectively. The format B2:C8 as percentage. Then select A1:C8, press the insert chart, select the first line chart and the chart will be created automatically.

    Steve

  14. #14
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    i finally figured out how to put in the data to get the multiple lines.....

    btw, the post was really really confusing. the post wasn't very descriptive "range" and i don't know what 'location' means

    if range means A1:A100, then that makes a lot more sense to someone new

    i also don't understand what 'array' means and all of this could've been explained much user-friendly

  15. #15
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am sorry you found the post confusing. Range and Location and Array, are all normal english words. I could not say something like the range A1:A100 since I had no idea what range of cells your data was in, you did not provide an example workbook to describe in detail, so I had to be general.

    I am not sure how more "user-friendly" the post could have been. Did you try walking through the post step-by-step with the workbook adding what it said to do? I indicated in the post, that I would not recommend the manual method: the automatic method is so much easier. Again, it it tough to walk you through the steps when we do not know how your spreadsheet is setup.

    If you want to find videos of steps, instead of the descriptions you would get here, I would recommend googling. You may also want to take a beginning excel class or purchase a beginners guide to excel.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •