ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How can I visually display slope in an excel chart? (https://www.excelbanter.com/new-users-excel/91151-how-can-i-visually-display-slope-excel-chart.html)

deirdrem

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.


Matt Lunn

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

deirdrem

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


Bernard Liengme

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





All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com