Excel question

[Devanshu]

Alright...I'm working on a lab and things arent going the way I want them to.



Normally it just lays the x values down where they should be but for some reason it automatically put it on top. Any way to get em back down?

Also, I need to display the equation on the chart. I go to chart -> add trendline -> options -> display equation on chart. Is there any way to have just the equation on the chart w/out the trendline?

[Capmaster]

You need to have the graph highlighted and click on it. Then you need to format it and move the x axis labeling to the bottom. There's also a way you can add text and place anywhere on the chart while it's highlighted. Just try clicking and typing and see if it adds a text box.

BTW, that chart makes no sense. It shows the wavelength increasing when the frequency increases. The opposite is true. Also, "m" is no unit of frequency I'm aware of

[Hardcoreruss]

www.mrexcel.com/board2

Very clued up people

[Devanshu]

BTW, that chart makes no sense. It shows the wavelength increasing when the frequency increases. The opposite is true. Also, "m" is no unit of frequency I'm aware of

Look closer...it's not wavelength but instead log wavelength. As for m, That's my fault which I caught later. It's supposed to be 1/s.

Anyway, the data is not mine. It was given to me for an exercise to relate different relationships and see what makes the best linear graph.

[Capmaster]

Look closer...it's not wavelength but instead log wavelength

That'll teach me to skim :P