Title: Pie Charts Wrong Data Displayed
Last modified: December 4, 2020

---

# Pie Charts Wrong Data Displayed

 *  Resolved [angolanmade](https://wordpress.org/support/users/angolanmade/)
 * (@angolanmade)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/pie-charts-wrong-data-displayed/)
 * Hi, Thanks for the awesome plugin, I have been testing it out and have come-up
   against a few items that I simply can’t understand or figure out.
 * I have created a simple google spreadsheet with the following three columns and
   ten (10) entries of data – [https://i.imgur.com/oxnoHn1.jpg](https://i.imgur.com/oxnoHn1.jpg)
 * ID | Name | City
    1 | ACBD | Toronto 2 | ACBD | Toronto 3 | ACBD | Toronto 4 
   | ACBD | Toronto 5 | ACBD | Toronto 6 | ACBD | Montreal 7 | ACBD | Montreal 8
   | ACBD | Montreal 9 | ACBD | Montreal 10 | ACBD | Montreal
 * When attempting to create a simple pie chart analysis to display a 50% split 
   between the cities using “ID and City” with “Enable Grouping” enabled end-up 
   with 72.7% Montreal and 27.3% Toronto
 * [https://ufile.io/ca3qc4qt](https://ufile.io/ca3qc4qt) — Video of chart creating
   process
 * [https://i.imgur.com/qd3UrxC.jpeg](https://i.imgur.com/qd3UrxC.jpeg) — results
   of chart
 * What is the correct steps to ensure that the pie chart displays the correct data
   showing 50% Montreal, 50% Toronto split?
 * Lastly, tried playing around with a spreadsheet that displays athletes “height”
   in the following format 6’6″, however when I try to change the column type from“
   string to “integer” or “float” in wpdatatables it shows the data incorrectly 
   formatted?
 * Thanks again, sorry for the long explanation, hopefully it is detailed enough.

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/pie-charts-wrong-data-displayed/#post-13753055)
 * Hi angolanmade,
    Sorry for inconvenience, Yes that is correct because you use
   ID column as value column which start from 1 to 10 and then when this is split
   in proportion of those two cities(Toronto have 15(1+2+3+4+5) and Montreal have
   40 (6+7+8+9+10))
 * To achieve what you need you have to create a table like this:
 * ID | Name | City | Amount
    1 | ACBD | Toronto 50 2 | ACBD | Montreal | 50
 * or
 * ID | Name | City | Amount
    1 | ACBD | Toronto 1 2 | ACBD | Montreal | 1
 * And then to create a table from columns City and Amount.
 * Grouping is not available in Lite version of plugin so if you have question for
   premium version please contact us on our support platform that you can find on
   our official website, because support for premium plugin is not allowed here.
 * For displaying height in wpdatatables as number you will need to insert it as
   integer of float. Any other format will be treated as string.
 * Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Pie Charts Wrong Data Displayed’ 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: [5 years, 5 months ago](https://wordpress.org/support/topic/pie-charts-wrong-data-displayed/#post-13753055)
 * Status: resolved