iChart – Easy Charts and Graphs vs SQL Chart Builder

AI Powered Charts, Graphs with iChart Responsive Charts and graphs are now easy to build with AI. Add Charts and Graphs to any WordPress page with just a few clicks and shortcode generator. iChart is an AI Powered implementation to add beautiful, responsive graphs & charts to your site easily – directly from WordPress page or posts editor. GeoChart is supported in the Pro version. iChart includes Shortcode Generator Graph and Chart Block for Gutenberg and iChart’s chart and graph shortcode generator is compatible with Guttenberg and any other visual editor. Create beautiful Dashboards with Charts, Graphs, and Filtering from GoogleSheet (requires AI) Use AI prompt to create any kind of Charts and add to a page with Shortcode. iChart also supports creating and building Pie Chart, Bar chart, Line Chart, Polar Area Chart, Radar Chart, and Doughnut Chart using chartjs that are optimized to address your WordPress data visualization needs. Visualize your data now more easily than ever with iChart chart builder! iChart Pro supports visual chart builder, data table, GeoCharts, embed sharing and more! Check out the Demo of iChart Pro Version Build incredible Charts. Upgrade to iChart Pro Now! iChart provides Simple yet flexible JavaScript chart building ability. It creates HTML5 and fully Responsive charts which are mobile device friendly and looks great for data visualization. iChart is supported for all browsers where canvas is supported. Browser support for the canvas element is available in all modern & major mobile browsers as well. iChart allows you to define individual background colors for different data points and labels. Just use the iChart shortcode generator to generate and embed your chart or graph to any WordPress page or post. iChart support multiple responsive charts and graphs on the same page. iChart allows you set each chart and graphs size from the shortcode generator. 🚀 Give our FREE AI ChatBot for WordPress – WPBot a try! This super-easy, native WordPress chatbot doesn’t require any coding skills and provides automated live chat support. Use WPBot to answer user questions and gather information through conversational forms. You can power it with DialogFlow or OpenAI ChatGPT, or simply use its built-in features for live support and data collection. ++ Take a look at the #1 ChatBot for WordPress WPBot demo. Do More with iChart Pro! Need to create a comprehensive Chart or Data Table that you will need to edit later? iChart pro lets you create Charts, Graphs and Data tables with a Lot of customization options that you can reuse and embed on any page with shortcodes. Enable the Embed button to let your website users embed the Charts, Graphs and Data tables you created on their own website easily. This unique feature is not available in any other plugin. All Free Version Features of the iChart ⭐ Supports Pie Charts, Bar charts, Line Charts, Doughnut Charts and Polar Area Charts ⭐ Supports creating any kind of charts with AI Prompts. Supports OpenAI and Google Gemini. ⭐ Create Dashboard from Googlesheet with filtering. Show them in the front end with shortcode ⭐ Quick ShortCode Generator for Charts ⭐ HTML5, Responsive Charts ⭐ No Chart saving or data table option All Pro Version Features of the iChart ⭐ Create charts with AI Prompts. Supports OpenAI and Google Gemini ⭐ Create jQuery based Data Tables ⭐ Create multiple dashboards from Google Sheet. Show them in the front end with shortcode ⭐ Add Dashboards to WordPress admin panel ⭐ Use ShortCode with ShortCode Generator to Embed Charts on Any Page Quickly ⭐ Generate Quick Chart with ShortCode or Save and Reuse Comprehensive Charts ⭐ HTML5, Responsive and Animated Charts and Graphs ⭐ Supports Multiple Datasets ⭐ Create GeoCharts ⭐ Location auto complete using Google Map API ⭐ GeoChart Display mode – Regions, Markers, Text ⭐ Change Data highlight colors for GeoCharts ⭐ Visual Table Mode to Easily Enter and Edit Chart Data ⭐ Add/Remove Rows and Columns with Click of Buttons ⭐ Customize Background Colors for each Dataset ⭐ Three Positions to Display Chart information Top, Bottom, and Right of the Chart ⭐ Supports Links for each data ⭐ Option to hide Chart Information and show only the Chart or Graph ⭐ Show/Hide Chart Title ⭐ Supports Custom Text to Show after Tooltip and information ⭐ Custom CSS to add your own style ⭐ Full customizable options and control over Typography ⭐ Customizable Width, Text Color, Font Size, Background Color, Border etc. ⭐ Show and Hide Horizontal and Vertical Grid lines ⭐ Import/Export Chart Data ⭐ Powerful short code Generator for both Gutenberg and Classic Editor ⭐ Live Chart Preview on Admin after Save ⭐ Enable Embed Option to allow anyone to embed your chart on their website. Check out the Demo of iChart Pro Version Build incredible Charts. Upgrade to iChart Pro Now! Who is this Chart Builder for? iChart is a useful chart plugin for you if you are a: Blogger SEO Specialist Content Curator Marketer Webmaster Data Visualizer Anyone with a WordPress website What Can You Do with iChart – Chart Builder? Create beautiful, elegant Infographics with Charts and Graphs – any page anywhere with short code. Use the Gutenberg Block to Generate Chart and Graph directly from the page or post editor. iChart supports creating and adding Bar chart, Line Chart, Polar Area Chart, Radar Chart, Pie Chart and Doughnut Chart. Use Create a new page and use the iChart button from your Visual editor to generate and embed your chart in any page or post.

The plugin creates beautiful charts based on your SQL queries, then you can use those charts in any part of your website. You can use both native wp and non-wp mysql tables in your queries. 11 chart types: Pie, Doughnut, Polar Area, Radar, Line, Area, Stepped Line, Bar, Horizontal Bar, Stacked Bar, Scatter What’s new in 3.0 A completely redesigned chart builder. No more “nerd-only” settings page: a clean, tabbed UI walks you through Chart & Data → Dynamic Filters → Style → Advanced. Visual chart type picker with built-in guides. Every chart type shows a short “when to use it” guide plus a working example query you can insert with one click. Live SQL autocomplete. Start typing and the editor suggests SQL keywords (type “S” — get SELECT), your real database table names and real column names. Type tablename. to see that table’s columns. Press Ctrl+Space for suggestions at any time. Click-to-build query toolbar. SELECT / COUNT(*) / FROM / WHERE / GROUP BY / ORDER BY / LIMIT buttons plus “Insert table”, “Insert column” and “Insert dynamic tag” dropdowns filled with your actual database schema — build a best-practice query without typing a single word. No-code input filters. Add date/number/text filters as simple rows (tag, type, label, default) — the tag dropdown suggests {tags} already used in your query and columns from its WHERE part. No more memorizing the ~ / | syntax (a raw editor is still available for pros). One click inserts the {tag} into your query. Dropdown column mapping. The X/Y axis fields are dropdowns filled with the columns detected in your SQL query — no more guessing column names. Color pickers instead of typing hex codes, and a fixed professional default palette instead of random colors. Latest Chart.js v4, bundled inside the plugin — no third-party CDN calls, GDPR-friendly. 4 new chart types: Radar, Stepped Line, Stacked Bar and Scatter. Better front-end design: modern table view, restyled filter form and datepicker. Full legacy support: charts created with 2.x keep working unchanged. Deprecated Google-Chart types are automatically mapped to modern equivalents when you open/save the chart. How to use Go to Dashboard → My SQL Charts → Add New and give any name to your report. Pick a chart type — read the short guide shown under the type cards, or click “Use this example” to start from a working query. Build your SQL query with the toolbar buttons and autocomplete (real table and column names are suggested), then map the X and Y columns. You can use multiple SQL queries too — just split them with the “;” sign to get comparison charts. You can also pass shortcode arguments into the query: with “select * from wp_posts where ID>{arg1}” the shortcode [gvn_schart_2 id=”2″ arg1=”11″] passes the value in. After Publish/Update you will see the shortcode below the builder. Use it anywhere on your website: pages, posts, widgets, or the “My SQL Charts” Gutenberg block. Check “Show table-view data below the graph” to also render the data as a styled table. In the Input Filters tab, add filters by clicking “+ Add filter” — each one becomes an input (with a datepicker for date types) above the chart at the front-end. Chart type mini-guide Pie / Doughnut — how a total splits into a few parts. One query: label column + numeric column. Polar Area — like a pie, but the value controls the radius; great for cyclic data (months, weekdays). Radar — compare one or more series across categories arranged in a circle (profiles, ratings). Line — trends over time; add more “;”-separated queries for comparison lines. Area — a line with the region filled; emphasizes volume. Stepped Line — values that change at discrete moments (prices, stock levels). Bar / Horizontal Bar — compare categories; horizontal is best for long labels. Stacked Bar — how each category total is composed; each “;”-separated query becomes one segment. Scatter — correlation between two numeric columns (both X and Y must be numeric). Input filters (dynamic variables) Use the visual rows in the Input Filters tab, or the raw format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type variable_name – any single name you want. default_value – default value when no variable is chosen by the user variable_label – label visible on the form above the chart variable_type – number, text or date ~ separates variable elements, | separates variables Example: with the filters “limit_tag~10~Count~number | post_date_tag~2010-07-05~Date Published~date” you can use “select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}” as the SQL code — the plugin renders the corresponding inputs above the chart automatically. Supported built-in dynamic tags: {current_user_id}, {current_user_login}, {current_user_email}, {current_user_display_name}. Caching Use [gvn_schart_2_cached id=”1″ expire=”3600″] to cache the rendered chart in a transient. Add &force_sql_cache_reload=1 to the URL to bypass it once (e.g. right after upgrading). Website https://guaven.com/my-sql-charts/ Documentation https://guaven.com/my-sql-charts/#docs Bug Submission and Forum Support Contact Page Please Vote if you liked our plugin Your votes really help us. Thanks. Available Filters apply_filters( ‘guaven_sqlcharts_table_empty_cell’); apply_filters(‘guaven_sqlcharts_pre_print_vars’); apply_filters( ‘guaven_sqlcharts_final_output’); apply_filters(‘guaven_sqlcharts_rendered_sql’);