Any Excel Graph wizards out here?

[Cindy B]

I've got a set of data, and I'm having a hard time getting it to graph correctly.

I have to graph this:

10, 20, 40, 80, 160, 320 (this is the amount of objects)


25 50 100 200 400 800 (this is the weight of the objects)

Well, apparently Excel doesn't like my data, it keeps calling it a series of two when its not.

I want the graph to show the amount of objects to correlate with the weight (ex. 10 to go with 25, 20 to go with 50, etc...)

Thanks.

 

[oogieboogie]

Is this what you're trying to do:

 

[Cindy B]

Thanks for your help. Thats not exactly what I need. When I played around with it this morning, I got that same result.

The first set of numbers is the amount of objects.. the multiple numbers


The second set is the grams


I don't want two lines on a graph, just one. Does that make sense?

I need to measure mass on the amount of objects. (chemistry class assignment)

So basically, I want the first number 10 (amount of object) to correspond with 25 (amount of grams)

We have to measure the mass of an object vs. the number of objects.

So ideally, my 10, 20, 40, 80 numbers would be on the bottom (I think), and the grams would be on the side.

How can that be done? Excel thinks its two trials, not one.

 

[Cindy B]

Also what type of graph would be best? I was thinking either line or bar.

(I've done excel before, but nover graphing)

 

[camlace]

Like this?

I used an "XY Scatter Graph with data connected by lines" (you can also use "smooth" instead of lines between points).

Hope that helps.

camlace

PS...sorry I don't know how to fix the image so it isn't so huge

 

[oogieboogie]

OK, is this what you need then?

 

[JKanownik]

Set up your excel spreadsheet like this:
(listed as: cell location (data) )

A1(blank), B1(20), C1(40), etc.
A2("weight") B2(25), C2(50), etc.

The blank in cell A1 coupled with the text in A2 will cause Excel to automatically use row 1 as the labels on the X axis. All you have to do is select a line graph and just let the chart wizard do the rest.

-Josh

 

[Cindy B]

Wow, thank you! You all are so amazing!