How To Create Variance Bar Charts

Emma Chieppor
19 steps
33 seconds

1

Click here

Action screenshot

2

Type =IF(E5<0,REPT("|",ABS(E5)),"")

3

Press enter and select the cell

Action screenshot

4

Double-click here to fill the formula down the column

Action screenshot

5

Click 'Align Right'

Action screenshot

6

Update font to 'Stencil'

Action screenshot

7

Click here

Action screenshot

8

Select Red

Action screenshot

9

Select the formula

Action screenshot

10

Press [[Ctrl]] + [[C]]

Action screenshot

11

Double-click here

Action screenshot

12

Press [[Ctrl]] + [[V]]

Action screenshot

13

Replace the '<' with '>' in the formula

Action screenshot

14

Press [[Return]]

Action screenshot

15

Click here

Action screenshot

16

Double-click here to fill the formula down the column

Action screenshot

17

Update the font to 'Stencil'

Action screenshot

18

Click here

Action screenshot

19

Select green

Action screenshot