It is easy to create simple graphs and charts
from your data in excel. You can also create more complex graphs
and charts with a little extra effort. For a spreadsheet program,
graphing and charting is very important. In fact, data often means
very little unless it is analyzed graphically.
These graphs will help you analyze your data and values. I pre-made a
spreadsheet you can use or feel free to use your own. It's graphing time!
Highlight the Cells with the data you would like to graph. (in this case, A2 to D16) To highlight A2 to D16 (in this case) you can place your pointer
over A2, click and hold the left mouse button then drag over D16 and
release the button
Click on the chart wizard button on the toolbar.
Select the Chart Type you would like. (Choose Line)
Select the Chart sub-type. (Choose the top left sub-type)
Click Next.
All our data is correct so you can chose next. (This
is where you would change the way your data is used. ie. If your data
went from left to right instead of top to bottom, you would chose rows
instead of columns.)
Click Next.
This is where we add titles to our chart. Type in the following data:
Chart title = "Calorie Counter"
Category (X) Axis = "Day of the Week"
Value (Y) Axis = "Calories"
Click Next.
Now we select the location of the chart. Click the circle beside "as object in" then click on "Sheet1".
Click Finish.
This is just a basic example of what you can do with graphs and charts and
for most people it's all they need. Now you should be able to create
a simple graph or chart in Excel.
I encourage you to play around with the different options available in the
chart wizard. Microsoft Excel does a good job of making the chart wizard
user friendly. Go do some more graphing in Excel! Its homework!
If you had any problems completing this module or think some details need more explanation, please let us know. We also welcome any other feedback.
Send Feedback
