I am trying to create a pie chart using Chart.js that has percentage values. But percentage values are only registered as strings and cannot be changed. Can I get some help?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Can you tell us do you have any symbols inside the cells where your numeric data is,for example a currency sign or percentage symbol?
If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.
The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Sheet, then you can make integer or Float Column from this in our connected Table.
( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)
After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.
Let us know if that helps, it should work to be able to change this Column from String to Float or integer. Or if you make a new Table from the source, the Plugin should automatically ‘guess’ the right Numeric Column format right away.
Then you will be able to use it in a Pie chart as the ‘slices’/series data.
Thank you.
?
Viewing 1 replies (of 1 total)
The topic ‘Percentage Values’ is closed to new replies.