|
Creating Graphs
within Spreadsheets
This
activity uses the spreadsheet created in this lesson. |
| Once your
spreadsheet is created it is a simple step to create a graph
using the Chart Wizard. |
|
Chart Wizard icon |
| |
 |
| Select the data
you wish to use in your graph. |
| This would be everything
except the Heading and the total pets. |
| Click on the chart Wizard
Icon |
 |
| The Chart Wizard has 4 steps |
Step 1 - Chart Type
Select form the list the type of graph you would like to
use. |
Step 2
- Chart Source Data
This step is asking you what data you want
represented on the graph |
 |
 |
|
Tip:
Use the Press and Hold
to View Sample button to help you decide what
graph to use |
You have
already selected the data. If not you can select it
here. |
 |
|
|
Press
next when ready |
Press
next when ready |
|
Step 3
- Chart Options
Use the Tabs along the top to complete each
task.
|
Title |
Axes |
Gridlines |
Legend |
Data Labels |
Data Text |
|
Step 4 - Chart Location
Select where you want you graph to appear
Place the graph
next to your spreadsheet or on a new page completely |
|
 |
 |
|
The main
task here is giving your graph a title and
naming the axes of the graph. |
If you
have space you would usually place you graph "as
object in" |
 |
|
For each
task you will see the changes occur in the preview area. |
|
Press
next when ready |
Press
Finish when ready |
|
|
The finished
graph should look something like this. |
|
 |
|
By
double clicking on different sections of the graph you
can change the colours font and alignment of the test |
Your
finished graph may now look like this |
|
 |
 |
|
|
Experiment with the
chart wizard. You can make it do almost anything you want. |
