How can I visually display slope in an excel chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
deirdrem said:
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.
Click to expand...

Hi,

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

Thanks
 
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.
 
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
 
Back
Top