PRINTiT www'impromation'com'au

1
Preparing Graphs and Tables for your Annual
School Report
Section 1 Colouring a Graph
Section 2 Making a 3D Graph
Section 3 Colouring a Table
PRINTiT - www.impromation.com.au
2
Colouring a Graph - 1

• Right click on a column in the graph.
• A menu will display click on Format Data
  Series

PRINTiT - www.impromation.com.au
3
Colouring a Graph - 2

• 3. A window of options will display.
• Click on a colour for your selected column.
• Then click on OK

PRINTiT - www.impromation.com.au
4
Colouring a Graph - 3

• The selected columns now display the chosen
  colour.
• Repeat these steps to colour each column.

PRINTiT - www.impromation.com.au
5
Making a 3D Graph - 1

• Right click inside the graph area (inside the red
  shaded section and not on a column)
• A menu will display click on Chart Type

x
PRINTiT - www.impromation.com.au
6
Making a 3D Graph - 2

• Click on the 3D clustered column image.
• Click on OK

PRINTiT - www.impromation.com.au
7
Making a 3D Graph - 3

• Your graph will now look something like this.
• Now we need to rotate the graph to a better
  perspective.

PRINTiT - www.impromation.com.au
8
Making a 3D Graph - 4

• Right click on a white space away from the graph.
• A menu will display click on 3-D View
  (NB you may see different options depending on
  where you have right clicked)

x
PRINTiT - www.impromation.com.au
9
Making a 3D Graph - 5

• Click on the Default button
• Then click on OK

PRINTiT - www.impromation.com.au
10
Making a 3D Graph - 6
11. Your graph is now ready to copy and paste
into your ASR.
PRINTiT - www.impromation.com.au
11
Colouring a Table - 1

• Click and drag to highlight a row in the table.
• Now, right click inside the highlighted row.
• A menu will display click on Format Cells

PRINTiT - www.impromation.com.au
12
Colouring a Table - 2

• Select a colour
• Click on OK

PRINTiT - www.impromation.com.au
13
Colouring a Table - 3
6. Follow these steps to change alternate rows
in your table.

• Follow these steps again to change the colour of
  alternate rows in your table.
• To change the font colour use the text colour
  selector in the Excel menus at the top of the
  screen.

PRINTiT - www.impromation.com.au
14
Visit the PRINTiT website
www.impromation.com.au/printit
- Instant quotes for printing your ASR
- Ten tips for a better ASR
- Helpful tips for cover layouts and photo
collages
- Upload your completed ASR online direct to our
printshop (no size limits!)
- Delivery in 7 10 days
PRINTiT - www.impromation.com.au