Ninja Charts – Interactive Charts and Graphs vs SQL Chart Builder

If you need the best charts and graphs plugin for your WordPress website, you are at the right place. With Ninja Charts, you can create responsive charts that are fully customizable, and beautiful. For the best data visualization, Ninja Charts is the most powerful and lightweight chart and graph generator. It allows you to create numerous types of graphs and charts in WordPress. Line charts Pie charts Bar charts Bubble charts Doughnut charts Radar charts Polar charts Scatter charts Area charts Combo charts Horizontal bar charts Funnel charts WordPress Charts Plugin Video Preview Ninja Tables Integration With Ninja Charts When Ninja Charts is packed with Ninja Tables, it’s one of WordPress’s most eligible chart-maker plugins. It enables you to retrieve data from a popular data table builder: Ninja Tables and show them in the form of different charts. Ninja Charts Features This completely free Ninja Charts plugin is a robust visualization tool that enables you to create many kinds of interactive and customizable charts and graphs. It is equipped with a lot of amazing features. Deep integration with Ninja Tables Easy-to-use interface Design and Layout customization Responsive, mobile-friendly WordPress chart plugin Simple and handy steps to get started SEO-friendly charts Shortcodes to embed Live preview on admin Multiple chart types available Multiple data sources Versatile rendering engines Special formatting and preview option Amazing, dedicated support facility 10+ Chart Types This WordPress chart and graph plugin provides more than 10 types of charts that are optimized to address your WordPress data visualization needs. Ninja Charts allows you to customize your data charts in the best way possible. You can choose from a bunch of advanced options to customize your online data chart while creating the chart. Customizability with ease Ninja Charts is Versatile and Tailored to Your Needs. Now personalize your charts with ease. Customize a wide range of options to seamlessly integrate the visual style of your website. While Google Chart tools offer a default setting, all customization is entirely optional, and the basic setup is ready to go. Should your webpage have a unique style that differs from the provided defaults, charts, and graphs can be effortlessly adjusted. Each chart offers a plethora of options to fine-tune its appearance with complete flexibility. Some customization options are- Chart width Responsive chart width Chart height Chart Position Background color Border width Border color Border radius Font size Font style Font color Moreover, you’ll get more options like AXES, TITLE, TOOLTIP, and LEGEND to give your online chart a more polished look. Responsive Charts While 90% of your visitors are mobile users, you just can’t forget the responsiveness of the charts. That’s why Ninja Charts comes with a JavaScript-based chart rendering engine that provides cross-browser compatibility and cross-platform portability to any screen size. Flexibility and Ease of Use It’s the easiest chart-maker solution for your websites. You just need to specify the titles and the chart type, and then you will find the option to put a value manually, or you can retrieve data from the Ninja Tables plugin directly. After completing the process, the plugin will automatically generate a short code for a single chart, which you can embed on any page or post to show the respective data. Awesome Support You can get dedicated support from our excellent support team for this beautiful WordPress table plugin for free! All you need to do is create a support ticket here. Our support team eagerly awaits your feature requests and extended help for customized tables. Don’t hesitate to create a support ticket for the best experiences.

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’);