Class Five: Calculations

Question 1

How to use reference lines?

Answer 1

1. build out regular chart
2. click on the axis and say add reference line?
3. drop the average into the detail area in the chart
4. you can add it in as a reference line now!

Question 2

to clean

Answer 2

1. keep no decimal places
2. colour oNLY IF IT ADDS VALUE
3. drop grid lines if you are labelling the values (they are not needed)
4. change the title
5. Declutter
   Remove gridlines
   Adding labels
   Use appropriate colour
   Use appropriate shape

Question 3

how to combiine line charts?

Answer 3

move the pill to the axis

Question 4

how to make things dual axis

Answer 4

drag the pill to the right axis

Question 5

how to make a combined line and bar chart

Answer 5

make the lines into a bar! in the left hand marks dash board