How to show a column with the value Zero in Column chart in Highcharts?

Question

Which I am passing to:

       series: [{
                        name: 'Fixed bugs',
                        data: fixed,
                        pointWidth: 40
                    }, {
                        name: 'Assigned Bugs',
                        data:assigned,
                        pointWidth: 40
                    }, {
                        name: 'Re-Opened Bugs',
                        data: Reopened,
                        pointWidth: 40
                    },
                    {
                        name: 'Closed Bugs',
                        data: closed,
                        pointWidth: 40
                    }]

to this chart and I have the data like this :

     data: fixed=[3,5,5,8]
    data:assigned=[0,1,0,0]

and follows. Now I want to show the column with zero value to... For me its not showing the column value with zero.

If it is zero then there should be no height to the column. If the value is zero - do you just want to show that it is zero? Kind of confused as to what you want it to look like. — wergeld, Aug 31 '12 at 13:35

score 41 · Answer 1 · edited Dec 11 '13 at 11:37

41

minPointLength will work. Use this.

plotOptions: {
    column: {
    minPointLength: 3
    }
}

edited Dec 11 '13 at 11:37

kleopatra

51,061
28
99
211

answered Dec 11 '13 at 11:32

Thilaga

1,591
1
13
13

desired login · Answer 2 · 2014-09-17T04:24:41.610

13

You can do this quite simply with the minPointLength option. It sets the minimum number of pixels per column, default is 0, so zero values don't show up. It's in the docs here.

Try this JSFiddle

edited Sep 17 '14 at 04:24

answered Aug 06 '13 at 05:53

desired login

1,138
8
15

score 0 · Answer 3 · answered Aug 31 '12 at 08:04

0

Not sure what you are trying to display, but maybe you could try to show the datalabels like this:

plotOptions: {
    series: {
        dataLabels: {
            enabled: true,
            color: 'gray'
        }
    }
}

Attempt at demo

answered Aug 31 '12 at 08:04

OyvindK

100
1
1
7

@Qyvindk i want to display the zero column if the column has the value zero – SoftwareNerd Aug 31 '12 at 08:29
I'm no expert in graph theory, but wouldn't that imply that the column has a value greater or less than zero? Maybe you could draw a sketch showing how you want the chart to look? – OyvindK Aug 31 '12 at 09:36

score 0 · Accepted Answer · answered Sep 04 '12 at 12:44

0

Here is a way to do it - although I think just having the column be zero-valued and not visible is the best way.

Find a very very low number that none of your data points would ever have but still keep it >0. Let us say it is .005. When you bring in your data any value that is 0 assign it this .005 value. In your tooltip formatter do an IF on the value. If it is .005 then make it 0. This way you get to see the "zero" column but the tooltip displayed will be 0 as well. If you are doing any kind of calculation on the stacked columns then you need to account for this non-0 0 value in there as well.

answered Sep 04 '12 at 12:44

wergeld

14,332
8
51
81

a nice explanation and a nice answer...i will try this ty – SoftwareNerd Sep 04 '12 at 14:00
1

This should not be the accepted answer. It should be **desired login**'s or **Thilaga**'s answer. Please just use `minPointLength` – Jeffrey Roosendaal Jul 28 '15 at 08:12

How to show a column with the value Zero in Column chart in Highcharts?

4 Answers4