Formative Assessment 2 US 116943

Enter the data below in the cells indicated to create a line graph

Cell – Data

A1 – Average Precipitation (mm)

A3 – January

A4 – April

A5 – July

A6 – October

B2 – Acapulco

B3 – 10

B4 – 5

B5 – 208

B6 – 145

C2 – Amsterdam

C3 – 69

C4 – 53

C5 – 76

C6 – 74

• select data and select chart type, then make your data into a  graph
• Choose Style 4 of the Chart Styles
• Add the title “Average Precipitation (mm)” above the chart
• Change the font colour to Dark Red
• Change the font colour of the graph legend to Dark Red
• Change the font colour of the axis labels to Dark Red
• Change the colour of the graph legend as follows: Choose Red, Accent 2, Lighter 80 % from the Theme Colours section of the menu.
• Colour the plot area background
• Bevel the graph edge as follows: click on the Shape Fill option to open the drop down menu. Choose Bevel, Cross from the menu.
• save the graph as linegraph followed by your name

Upload the document