+ Reply to Thread
Results 1 to 3 of 3

Excel Graph - Multiple Lines on Graph

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Excel Graph - Multiple Lines on Graph

    Hi All,

    I am having trouble with something that is probably quite basic.

    I need various lines on the same graph. So one line needs to be x =y, with the others being the lines described in the attached (I have the information needed for the lines to give meaningful values).

    No idea how to plot these, and this is only the beginning. I need to then use Solver to iterate a value as well.

    Thanks.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    03-15-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel Graph - Multiple Lines on Graph

    OK, so it is the equilibrium curve that is the issue.
    Attached Images Attached Images

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Excel Graph - Multiple Lines on Graph

    You'll most likely need to use a Scatterplot.

    First column is x values: something like {1, 2, 3, 4, etc}.

    Second column is f1(x), third is f2(x), etc.
    So you will pull down
    B2 = f1(A2), C2 = f2(A2), like that.

    Then feed that table into the Scatterplot.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating line graph with multiple lines
    By elchenuk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2017, 08:44 AM
  2. Multiple lines in graph for same time frame and same data 'segment'
    By wally_j in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-04-2016, 05:22 AM
  3. Multiple Lines/Series in One Graph
    By adiyesaya in forum Excel General
    Replies: 3
    Last Post: 04-12-2012, 04:53 AM
  4. line graph help - multiple lines
    By chsl2008 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-24-2011, 06:58 AM
  5. Plotting multiple lines on a graph with different x values
    By freedom4horses in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2011, 04:27 PM
  6. Line Graph: multiple lines from multiple data sets?
    By Guerodemonio in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2011, 06:15 AM
  7. Powerpoint Graph- Shading in between two linear graph lines
    By TerenYoung in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2006, 04:35 AM

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