Easiest hack to create WordPress Charts from Google Sheets | Iqonic Design easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 164467 Frame 9

Easiest Hack to Create WordPress Charts from Google Sheets

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”. 

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

Step 1 – Selection of Chart 

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 1

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 

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 2 2

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

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 3 2

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

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 4 3

Below you will have the option to paste the URL link 

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 6

Now select “publish to web” 

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

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 7

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

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 812d3cad 016a 4203 9aad bc38efdfac3e

Paste to the given box

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 9

Can you see the changes in the chart? 

easiest hack to create wordpress charts from google sheets Easiest Hack to Create WordPress Charts from Google Sheets 10 1

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 

As we have seen many commonly used data sources in the previous blogs we will see all of that one by one nicely and how to use it in graphina.

Conclusion

Now you have the knowledge on how to create WordPress Charts from Google Sheets. You will learn more with us, while you have the nicest product of our Graphina – WordPress Plugin. 

Make Sure to Subscribe to our newsletter for the latest theme, templates, and tools to let you Structure and Fortunate Web-project without any sedulous dealing with coding skills. Don’t Forget to Subscribe to our Youtube channel to get an instant video tutorial. Follow us on Facebook and Instagram to get Quick Tips, Educational Posts, infographics, and a lot more. 

Was this article helpful?
YesNo