Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Chart!

Oct 18, 2005 6:54AM PDT

Ok im taking chemistry in school and i am trying to
buid a graph rather than a chart i would say.

i cant get it to work. i am using excel 2000 all i want is to say A is on the X axis and B is on the Y axis and A2 = B2 on a line graph. one line!

If there is any simple way to do this i would love the help

Discussion is locked

- Collapse -
Re: Excel graph
Oct 18, 2005 6:17PM PDT

Bportpat,

It's all wizard driven. All you've got to do:
Make a table with an x(A?) and y(B?) column, like

x y
2 2.0
3 3.95
4 6.03
5 8.02
6 9.97

select this table, choose insert graph and fill in the right things, to get the straight line (approximately: y=2x-2. It takes some experiments and possibly much right-clicking to get the finer details (like legends) right. The first time is definitely the most difficult, and personally I tend to forget the details if the last time is more than a few days ago.

When I did my chemistry, there was no Excel yet, but something called (in Dutch) 'millimeter paper'. Nice brown horizontal and vertical lines, 1 millimeter apart, and with a pencil, an eraser and a ruler we made the nicest straight lines you can imagine.

Good luck,


Kees

- Collapse -
Ahh, but
Oct 19, 2005 1:16AM PDT

Kees, how about graphs of a system involving both first and third order reactions (my disertation back in the fifties). A straitedge was of little use there, but the eraser sure was handy.

Frank

- Collapse -
Slide rule?
Oct 19, 2005 1:44AM PDT

Milimeter spaced graph paper, and a Slide Rule!

Remember Slide Rules? Blimey, the Americans went to the moon using slide rules. Scary, very scary!

Mark

- Collapse -
I don't think you used a spreadsheet back then.
Oct 19, 2005 5:07AM PDT

But I agree, my impression that it was a linear relation here is totally unjustified. But it would help Excel, I think, to draw a nice straight line.

Kees

- Collapse -
A whole set of French curves
Oct 19, 2005 5:54AM PDT

spline curves, etc. And yes, Mark, a 10-inch K&E log log duplex decitrig slipstick. Those were the days?

Frank