INTHEBLACK August 2022 - Magazine - Page 61
02
CLICK HERE TO ACCESS
extra material, a podcast
and a video from
Neale Blackwood CPA
03
04
9. In the task pane, click the last icon (it looks
like a column chart). Under Label Options,
select Series Name and untick the Value.
10. In the task pane, click the top left dropdown (as per steps 5 and 8) and select
the Series Actuals|Forecast Error Bars –
bottom of list.
11. In the task pane, click the last icon (it
looks like a column chart) and change
Direction to Minus and the End Style to
No Cap. In the Error Amount section,
select Percentage and enter 100%.
12. Click the first icon (the paint can) and
change the Width to 1.5 pt. Change the
Dash Type to a dotted line.
13. Click on the Chart Title, click in the Formula
Bar, press = and click on cell D1 then press
Enter. This links to the Chart Title to cell D1.
As the year progresses the dotted line will
move across the chart – see Figure 05.
Error bars offer solutions to common chart
problems.
Selecting a single point on a chart can be
challenging. Using the drop-down in the task
pane to select a data series is easier.
05
intheblack.cpaaustralia.com.au August 2022 61