Get Help
leafleafleafMan illustrationFlower illustration
Updated on April 5, 2022

Dynamic Charts

Estimated reading: 8 minutes 688 views

How to get dynamic data using SQL-Builder

Introduction

In this article, I’ll show you the quickest way to add WordPress charts from Database – MYSQL and PHP.

As we learned earlier what is dynamic data? and what are the commonly used data sources, it’s time to use them. In this blog, we will convert our static chart to dynamic using “SQL Builder” 

How to get Capital Column Data

Enable the Uppercase Columns Name Shown in the above given image

Note: If you don’t need offset and limit you can set it null.

Note: You can get data from any table of your currently setup WordPress database.

After selecting type SQL Builder from Dynamic Data Options You have a TextArea for  SQL Raw Query to write your SQL statement.

As you will write your SQL Query all the data will get executes automatically based on your SQL statement.

Once you are done with your SQL statement, you will get column list on resultant of SQL statement. As mentioned in screenshot you will have an option in X Axis Columns and Y Axis Columns with SQL statement resultant column list. 

  • Follow the below steps for learning how to convert static data charts into dynamic using “SQL Builder” –

Step 1 –  Selecting the Chart

Open the Graphina – WordPress chart plugin and select the chart where you want to display the data of google sheet.

For example, choose the Line chart

Step 2 – Changing Data option from Manual to Dynamic 

Select the chart data option and change the time from “manual” to “dynamic” and we can see the message of the no data available that’s because we have not selected the data source till now.

Step 3 – Changing Dynamic Data to SQL

Select the dynamic data option and change the type to “SQL builder”

There we will have the space to write the query Now you will see the changes in the chart.

Step 4 – Selection Of table

Click on “select mode,” there is an option for the table too. So select a table.

Click on “select table,” it will show multiple tables listed in the dropdown list.

Select one table from the list and then the result can be seen instantly

Step 5 – Final Step of Adding WordPress from Database to SQL

In the final step click on the “external” in SQL builder.

Now after choosing External Option we will select the data table from the below dropdown.

Click on the option “WordPress 2” and then edit SQL Raw query

And then from below in the “Y-axis column”, select that we want to be in the column. Data can be seen from external in our line chart \

And then you can see the data of SQL Builder is displayed with the least amount of effort.

Hereby, all the steps are covered for adding WordPress Charts from Database – SQL 

How to get dynamic data using CSV

Note : allow_url_fopen directive should be enabled, check php.ini file in your php folder.

How to get dynamic data using Remote CSV

Introduction

In this tutorial, I’ll show you how to create a chart in WordPress from a CSV data file in 2 Mins or less. It’s so simple! 

As we saw earlier what dynamic data is? and commonly used data sources it’s time to use them appropriately. In this below, I will convert our static chart to dynamic using “Remote CSV” 

Note : allow_url_fopen directive should be enabled, check php.ini file in your php folder.

  • Follow the below steps for learning how to create WordPress charts from CSV files in 2 Minutes – 

Step 1 –  Selection of Chart 

Open Graphina – WordPress Chart Plugin and select the chart where you want to display the data of google sheet 

For example, choose the area chart 

Step 2 – Changing Data Option from Manual to Dynamic

Select chart data option and change the time from “manual” to “dynamic” and then you can we can see the message of the no data available that’s because we have not selected the data source till now.

Step 3 – Adding WordPress Charts from CSV file in 2 Minutes 

Select the dynamic data option and change the type to “Remote CSV” 

Below you will have the option to paste the URL link 

So now you have the option to paste the URL, copy it, and paste it to the given box. 

So now you can see the changes in the chart

As you are at the chart you can see there are three elements select “chart data option” and increase the data element by 3 and you can see the changes on your page. And the data of Chart CSV is displayed here with the least amount of effort.

Hereby, all the steps are covered for adding WordPress Charts from 

CSV file in 2 Minutes – 

That’s all for the Chart CSV in dynamic data 

How to get dynamic data using Google Sheet

Introduction  

Google Sheets comes with a variety of chart options.

However, if you want to create charts in WordPress, then this post will show you how to do it using Google Sheets.

As we learned earlier what dynamic data is? And commonly used data sources. In this blog, We will convert our static chart to dynamic using “Google Sheet”. 

Note : allow_url_fopen directive should be enabled, check php.ini file in your php folder.

  • Follow the below steps for learning how to create WordPress charts from Google Sheets – 

Step 1 – Selection of Chart 

Open Graphina – WordPress Chart Plugin and select the chart where you want to display the data of google sheet 

Step 2 – Changing Data Option from Manual to Dynamic 

Select chart data option and change the time from “manual” to “dynamic” and we can see the message of the no data available that’s because we have not selected the data source till now.  

Step 3 – Adding WordPress Charts from Google Sheets

Select the dynamic data option and change the type to “Google Sheet”

Below you will have the option to paste the URL link

Now select “publish to web” 

“Google Sheet” has been made you need to simply go to files and then share 

Then change it to CSV in this dropbox, now copy the link 

Paste to the given box. 

Can you see the changes in the chart? 

As you are at the chart and you can see there are two elements so select the “chart data option” and increase the data element by 2 and you can see the changes on your page. And the data from the google sheet is displayed with the least amount of effort.

Hereby, all the steps are covered for adding WordPress Charts from Google sheets – 

That’s all for the google sheet in dynamic data 

How to get dynamic data using API

Introduction

If you have been following my blog, then you already know how I love to create data visualization charts using WordPress. 

In this blog, I am going to show you the easiest way to do this without any coding skills.

As we learned earlier what dynamic data is? and commonly used data sources it’s time to use them. In this blog, we will convert our static chart to dynamic using “API” 

How to add Header Key and Header Token

Some APIs use API keys for authorization.

An API key is a special token that the client needs to provide when making API calls.

  •  Follow the below steps for learning how to create WordPress charts from external API’s – 

Step 1 –  Selection of Chart 

Open Graphina – WordPress Chart Plugin and select the chart where you want to display the data of google sheet. 

Step 2 – Changing Data Option from Manual to Dynamic

Select chart data option and change the time from “manual” to “dynamic” and we can see the message of the no data available that’s because we have not selected the data source till now. 

Step 3 – Adding WordPress Charts from External API’s

Select the dynamic data option and change the type to “API”

Below have the option to paste the URL link. 

So now you have the option to paste the URL, copy it, and paste it to the given box.

Step 4 – Increasing Elements

Here on the chart you can see there are five elements select the “chart data option” and increase the data element by 5 and will be able to see the changes on your page. And the data of the API is displayed here with the least amount of effort.

Hereby, all the steps are covered for adding WordPress Charts from external API’s –

Leave a Comment

Share this Doc

Dynamic Charts

Or copy link

CONTENTS