×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Chart Help Please

Excel Chart Help Please

Excel Chart Help Please

(OP)
Hi,

This will no doubt be very simple for many, but I have no used charts for a very long time, and after a play, I cannot see how I can do wht I need.

I am trying to re-create the garph as attached in excel, but cannot see how to obtain a vertical line  and horizontal line within the same graph (for M10 for example).

Can anyone create a quick graph just for the M10, so I can see what I need to do, and complete for myself.

Also, I am out to create two lines on the graph, based on values of shear and tension, and where these intersect is what the selection will be based on.

All/any help would be appreaciated.

Thanks,

 

RE: Excel Chart Help Please

The attached file is not an excel file?

If you want to recrate it in excel (just to look "pretty") then just enter the "bend point" (dont forget the "start" and "end" point (0,Y) and (X,0) and select the scatter type where excel does not "smooth" the line. Should make a figure just like in your word doc.

Best regards

Morten

RE: Excel Chart Help Please

It's not any different that graphing a horizontal line, which repeats the same y-value for two different x-values.  A vertical line, therefore, repeats the same x-value for two different y-values.

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

RE: Excel Chart Help Please

(OP)
Thanks zelgar, exactly what I was hoppig for.

I definately need to brush up on my chart skills.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources