140 likes | 263 Views
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. Colouring a Graph - 1. Right click on a column in the graph.
E N D
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
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
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
Colouring a Graph - 3 • The selected columns now display the chosen colour. • Repeat these steps to colour each column. PRINTiT - www.impromation.com.au
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
Making a 3D Graph - 2 • Click on the 3D clustered column image. • Click on ‘OK’ PRINTiT - www.impromation.com.au
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
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
Making a 3D Graph - 5 • Click on the ‘Default’ button • Then click on ‘OK’ PRINTiT - www.impromation.com.au
Making a 3D Graph - 6 11. Your graph is now ready to copy and paste into your ASR. PRINTiT - www.impromation.com.au
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
Colouring a Table - 2 • Select a colour • Click on ‘OK’ PRINTiT - www.impromation.com.au
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
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