Graphing with Excel

How to use Excel to make a line graph, an xy graph, a bar graph or a pie chart.
About my voice - I know it sounds weird. It's a microphone issue - everyone who knows me says it sounds nasally and not like me. If I put the mic farther away my voice sounds fine but then it is echoey. Some day I'll get something better than this $20 headset mic.

Category:

Education

Tags:

• learn
• tutorial
• excel
• chart
• wizard
• graphs
• graphing
• xy

[rslmartin27]

Still confused on how to assign the X & Y I am using 2007 new version. You jumped right over the assigning year to adding in you formula. One step at a time please.

[gr575]

@rslmartin27, I go fast because you have ability to pause. Select multiple columns before you click graph button and the left most column will always be X and the remaining columns will be separate series Y values. A series is a "line" or a group of points all the same color.

[msquestion22]

Great video,helped me alot. But still got a burning question. Ive got a graph containing all the weeks and weight. But i've got different persons in it. So from one person I have week 1,4,5 and 7. But for the other person i have week 3,8,9. The x-axis goes from 1 till 10. But when I only fill in the weeks that ive got info about, the graph does not make a line between these points! It only makes little symbols/markers on the right week. But can I get that line also in there?

[gr575]

@msquestion22

Sort the data by person (then week) and it will work:

week,john_weight,ingrid_weight

1,50

3,49

4,49

2,,39

6,,35

7,,34

(make sure you do scatter graph!)

[thekillerb309]

my y axis come out as percentage and i want numbers what do i do?

[gr575]

It graphs whatever you told it to. You must have picked a percentage column in your spreadsheet. Instead I recommend creating two new columns side by side with the first column being what you want for the x axis and the second column being for the y axis (not percentage!). Then select those 2 columns and do "scatter" graph.

[cessna65423]

More Left Wing, Global Warming propaganda.

[Gerftern600]

When I click chart, pie chart, then data range, and the pie is blank.

[blastissimo218]

Thank you very much for this tutorial.

[IllyMooncat]

Bwahhh thank you. How is it in my computer-genius family no one know how to graph in Excel? My Climatology project is turning into quite the Saga. This was very helpful :)

[21centuryg]

Thank god for this video!

[adlozi]

I love YouTube.

[The13thDruid]

you just saved my ass, never procrastinating again

[gengyu666666]

thank you very much

[Lorac134]

tnx!

[beunhaas102]

Thanks!

This vid really helped me out with a report I had to do for school.