Simple Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excelnewbo - 24 Jan 2006 21:14 GMT

I'm not really a newb to excell but i just cannot get this graph to come
out right. It may seem ridiculously easy to you guys but i cannot figure
it out. This needs to be two lines on the same graph.

Force of Friction goes on the y axis
Mass goes on the x axis

Sliding friction: Mass:
.0004 .048
.00036 .076
.0002 .104
.0004 .132

Rolling Friction: Mass:
-.016 .076
-.021 .104
-.025 .132

It can't put make the incrimints so small for the one part on the x
axis while making them big enough for the other line so its giving me
the sliding friction in a straight line up the y axis. Any ideas as to
how i can make it into two spereate lines that dont look completely
smashed?

Signature

Excelnewbo

Reply to this Message

vandenberg p - 24 Jan 2006 21:23 GMT

Hello:

Create the "smashed lines." Then right click on one of the lines and choose
selected oject and then Axis and then select secondary.

This will scale one on the left and the orther on the right, using two different
scales which should solve your problem.

Pieter Vandenberg

: I'm not really a newb to excell but i just cannot get this graph to come
: out right. It may seem ridiculously easy to you guys but i cannot figure
: it out. This needs to be two lines on the same graph.

: Force of Friction goes on the y axis
: Mass goes on the x axis

: Sliding friction: Mass:
: .0004 .048
: .00036 .076
: .0002 .104
: .0004 .132

: Rolling Friction: Mass:
: -.016 .076
: -.021 .104
: -.025 .132

: It can't put make the incrimints so small for the one part on the x
: axis while making them big enough for the other line so its giving me
: the sliding friction in a straight line up the y axis. Any ideas as to
: how i can make it into two spereate lines that dont look completely
: smashed?

Reply to this Message

vandenberg p - 24 Jan 2006 21:25 GMT

It should be noted that "orther" is sometime also spelled "other."

: Hello:

: Create the "smashed lines." Then right click on one of the lines and choose
: selected oject and then Axis and then select secondary.

: This will scale one on the left and the orther on the right, using two different
: scales which should solve your problem.

: Pieter Vandenberg

: : I'm not really a newb to excell but i just cannot get this graph to come
: : out right. It may seem ridiculously easy to you guys but i cannot figure
: : it out. This needs to be two lines on the same graph.

: : Force of Friction goes on the y axis
: : Mass goes on the x axis

: : Sliding friction: Mass:
: : .0004 .048
: : .00036 .076
: : .0002 .104
: : .0004 .132

: : Rolling Friction: Mass:
: : -.016 .076
: : -.021 .104
: : -.025 .132

: : It can't put make the incrimints so small for the one part on the x
: : axis while making them big enough for the other line so its giving me
: : the sliding friction in a straight line up the y axis. Any ideas as to
: : how i can make it into two spereate lines that dont look completely
: : smashed?

Reply to this Message