Anyone good with microsoft excel?

[kevin]

I hated to ask this here but ive been frustrated for several hours now trying to create some charts, i googled, and searched the help in excel but had no luck.

Not getting this done keeps me from playing with guns and surfing the forums.

I am trying to graph pebble size vs longitude with the following data:
length of pebble, width of pebble, and meters north of the equator, 3 variables

I graphed the width and length with an x y scatter plot but cannot get the longitude part factored in. This is as far as i got. I tried all types of charts and the data analysis etc

Any help Greatly apreciated!!!!!

[LostInTexas]

Kevin,

How 'bout doing a rough volume calculation since you have the length and width size then plot volume vs. long. ?

-LIT

[kevin]

i thought about that but some of the pebbles are very flat and long, others are nearly perfect round, and other random size/shape

i have another option of plotting all the points and somehow grouping them (ive seen others graphs that automatically circles the points from one location, but they were measured in 1mm increments,and some points overlap

i measured pebbles at 6 locations some pebbles were the same size because i counted 60 pebbles at each place, it makes it hard to see on the graph, if i could somehow draw circles around the groups that would help see things
they are 6 different colors so i can see the trends

[rustypirate]

from what I can see, excel does not do xyz graphs by default, but there are downloadable tools that will allow you to create xyz scatter graphs from excel data.

http://www.andypope.info/charts/3drotate.htm

[tanstaafl4y]

If you are not restricted to Excel try MS Powerpoint. XYZ Graphs should work right out of the box and you can import you Excel spreadsheet.

[kevin]

i think i am just going to try and simplify things, i allready found the average measurements at each site, took this and calculated cross sectional area, and now i will just graph cross sectional area vs longitude,

[iocane]

i thought about that but some of the pebbles are very flat and long, others are nearly perfect round, and other random size/shape

i have another option of plotting all the points and somehow grouping them (ive seen others graphs that automatically circles the points from one location, but they were measured in 1mm increments,and some points overlap

i measured pebbles at 6 locations some pebbles were the same size because i counted 60 pebbles at each place, it makes it hard to see on the graph, if i could somehow draw circles around the groups that would help see things
they are 6 different colors so i can see the trends
Well my suggestion is probably too late anyway. Maybe you could make averages of the data before you enter it in. Graphs with lots of data points can be confusing. Also the 3-dimensional chart sub types can be handy for lots of variables. Of course you could have tried that already. Good luck.

[RandyCOG3]

I hated to ask this here but ive been frustrated for several hours now trying to create some charts, i googled, and searched the help in excel but had no luck.

Not getting this done keeps me from playing with guns and surfing the forums.

I am trying to graph pebble size vs longitude with the following data:
length of pebble, width of pebble, and meters north of the equator, 3 variables

I graphed the width and length with an x y scatter plot but cannot get the longitude part factored in. This is as far as i got. I tried all types of charts and the data analysis etc

Any help Greatly apreciated!!!!!

Damn.
Now I'm gonna lay in bed, wide awake, all night.
I never knew there was so much to worry about with pebbles.
How do you determine the orientation of the pebble? I mean, once you pick it up to measure it, do you keep track of its orientation, so you don't confuse length vs. width?
What if they are SAE pebbles, and not Metric?
Is the data set meaningful w/o considering pebbles from the Southern Hemisphere, or do you give SH pebbles a negative value to reflect that they are a minus-x meters from the equator?

Are you going to share your pebble technology and findings with us when you are done??

Remember, everyone, when you stop caring about the pebbles, the terrorists have won.

j/k

RandyCOG3