How can I visually display slope in an excel chart?

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.
 
G

Guest

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
 
G

Guest

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the slope of line graph with the use of spinbutton in Excel VBA 1
Excel What does E mean in excel numbers? 1
charts 1
Excel How to code in excel vba 2007 using absolute refernce for cells 1
Anomolous behaviour of slope function. 2
multiple y axis in xy chart 3
How do I eliminate empty cells from plotting on chart 1
Regression gives slope of zero when x values smaller than 10^-7 2

Top