Dictate Color Of A Scatter Chart Point With Value In The Data
Introduction
Many data sets include color descriptions of an item, such as a shirt color. This plugin allows sales of 'red' items to be displayed with a red data point.
Implementation
1. Create the scatter chart you'd like to put this logic in
2. In the widget editor screen, click the three bar menu at the top right, and then click 'Edit Script'.
3. Copy the contents of the script thats attached to this post, ScatterChart-CustomColors.js, into the widget editor screen.
4. Click save, then refresh the widget.
In this example, I used the hexadecimal color values om the break by. #000000 corresponds to the color black, so data in that group gets displayed as black.
Using Text, Rather Than Hexadecimal Values
In addition to hexadecimal values, plain text color values can be used with this script.
In this example, you can see that the valid color values get displayed correctly. However, invalid color values, such as N\A and Silver/Black, are displayed as black.
Script:
/*
Welcome to your Widget's Script.
- You can access your Widget via the 'widget' variable name.
- You can access your Widget's DOM via the 'element' variable name (undefined until DOM creation).
- You can access your Dashboard by accessing the 'dashboard' variable name.
- For a complete API reference for Widgets and Dashboards go here: https://docs.google.com/document/d/1nQBZtWAdNFAd9nBhPWGVT3qOMS4Qm0PzBZVIzz5DfE8/
*/
widget.on('processresult', function(widget,result){
// Get all the data points
var dataSeries = result.result.series;
// Loop through each data point
$.each(dataSeries, function(){
var color = "white";
// Loop through all data points
$.each(this.data, function(){
// Look for the color series
if (this.selectionData[3]) {
color = this.selectionData[3];
}
// Set the color for this point
this.color = color;
})
// Set the color for the bubble
this.color = color;
})
})Updated 03-02-2023
