Results 1 to 4 of 4

Thread: Help with Excel

  1. #1
    Joe (Moderator) joecar's Avatar
    Join Date
    Apr 2003
    Posts
    28,403

    Default Help with Excel

    In Excel, if I have a single cell containing the value 350, say, and I want to plot this value as a horizontal line on a chart (irrespective of the x-axis values), how do I do this without creating a column or row of 350's...?

    i.e. I want to plot y=350 on a x-y chart.

    Thanks (aaarrrggghhh....),
    Joe

  2. #2
    Senior Member
    Join Date
    Oct 2005
    Posts
    158

    Default

    Good question, but I've never found a way to do it.

  3. #3
    EFILive Developer Site Admin Blacky's Avatar
    Join Date
    Mar 2003
    Posts
    9,490

    Default

    You can do it using "trendlines" but you need two data points, not one.
    See images for "how to". (Images are in reverse order - sorry).

    After seleting "Add trendline" from the menu, just click [Ok], no other settings need to be modified.
    The relative values of the two data points in "Y" determine the slope of the trendline.

    Paul
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	tl1.png 
Views:	274 
Size:	7.3 KB 
ID:	277   Click image for larger version. 

Name:	tl2.png 
Views:	278 
Size:	9.4 KB 
ID:	278   Click image for larger version. 

Name:	tl3.png 
Views:	258 
Size:	7.4 KB 
ID:	279  
    Before asking for help, please read this.

  4. #4
    Joe (Moderator) joecar's Avatar
    Join Date
    Apr 2003
    Posts
    28,403

    Default

    Paul,

    Hmmm... trendlines, from 2 y points... I'll give that a try.

    Thanks,
    Joe

Similar Threads

  1. Correct Fuel injector Excel calculator for EFIlive
    By 98 tigershark in forum Gen III V8 Specific
    Replies: 4
    Last Post: July 6th, 2009, 12:28 PM
  2. correct Fuel injector settings Excel calculator
    By 98 tigershark in forum Gen IV V8 Specific
    Replies: 0
    Last Post: July 5th, 2009, 06:12 PM
  3. Excel DTC File from Husker Diesel....
    By husker_diesel in forum General (Diesel)
    Replies: 4
    Last Post: June 16th, 2009, 02:31 AM
  4. Excel Pivit Tables!!!
    By Gelf VXR in forum Lounge
    Replies: 4
    Last Post: July 14th, 2008, 10:00 PM
  5. Another Excel Worksheet
    By SSpdDmon in forum General (Petrol, Gas, Ethanol)
    Replies: 1
    Last Post: August 16th, 2005, 02:38 AM

Posting Permissions

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