[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n
Examples<\/h2>\n
[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n
3D pie chart<\/h3>\n
[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n
The following example turns a pie chart into a 3D pie.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/wpdataaccess.com\/wp-content\/uploads\/2022\/04\/charts-3d.png” alt=”WP Data Access – 3D Chart” title_text=”WP Data Access – 3D Chart (Click to Enlarge)” show_in_lightbox=”on” _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Option<\/p>\n
[\/et_pb_text][et_pb_dmb_code_snippet code=”eyAKICAiaXMzRCI6IHRydWUKfQ==” _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
Customizing axes<\/h3>\n
[\/et_pb_text][et_pb_image src=”https:\/\/wpdataaccess.com\/wp-content\/uploads\/2022\/04\/charts-custom-axes.png” alt=”WP Data Access – Chart custom vertical axis” title_text=”WP Data Access – Chart custom vertical axis (Click to Enlarge)” show_in_lightbox=”on” _builder_version=”4.19.1″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Option<\/p>\n
[\/et_pb_text][et_pb_dmb_code_snippet code=”ewogICJ2QXhlcyI6IHsKICAgICIwIjogeyAiYmFzZWxpbmUiIDogMCB9CiAgfQp9″ _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Notes<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
- \n
- The chart widget supports remote database connections. Please make sure the remote user has the SELECT<\/strong> and CREATE TEMPORARY TABLES<\/strong> privileges.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Further reading<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
- \n
- https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/piechart<\/a><\/li>\n
- https:\/\/developers.google.com\/chart\/interactive\/docs\/customizing_axes<\/a><\/li>\n
- https:\/\/developers.google.com\/chart\/interactive\/docs\/examples<\/a><\/li>\n<\/ul>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Each chart type needs its own data set. Data sets are created using SQL queries. Please check the hints available for each chart type and make sure your SQL query meets these requirements. Use the Query Builder to test your queries before you use them to create a chart.Make sure your query does not return […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\n
Charts are new in version 5. The following chart types are supported:<\/p>\n\n\n\n
[rl_gallery id=\"9116\"]<\/div>\n\n\n\nEach chart type needs its own data set. Data sets are created using SQL queries. Please check the hints available for each chart type and make sure your SQL query meets these requirements. Use the Query Builder to test your queries before you use them to create a chart.<\/p>\n\n\n\n
Make sure your query does not return thousands of rows. This will slow down your server, and charts showing thousands of values are useless anyway. Use a publication if you need a table showing hundreds, thousands or millions of rows, or if you want to add advanced searching, export buttons or other publication features.<\/p>\n\n\n\n[cmruncode name=\"Chart Types\"]\n\n\n\n
Advanced chart options<\/h2>\n\n\n\n
Advanced chart options allow plugin users to add Google Charts options which are not available through the user interface. Options need to be entered in valid JSON. Invalid JSON is rejected! Use the Check JSON validity<\/strong> button before you close the popup.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
3D pie chart<\/h3>\n\n\n\n
The following example turns a pie chart into a 3D pie.<\/p>\n\n\n\n
![](\"https:\/\/wpdataaccess.com\/wp-content\/uploads\/2022\/04\/charts-3d.png\" "\\"WP")
<\/a><\/div>\n\n\n\nOption<\/h4>\n\n\n\n
{ \n \"is3D\": true\n}<\/code><\/pre>\n\n\n\nCustomizing axes<\/h3>\n\n\n\n
The following example sets the vertical axis baseline to 0.<\/p>\n\n\n\n
![](\"https:\/\/wpdataaccess.com\/wp-content\/uploads\/2022\/04\/charts-custom-axes.png\" "\\"WP")
<\/a><\/div>\n\n\n\nOption<\/h4>\n\n\n\n
{\n \"vAxes\": {\n \"0\": { \"baseline\" : 0 }\n }\n}<\/code><\/pre>\n\n\n\nNotes<\/h2>\n\n\n\n
- The chart widget supports remote database connections. Please make sure the remote user has the SELECT<\/strong> and CREATE TEMPORARY TABLES<\/strong> privileges.<\/li><\/ul>\n\n\n\n
Further reading<\/h2>\n\n\n\n
- https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/piechart<\/a><\/li>
- https:\/\/developers.google.com\/chart\/interactive\/docs\/customizing_axes<\/a><\/li>
- https:\/\/developers.google.com\/chart\/interactive\/docs\/examples<\/a><\/li><\/ul>\n\n\n\n
<\/p>\n","_et_gb_content_width":"","footnotes":""},"doc_category":[24,25],"doc_tag":[],"knowledge_base":[],"class_list":["post-102","docs","type-docs","status-publish","hentry","doc_category-charts-legacy","doc_category-widgets"],"year_month":"2026-06","word_count":1252,"total_views":"126","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"peterschulz.nl@gmail.com","author_nicename":"peterschulz-nlgmail-com","author_url":"https:\/\/wpdataaccess.com\/author\/wpdataaccess_admin\/"},"doc_category_info":[{"term_name":"Charts","term_url":"https:\/\/docs.legacy.wpdataaccess.com\/docs\/non-knowledgebase\/charts-legacy\/"},{"term_name":"Dashboards Widgets","term_url":"https:\/\/docs.legacy.wpdataaccess.com\/docs\/non-knowledgebase\/widgets\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":0,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/102\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_category?post=102"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_tag?post=102"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/knowledge_base?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- https:\/\/developers.google.com\/chart\/interactive\/docs\/customizing_axes<\/a><\/li>
- https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/piechart<\/a><\/li>
- https:\/\/developers.google.com\/chart\/interactive\/docs\/customizing_axes<\/a><\/li>\n
- https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/piechart<\/a><\/li>\n