Grouped and sorted columns
A demo of amCharts 4, the previous version. See it in amCharts 5.
This is the amCharts 4 version. See this demo in amCharts 5
Open in:
Code
JavaScript
// Themes begin
am4core.useTheme(am4themes_animated);
// Themes end
var chart = am4core.create("chartdiv", am4charts.XYChart);
// some extra padding for range labels
chart.paddingBottom = 50;
chart.cursor = new am4charts.XYCursor();
chart.scrollbarX = new am4core.Scrollbar();
// will use this to store colors of the same items
var colors = {};
var categoryAxis = chart.xAxes.push(new am4charts.CategoryAxis());
categoryAxis.dataFields.category = "category";
categoryAxis.renderer.minGridDistance = 60;
categoryAxis.renderer.grid.template.location = 0;
categoryAxis.dataItems.template.text = "{realName}";
categoryAxis.adapter.add("tooltipText", function(tooltipText, target){
return categoryAxis.tooltipDataItem.dataContext.realName;
})
var valueAxis = chart.yAxes.push(new am4charts.ValueAxis());
valueAxis.tooltip.disabled = true;
valueAxis.min = 0;
// single column series for all data
var columnSeries = chart.series.push(new am4charts.ColumnSeries());
columnSeries.columns.template.width = am4core.percent(80);
columnSeries.tooltipText = "{provider}: {realName}, {valueY}";
columnSeries.dataFields.categoryX = "category";
columnSeries.dataFields.valueY = "value";
// second value axis for quantity
var valueAxis2 = chart.yAxes.push(new am4charts.ValueAxis());
valueAxis2.renderer.opposite = true;
valueAxis2.syncWithAxis = valueAxis;
valueAxis2.tooltip.disabled = true;
// quantity line series
var lineSeries = chart.series.push(new am4charts.LineSeries());
lineSeries.tooltipText = "{valueY}";
lineSeries.dataFields.categoryX = "category";
lineSeries.dataFields.valueY = "quantity";
lineSeries.yAxis = valueAxis2;
lineSeries.bullets.push(new am4charts.CircleBullet());
lineSeries.stroke = chart.colors.getIndex(13);
lineSeries.fill = lineSeries.stroke;
lineSeries.strokeWidth = 2;
lineSeries.snapTooltip = true;
// when data validated, adjust location of data item based on count
lineSeries.events.on("datavalidated", function(){
lineSeries.dataItems.each(function(dataItem){
// if count divides by two, location is 0 (on the grid)
if(dataItem.dataContext.count / 2 == Math.round(dataItem.dataContext.count / 2)){
dataItem.setLocation("categoryX", 0);
}
// otherwise location is 0.5 (middle)
else{
dataItem.setLocation("categoryX", 0.5);
}
})
})
// fill adapter, here we save color value to colors object so that each time the item has the same name, the same color is used
columnSeries.columns.template.adapter.add("fill", function(fill, target) {
var name = target.dataItem.dataContext.realName;
if (!colors[name]) {
colors[name] = chart.colors.next();
}
target.stroke = colors[name];
return colors[name];
})
var rangeTemplate = categoryAxis.axisRanges.template;
rangeTemplate.tick.disabled = false;
rangeTemplate.tick.location = 0;
rangeTemplate.tick.strokeOpacity = 0.6;
rangeTemplate.tick.length = 60;
rangeTemplate.grid.strokeOpacity = 0.5;
rangeTemplate.label.tooltip = new am4core.Tooltip();
rangeTemplate.label.tooltip.dy = -10;
rangeTemplate.label.cloneTooltip = false;
///// DATA
var chartData = [];
var lineSeriesData = [];
var data =
{
"Provider 1": {
"item 1": 10,
"item 2": 35,
"item 3": 5,
"item 4": 20,
"quantity":430
},
"Provider 2": {
"item 1": 15,
"item 3": 21,
"quantity":210
},
"Provider 3": {
"item 2": 25,
"item 3": 11,
"item 4": 17,
"quantity":265
},
"Provider 4": {
"item 3": 12,
"item 4": 15,
"quantity":98
}
}
// process data ant prepare it for the chart
for (var providerName in data) {
var providerData = data[providerName];
// add data of one provider to temp array
var tempArray = [];
var count = 0;
// add items
for (var itemName in providerData) {
if(itemName != "quantity"){
count++;
// we generate unique category for each column (providerName + "_" + itemName) and store realName
tempArray.push({ category: providerName + "_" + itemName, realName: itemName, value: providerData[itemName], provider: providerName})
}
}
// sort temp array
tempArray.sort(function(a, b) {
if (a.value > b.value) {
return 1;
}
else if (a.value < b.value) {
return -1
}
else {
return 0;
}
})
// add quantity and count to middle data item (line series uses it)
var lineSeriesDataIndex = Math.floor(count / 2);
tempArray[lineSeriesDataIndex].quantity = providerData.quantity;
tempArray[lineSeriesDataIndex].count = count;
// push to the final data
am4core.array.each(tempArray, function(item) {
chartData.push(item);
})
// create range (the additional label at the bottom)
var range = categoryAxis.axisRanges.create();
range.category = tempArray[0].category;
range.endCategory = tempArray[tempArray.length - 1].category;
range.label.text = tempArray[0].provider;
range.label.dy = 30;
range.label.truncate = true;
range.label.fontWeight = "bold";
range.label.tooltipText = tempArray[0].provider;
range.label.adapter.add("maxWidth", function(maxWidth, target){
var range = target.dataItem;
var startPosition = categoryAxis.categoryToPosition(range.category, 0);
var endPosition = categoryAxis.categoryToPosition(range.endCategory, 1);
var startX = categoryAxis.positionToCoordinate(startPosition);
var endX = categoryAxis.positionToCoordinate(endPosition);
return endX - startX;
})
}
chart.data = chartData;
// last tick
var range = categoryAxis.axisRanges.create();
range.category = chart.data[chart.data.length - 1].category;
range.label.disabled = true;
range.tick.location = 1;
range.grid.location = 1;
HTML
<div id="chartdiv"></div>
CSS
#chartdiv {
width: 100%;
height: 500px;
}
Resources
https://cdn.amcharts.com/lib/4/core.js
https://cdn.amcharts.com/lib/4/charts.js
https://cdn.amcharts.com/lib/4/themes/animated.js
All in one page
<!-- Resources -->
<script src="https://cdn.amcharts.com/lib/4/core.js"></script>
<script src="https://cdn.amcharts.com/lib/4/charts.js"></script>
<script src="https://cdn.amcharts.com/lib/4/themes/animated.js"></script>
<!-- Chart code -->
<script>
// Themes begin
am4core.useTheme(am4themes_animated);
// Themes end
var chart = am4core.create("chartdiv", am4charts.XYChart);
// some extra padding for range labels
chart.paddingBottom = 50;
chart.cursor = new am4charts.XYCursor();
chart.scrollbarX = new am4core.Scrollbar();
// will use this to store colors of the same items
var colors = {};
var categoryAxis = chart.xAxes.push(new am4charts.CategoryAxis());
categoryAxis.dataFields.category = "category";
categoryAxis.renderer.minGridDistance = 60;
categoryAxis.renderer.grid.template.location = 0;
categoryAxis.dataItems.template.text = "{realName}";
categoryAxis.adapter.add("tooltipText", function(tooltipText, target){
return categoryAxis.tooltipDataItem.dataContext.realName;
})
var valueAxis = chart.yAxes.push(new am4charts.ValueAxis());
valueAxis.tooltip.disabled = true;
valueAxis.min = 0;
// single column series for all data
var columnSeries = chart.series.push(new am4charts.ColumnSeries());
columnSeries.columns.template.width = am4core.percent(80);
columnSeries.tooltipText = "{provider}: {realName}, {valueY}";
columnSeries.dataFields.categoryX = "category";
columnSeries.dataFields.valueY = "value";
// second value axis for quantity
var valueAxis2 = chart.yAxes.push(new am4charts.ValueAxis());
valueAxis2.renderer.opposite = true;
valueAxis2.syncWithAxis = valueAxis;
valueAxis2.tooltip.disabled = true;
// quantity line series
var lineSeries = chart.series.push(new am4charts.LineSeries());
lineSeries.tooltipText = "{valueY}";
lineSeries.dataFields.categoryX = "category";
lineSeries.dataFields.valueY = "quantity";
lineSeries.yAxis = valueAxis2;
lineSeries.bullets.push(new am4charts.CircleBullet());
lineSeries.stroke = chart.colors.getIndex(13);
lineSeries.fill = lineSeries.stroke;
lineSeries.strokeWidth = 2;
lineSeries.snapTooltip = true;
// when data validated, adjust location of data item based on count
lineSeries.events.on("datavalidated", function(){
lineSeries.dataItems.each(function(dataItem){
// if count divides by two, location is 0 (on the grid)
if(dataItem.dataContext.count / 2 == Math.round(dataItem.dataContext.count / 2)){
dataItem.setLocation("categoryX", 0);
}
// otherwise location is 0.5 (middle)
else{
dataItem.setLocation("categoryX", 0.5);
}
})
})
// fill adapter, here we save color value to colors object so that each time the item has the same name, the same color is used
columnSeries.columns.template.adapter.add("fill", function(fill, target) {
var name = target.dataItem.dataContext.realName;
if (!colors[name]) {
colors[name] = chart.colors.next();
}
target.stroke = colors[name];
return colors[name];
})
var rangeTemplate = categoryAxis.axisRanges.template;
rangeTemplate.tick.disabled = false;
rangeTemplate.tick.location = 0;
rangeTemplate.tick.strokeOpacity = 0.6;
rangeTemplate.tick.length = 60;
rangeTemplate.grid.strokeOpacity = 0.5;
rangeTemplate.label.tooltip = new am4core.Tooltip();
rangeTemplate.label.tooltip.dy = -10;
rangeTemplate.label.cloneTooltip = false;
///// DATA
var chartData = [];
var lineSeriesData = [];
var data =
{
"Provider 1": {
"item 1": 10,
"item 2": 35,
"item 3": 5,
"item 4": 20,
"quantity":430
},
"Provider 2": {
"item 1": 15,
"item 3": 21,
"quantity":210
},
"Provider 3": {
"item 2": 25,
"item 3": 11,
"item 4": 17,
"quantity":265
},
"Provider 4": {
"item 3": 12,
"item 4": 15,
"quantity":98
}
}
// process data ant prepare it for the chart
for (var providerName in data) {
var providerData = data[providerName];
// add data of one provider to temp array
var tempArray = [];
var count = 0;
// add items
for (var itemName in providerData) {
if(itemName != "quantity"){
count++;
// we generate unique category for each column (providerName + "_" + itemName) and store realName
tempArray.push({ category: providerName + "_" + itemName, realName: itemName, value: providerData[itemName], provider: providerName})
}
}
// sort temp array
tempArray.sort(function(a, b) {
if (a.value > b.value) {
return 1;
}
else if (a.value < b.value) {
return -1
}
else {
return 0;
}
})
// add quantity and count to middle data item (line series uses it)
var lineSeriesDataIndex = Math.floor(count / 2);
tempArray[lineSeriesDataIndex].quantity = providerData.quantity;
tempArray[lineSeriesDataIndex].count = count;
// push to the final data
am4core.array.each(tempArray, function(item) {
chartData.push(item);
})
// create range (the additional label at the bottom)
var range = categoryAxis.axisRanges.create();
range.category = tempArray[0].category;
range.endCategory = tempArray[tempArray.length - 1].category;
range.label.text = tempArray[0].provider;
range.label.dy = 30;
range.label.truncate = true;
range.label.fontWeight = "bold";
range.label.tooltipText = tempArray[0].provider;
range.label.adapter.add("maxWidth", function(maxWidth, target){
var range = target.dataItem;
var startPosition = categoryAxis.categoryToPosition(range.category, 0);
var endPosition = categoryAxis.categoryToPosition(range.endCategory, 1);
var startX = categoryAxis.positionToCoordinate(startPosition);
var endX = categoryAxis.positionToCoordinate(endPosition);
return endX - startX;
})
}
chart.data = chartData;
// last tick
var range = categoryAxis.axisRanges.create();
range.category = chart.data[chart.data.length - 1].category;
range.label.disabled = true;
range.tick.location = 1;
range.grid.location = 1;
</script>
<!-- HTML -->
<div id="chartdiv"></div>