Title: Percentage Values
Last modified: July 12, 2024

---

# Percentage Values

 *  Resolved [tomtl789](https://wordpress.org/support/users/tomtl789/)
 * (@tomtl789)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/percentage-values-3/)
 * 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?

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/percentage-values-3/#post-17908982)
 * Hello,
 * 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)
 * ![3329794335.png](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/3329794335.
   png?ssl=1)
 * After this, just go in the Display settings of the column, and add any prefix
   or suffix symbol there.
 * ![7104814461.png](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/7104814461.
   png?ssl=1)
 * ![3473824743.png](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/3473824743.
   png?ssl=1)
 * ![4603617641.png](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/4603617641.
   png?ssl=1)
 * 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.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/percentage-values-3/#post-17908982)
 * Status: resolved