![]() |
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. |
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 |
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 |
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