Posts: 1
Joined: Sun Jan 02, 2011 11:25 am
Occupation: student: 6th grade

How should I graph a variable that is "0"?

Postby robertfh » Wed Jan 05, 2011 1:39 pm

We are required to use Excel to create a graph. My Project is "Sliding Light: How to Make a Dimmer Switch." On the X axis is where you label the resistor length in cm. The first length is actually 0 cm. Excel can only start with 1. So I can't plot my first pair of coordinates. How should I do this? Also, should the X axis alway start with 0 as even with the the Y axis so 0,0 is the corner of the graph, or in this case could you make it the first interval on the x axis? Thank you!

Former Expert
Posts: 265
Joined: Wed May 07, 2008 8:36 am
Occupation: Engineer - Product & Technical Development Executive Director

Re: How should I graph a variable that is "0"?

Postby edneu3 » Thu Jan 06, 2011 12:17 pm

To plot scientific data such as these you should use the "Scatter Plot" capabilities of Excel. When you use that, you can actually plot a "0" value.

Put all you "X" values in one column, and their corresponding "Y" values in the column to the right of that one. Select all the data and choose "Scatter" plot.

Good luck.
Ed Neu
Buffalo, MN

Return to “Grades 6-8: Physical Science”