PC Review


Reply
Thread Tools Rate Thread

How can I visually display slope in an excel chart?

 
 
=?Utf-8?B?ZGVpcmRyZW0=?=
Guest
Posts: n/a
 
      30th May 2006
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 With Quote
 
 
 
 
=?Utf-8?B?TWF0dCBMdW5u?=
Guest
Posts: n/a
 
      30th May 2006


"deirdrem" wrote:

> 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 With Quote
 
=?Utf-8?B?ZGVpcmRyZW0=?=
Guest
Posts: n/a
 
      30th May 2006
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.

"Matt Lunn" wrote:

>
>
> "deirdrem" wrote:
>
> > 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 With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      30th May 2006
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"deirdrem" <(E-Mail Removed)> wrote in message
news:2D6E9EF6-34B4-4285-B610-(E-Mail Removed)...
>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.
>
> "Matt Lunn" wrote:
>
>>
>>
>> "deirdrem" wrote:
>>
>> > 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a chart showng slope? Virginia Microsoft Excel Charting 1 21st May 2008 11:24 PM
How do I show slope on a chart? Need Help on axis problem in a chart Microsoft Excel Charting 6 8th Mar 2008 03:42 PM
Slope line in stacked area chart =?Utf-8?B?ampidWQ0NA==?= Microsoft Excel Charting 3 15th May 2007 08:12 PM
Accessibility Display settings for visually impaired Vista users =?Utf-8?B?b3B0aWNhbDEw?= Windows Vista Installation 0 28th Mar 2007 01:55 AM
Can I display an Excel chart as my screensaver display? =?Utf-8?B?QnVya2U=?= Microsoft Excel Charting 0 1st Aug 2006 07:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:33 PM.