Summary Tables
Add support for adding simple data tables inside or outside of a chart. This would be similar to a legend, but contains custom data sets. Currently we use the Highcharts Renderer to render a background rectangle based on the matching chart options and draw the table the same way the legend is drawn outside of the table. It would be nice if there was the option for that datatable to exist under the chart/overlayed on the chart or completely separate from the chart.
christine
shared this idea
2019-03-04
Added a study for integration with Handsontable, a third party grid component: https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/studies/summary-table-handsontable/
2017-09-11
The data table is now a feature of the data-export module. See http://jsfiddle.net/highcharts/VEs7z/3/. Notice how it updates as the chart is updated (for example by showing/hiding series).
2014
Here’s a proof of concept of how you can draw a table programmatically: http://jsfiddle.net/highcharts/VEs7z/
-
I added a study for integration with Handsontable, see https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/studies/summary-table-handsontable/. It can also be extended to other third party grid components. It gives you sorting and formatting etc from the third party libraries.
-
Gary Troop
commented
I agree with others. We need a data table that is nicely formatted and aligned with the chart periods. The current workaround does not meet our needs. It needs to work like MS Excel.
-
Yes, like this: http://jsfiddle.net/highcharts/VEs7z/3/. Or did you have something else in mind?
-
Anonymous
commented
Hi Torstein,
If we are looking just to create table, is this a possibility?Regards
Kumail -
Anonymous
commented
I think the workarounds above are not satisfying the ticket, for one the export images don't include the table.
I think it should be a fundamental feature to incorporate a summary table with:
* Total/average per series
* Options for showing min/max/average and other statistics
* All columns sortable -
@Anonymous
To hide the chart itself you could always use display: none: http://jsfiddle.net/highcharts/VEs7z/4/ -
Anonymous
commented
Hi Torstein ,
Is it possible to show only table . dont want to show graph. -
Alex
commented
I agree with Igor. Definitely needed.
-
Igor Isupov
commented
this request is 4 yrs old!!
We bought commercial version of Highcharts adn it was such an awful surprise i can't add data values in legend as i always did in Excel! ((((
PLEASE!!! ADD THIS FEATURE!!! -
Yurij
commented
We're using commercial version of highcharts and are waiting this feature very much. Excel has this awesome functionality to have data tables integrated with the chart (not simply below it line in the example on jsfiddle).
http://www.dummies.com/how-to/content/how-to-add-data-tables-to-charts-in-excel-2013.html
Please consider implementing it, thank you.
-
Anonymous
commented
We use highcharts to show data the nice way, but some clients still want to get data in some sort of table. In this case I have to write a completely different view. This is when a table type chart (with all its tooltips and etc) would come in really handy.
-
Anonymous
commented
+1
-
Anonymous
commented
awesome idea... this feature is very very important...
-
Christopher
commented
It's nice to know someone's accomplished this, even if in a roundabout way.
It'd be great if it were an actual feature. A single bar on a small chart with a relatively much larger value within a series can prevent other bars from displaying, which in turn stops you from being able to view their tool-tips, which prevents you from knowing what data was supposed to be displayed in those bars (and giving a quick graphical overview of data is pointless when you can't distinguish between most of the data points on the graph due to an 'outlier').