Hi All,
Can anyone help me figure out how to add custom colors to Pie chart?
I have a predefined set of colors which needs to be used however, I am unable to set the colors in the Pie chart format area.
Can anyone help me with this.
Thanks,
Megha
On a semi-related issue - I was looking into this and came up with the attached bug ... When an action tool is set up to a chart tool and you open the chart tool - configure chart crashes. take away the action tool and everything is copacetic.
also my suggestion was either concatenating color codes and then using a batch macro to go in and edit each color value via an action tool/get word combo - with one action tool per color or the dreaded "use R/Python." Perhaps someone else has a better idea or knows the secret of pie chart colors.
Hi @meghasaraf
I was able to add custom colours by following the excellent tutorial by @kelly_gilbert
Add your new palette name at the end of the array, making sure to follow the syntax i("palletname") and delimit with commas.
var f=[i("D3"),i("G10"),i("T10"),i("Alphabet"),i("Dark24"),i("Light24"),i("Custom")]
Dan
@danilangI was figuring if anyone knew a hack it would be you - I'm not 100% sure that's easier than the multi-action tool/get word approach but much less likely to crash configure chart.
@apathetichell - the main reason you'd want to edit the file is that you only have to do it once, and then it's ready to go from that point on (without the added complexity of adding a macro to the affected workflows). The modified .js file can be shared easily with others across the company (i.e. one person edits the file once, and then everyone can use it). So, if you only have only one charting workflow, it might not be easier, but with more than one workflow (or more than one user), a defined palette is definitely the way to go.
Having a defined palette is especially useful when using Transforms to split the data into separate channels, because you can assign the palette, and then when a new category shows up in your data, it just uses the next color in the palette automatically (without you needing to update/change the workflow). [Although, there is a known defect with the Transform functionality right now]
@kelly_gilbert - all true and great points. Thanks!
Hi,
I hope you are doing well.
I would love to share with you how to make beautiful charts in Google Sheets and Excel. I used ChartExpo™ to make 50+ types of charts in just few clicks.
There is no requirement of coding skills.
Sharing a video to watch how easy to create charts in Google Sheets and Excel.
Installation Source:
ChartExpo for Excel
ChartExpo for Google Sheets
Regards!