Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello all,
I am having some trouble with a homework assignment - I am trying to make a graph that has two intersecting lines - the line which I have successfully plotted, as well as a straight horizontal line with the equation Y=0.12 If this is possible, could someone please clue me in as to how I might be able to get it done? The spreadsheet with ONE of the two lines is available he http://qlink.queensu.ca/~3mf8/6.xls Thanks, Scott |
#2
![]() |
|||
|
|||
![]()
Try this
http://www.peltiertech.com/Excel/Cha...s.html#AddLine wrote in message ups.com... Hello all, I am having some trouble with a homework assignment - I am trying to make a graph that has two intersecting lines - the line which I have successfully plotted, as well as a straight horizontal line with the equation Y=0.12 If this is possible, could someone please clue me in as to how I might be able to get it done? The spreadsheet with ONE of the two lines is available he http://qlink.queensu.ca/~3mf8/6.xls Thanks, Scott |
#3
![]() |
|||
|
|||
![]()
You show data in columns A and B. Add a third data series in column C.
Title it "Constant" (or whatever you need to enter) and enter 0.12 for all rows of data. Right-click on the chart and select "Source Data..." If it doesn't work, click off the chart and try again -- make sure you right-click between lines on the chart. Select the "Series" tab and click Add. Enter the parameters for column C of data, and the line will plot. Hope this helps. Nate " wrote: Hello all, I am having some trouble with a homework assignment - I am trying to make a graph that has two intersecting lines - the line which I have successfully plotted, as well as a straight horizontal line with the equation Y=0.12 If this is possible, could someone please clue me in as to how I might be able to get it done? The spreadsheet with ONE of the two lines is available he http://qlink.queensu.ca/~3mf8/6.xls Thanks, Scott |
#4
![]() |
|||
|
|||
![]()
Thank you both very much for your extremely quick replies, I appreciate
it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Scatter plot and line graph combination | Charts and Charting in Excel | |||
two lines of text in single row | Excel Discussion (Misc queries) | |||
Add drop lines at plot crossovers, swapping X and Y axis | Excel Discussion (Misc queries) | |||
how do i plot a saw tooth graph? | Charts and Charting in Excel |