+ Reply to Thread
Results 1 to 4 of 4

Equation with variables into a line graph

Hybrid View

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,372

    Re: Equation with variables into a line graph

    In a "divide and conquer" strategy, which parts do you need help with? Here are the steps I would expect to see:

    1) Enter equation coefficients.
    2) Enter a column of temperatures covering the desired range. Note that to accurately show the phase changes, you will need two entries for those temperatures.
    3) Enter a formula adjacent to the temperatures that computes enthalpy. I note that you are giving the equation for heat capacity Cp=(dH/dT)constantP, so you will need to take the antiderivative of your Cp function and compute a suitable "initial condition" so that H=0 at your desired reference condition.
    4) Copy that formula (or formulas) down the enthalpy column.
    5) Select T and H columns -> Insert Chart -> Scatter chart -> desired subtype (lines without markers??). Pay attention here so that you don't get a line chart. Make sure you get a scatter chart.
    5a) If Excel gets the data series wrong (as it often does for me), then go into the Select Data dialog and fix Excel's mistakes.
    6) Format chart as desired.

    With the process broken down like that, where do you get stuck?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Registered User
    Join Date
    09-12-2017
    Location
    Connecticut, USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Equation with variables into a line graph

    I'm stuck basically everywhere. I am not sure how to input the equation into the graph without having data points. I am not sure how to tell the first equation for solid to stop at the inputted melting temperature. Or how to tell the second equation for liquid to start at the inputted melting temperature after a inputted heat of fusion. Nor do I know how to tell the graph to start at 298K and end at 200 above the inputted melting temperature. I am very basic at excel as of now so every detail would be greatly appreciated. It seems as if these homeworks are just going to add on to one another so nailing down the basics and knowing every detail would help me alot.

+ 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. Updating existing 4 line graph is giving single line graph
    By carrach in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2016, 07:53 AM
  2. Solving equation - using different variables
    By beauwandrey93 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-16-2015, 03:40 PM
  3. Export Graph Trend Line Equation
    By danklebs in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-22-2014, 12:30 PM
  4. Solving an equation with eight variables
    By grauniadangel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 12:17 PM
  5. Replies: 3
    Last Post: 06-10-2012, 11:02 AM
  6. graph an equation with 2 independent variables
    By jcavigli in forum Excel General
    Replies: 0
    Last Post: 06-30-2009, 02:48 PM
  7. [SOLVED] Excel should display linear equation of line drawn on graph.
    By landen99 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-01-2005, 10:05 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