Highcharts Show HTML Table Data in Chart

In the previous chapters, we learned how to setup highcharts library and how to create a chart with required configurations using highcharts library in our webpage. Now, we will learn how to create a chart with HTML table data using highcharts library with examples.

Highcharts Show HTML Table Data in Chart Example

Following is the example of creating a columns chart by extracting the data from the HTML table using highcharts library.

 

<html>

<head>

    <title>Highcharts Chart with HTML Data</title>

    <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>

    <script src="https://code.highcharts.com/highcharts.js"></script>

    <script src="https://code.highcharts.com/modules/data.js"></script>

    <script src="https://code.highcharts.com/modules/exporting.js"></script>

    <script src="https://code.highcharts.com/modules/export-data.js"></script>

    <script type="text/javascript">

        $(function() {

            Highcharts.chart('container', {

                data: {

                    table: 'datatable'

                },

                chart: {

                    type: 'column'

                },

                title: {

                    text: 'Data extracted from a HTML table in the page'

                },

                yAxis: {

                    allowDecimals: false,

                    title: {

                        text: 'Units'

                    }

                },

                tooltip: {

                    formatter: function() {

                        return '<b>' + this.series.name + '</b><br/>' +

                            this.point.y + ' ' + this.point.name.toLowerCase();

                    }

                }

            });

 

        });

    </script>

</head>

<body>

    <div id="container" style="width: 100%; height: 400px;"> </div>

    <table id="datatable">

        <thead>

            <tr>

                <th></th>

                <th>Jane</th>

                <th>John</th>

            </tr>

        </thead>

        <tbody>

            <tr>

                <th>Apples</th>

                <td>3</td>

                <td>4</td>

            </tr>

            <tr>

                <th>Pears</th>

                <td>2</td>

                <td>0</td>

            </tr>

            <tr>

                <th>Plums</th>

                <td>5</td>

                <td>11</td>

            </tr>

            <tr>

                <th>Bananas</th>

                <td>1</td>

                <td>1</td>

            </tr>

            <tr>

                <th>Oranges</th>

                <td>2</td>

                <td>4</td>

            </tr>

        </tbody>

    </table>

</body>

</html>

If you observe the above example, we created a column chart by extracting the data from the HTML table using highcharts library with required properties.

 

When we execute the above highcharts example, we will get the result like as shown below.

 

Highcharts Show HTML Table Data in Chart Example Result

 

This is how we can create a columns chart by extracting the data from HTML table using highcharts library with required properties.

Topics Covered