Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
deirdrem
 
Posts: n/a
Default How can I visually display slope in an excel chart?

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.

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Matt Lunn
 
Posts: n/a
Default How can I visually display slope in an excel chart?



"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
  #3   Report Post  
Posted to microsoft.public.excel.newusers
deirdrem
 
Posts: n/a
Default How can I visually display slope in an excel chart?

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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme
 
Posts: n/a
Default How can I visually display slope in an excel chart?

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" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Excel Chart not to display empty cells? Marko Pinteric Charts and Charting in Excel 6 April 5th 06 09:03 PM
How to make Excel Chart not to display empty cells? Marko Pinteric Excel Discussion (Misc queries) 6 April 5th 06 09:03 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
How do you display Greek and Russian languages in excel? Mark Hayden Excel Discussion (Misc queries) 1 August 1st 05 08:06 AM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"