Highcharts: Plot yAxis values starting from a specific range

Question

I am using highstocks and I am wondering if there is anyway I can plot the y values in a column series starting from an arbitrary number. For example. I have a column series called NU (New Users) with its first entry yAxis value of 1,000. Currently, that first entry is plotted on the yAxis from range [0, 1,000]. But instead I would like it to be plotted from [5,000, 6,000].

The reason I want this is because NU is essentially apart of another column called DAU (Daily Active Users), and I want it to be shown up as so. The first entry of the DAU column series has a Y value of 6,000, and 6,000 - 1,000 is 5,000; therefore I would like this entry of NU to start at 5,000.

Here is what I have so far

http://jsfiddle.net/6JACr/2/

I was going to plot DAU as (Original DAU - NU), and stack NU on top of DAU, but that would mean the series holds an incorrect value for DAU.

Here is my code

    $(document).ready(function() {

    var all_series = [];
    var accu_series;
    var accu_data = [];
    var pccu_series = [];
    var pccu_data = [];
    var dau_series;
    var dau_data = [];
    var nu_series;
    var nu_data = [];


    function draw_charts() {

        $('#container').highcharts('StockChart', {

            rangeSelector : {
                selected : 1,
                buttons: [{
                    type: 'week',
                    count: 1,
                    text: '1w'
                }, {
                    type: 'month',
                    count: 1,
                    text: '1m'
                }, {
                    type: 'month',
                    count: 3,
                    text: '3m'
                }, {
                    type: 'month',
                    count: 6,
                    text: '6m'
                }, {
                    type: 'ytd',
                    text: 'YTD'
                }, {
                    type: 'year',
                    count: 1,
                    text: '1y'
                }, {
                    type: 'all',
                    text: 'All'
                }]
            },

            plotOptions: {
                column: {
                    grouping: false
                }
            },

            yAxis: [{
            // Primary Y-Axis
                labels:{
                    align:'right',
                    x:-10
                },
                lineWidth : 1,
                offset : 0
            }, {
            // Secondary Y-Axis
            opposite: true
            }],

            series : all_series

        });
    }

    //Function that takes a record and fills the series data with that record
    function fill_data(index, record) {
        var date = new Date(record['dailyDate']);
        var utc_date = Date.UTC(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate());
        accu_data[index] = [utc_date, parseFloat(record['accu'])];
        dau_data[index] = [utc_date, parseFloat(record['dau'])];
        nu_data[index] = [utc_date, parseFloat(record['users'])];
    }

    // //Function that sets up the series data for plotting
    function fill_series() {
        dau_series = {
                name: "DAU",
                type: "column",
                data: dau_data,
                stack: 0
        };
        all_series[0] = dau_series;
        nu_series = {
                name: "NU",
                type: "column",
                data: nu_data,
                stack: 0
        };
        all_series[1] = nu_series;
    }

    //Pull data from API, format it, and store into the series arrays
    (function() {
        var result = '[{"accounts":"1668","accu":"568","activePayingRate":"1.97757","activePayingUsers":"854","activeUsers":"4905","area":"1","arpu":"34.6908","company":"45","dailyDate":"2013-08-06","dau":"6000","lost":"87","newUser":"0","paying":"96","payingRate":"1.53724","pccu":"747.0","registration":"572","sales":"3305.01","server":"1","users":"1000"},{"accounts":"1554","accu":"497","activePayingRate":"2.18398","activePayingUsers":"833","activeUsers":"4533","area":"1","arpu":"34.7479","company":"45","dailyDate":"2013-08-07","dau":"5873","lost":"89","newUser":"0","paying":"96","payingRate":"1.68568","pccu":"759.0","registration":"483","sales":"3300.04","server":"1","users":"1209"}]';
        var json_result = JSON.parse(result);
        $.each(json_result, function(index, record) {
            fill_data(index,record);
        });
        fill_series();
        draw_charts();

    })();


});

Answer 1

You can use low property for column, for example: http://jsfiddle.net/6JACr/4/

To display proper tooltip, add extra property like val and use pointFormat to display it.

Note: when dataGrouping will be used custom properties are removed, in that case I advice to create your own tooltip formatter, to display what you need.