Column Ups & Downs!

How to configure the column chart to show negative and positive values

Step By Step Guide: How to configure the column chart to show negative and positive values

How to configure the column chart to show negative and positive values

Changing from a normal column chart to a

1 Changing from a normal column chart to a "Change", allowing negative values to be depicted.
Details/Configuration/Preview Settings/Preview Mode and using the dropdown to change from 'Normal' to 'Change'.

'Can Show Image' - below 'Column Label Image Settings'

2 As you can see the baseline is now raised and the columns are both above and below the baseline. Now the images are kind of clipping through the floor. As we are not going to use images for this example, (make false) untick: 'Can Show Image' (below 'Column Label Image Settings'). Remember to also change the 'Image Backdrop Shape' from 'Box' to 'None'.

JSON - with

3 The video reverts back to a normal chart and shows how some normal (all positive) percentage values are shown. The video then steps through some changes to the data vales, and changes the "ValueFormat" to "FigureChange", it also adds a new line to set the "BaselinePosition" to "Middle".
Because we are sending "Middle" via the JSON we can leave the chart as a normal one.