General Question

hug_of_war's avatar

How do I add several graph lines into one graph in excel 2007?

Asked by hug_of_war (10720points) April 26th, 2009

I have data for two sets of information, I graphed the first set, but I don’t know how to add the 2nd set of data so that there are two sets of data on the same graph. it’s required for my assignment for both sets of data to be on the same graph.

Observing members: 0 Composing members: 0

3 Answers

nikipedia's avatar

If I understand your question correctly, I would paste the second data set into a column next to your first data set, and then expand the graph to include the second column.

If Excel won’t let you do this, the spreadsheet feature in Google docs definitely will. Their graphs are super intuitive.

kfingerman's avatar

you can definitely do this in excel. You should have the data side by side or top/bottom. Then, either highlight both sets together and when you’re making the chart there will be a box to click that says “data in rows” or “data in columns.” Otherwise, you can use the chart you have. Right click it, then depending on your version you’ll have an option like “format source data” or “select data.” Then it will list the dataset you have and you click the botton that reads “add.” You get a new data “series” which you can name, and if you click in the “y-axis values” box, you can highlight the range where your data are. Hope that helps

prasad's avatar

You can make two or more different series in charts.
You can make use of stacked graphs.
There are also secondary axes if you want to use.
It depends on what you’re trying to achieve.

Answer this question




to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
Knowledge Networking @ Fluther