How can I visually display slope in an excel chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deirdrem - 30 May 2006 00:48 GMT

Hi I'm new to excel charts and can't figure out how to display slope visually
rather than by default scaling of y-axis.

Reply to this Message

Matt Lunn - 30 May 2006 10:25 GMT

> Hi I'm new to excel charts and can't figure out how to display slope visually
> rather than by default scaling of y-axis.

Hi,

Not sure what you mean. Could you supply some more detail?

Thanks

Reply to this Message

deirdrem - 30 May 2006 14:36 GMT

I want to have two graphs; one where x=y i.e. a 45 degree angle, slope is 1,
this is no problem but then I want the second to have, say, 3x=2y, i.e. a 60
degree angle, slope 3/2. But excel(or my abuse of it) keeps returning me 45
degree angles with the axes scaled to fit it.

> > Hi I'm new to excel charts and can't figure out how to display slope visually
> > rather than by default scaling of y-axis.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Bernard Liengme - 30 May 2006 17:11 GMT

Right click each axis in turn, open the Format Axis menu, go to the Scale
tab and set the Min and Max values to the same numbers.
Drag the chart corner to make an approximately square plot area
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I want to have two graphs; one where x=y i.e. a 45 degree angle, slope is
>1,
[quoted text clipped - 13 lines]
>>
>> Thanks

Reply to this Message