There is no doubt that the WordPress is the best CMS (Content Management Software) ever. It dominates the CMS usage with 76.4% market share. It offers almost every basic features and the features which are not there can be availed by using various WordPress Plugins.
Recently, I wanted to insert a chart/graph inside my WordPress post and tried installing various WordPress Chart Plugins but nothing worked as per the expectations. Some plugins were paid and some were pretty difficult to understand. Seriously, they were annoying.
I researched a lot and found a simple solution to the problem; a chart can be created inside the Google Sheets and then inserted into your WordPress post. Yeah, it’s pretty simple and easy to do.
Table of Contents
Create a New Google Sheet Document
To create a new Google Sheet document, first of all, you’ll need to go to sheets.google.com and Create a new blank spreadsheet. Name your document anything you want and go to the next step.
Fill in the Chart Data
|Never Put % (Percent) in the Data Field.|
Since spreadsheet document has already been created now you need to type in the details that you want to create the chart for. There is no need for providing the column name.
In the A1 column, you can fill in the parameters and in the B1 column, data can be filled in as shown in the image below.
Insert the Chart
Now select the filled in data as shown in the above picture and then go to Insert tab and click on the Chart, after that, a chart will be inserted into your spreadsheet. Below pictures will show you the same.
After that Google sheets will detect and automatically insert suitable chart as per your data. You can also change the chart type by clicking on the Chart Type option which appears to be in the upper right section. There will be multiple chart type options you can choose from.
You can also customize your chart by going to Customize tab which also appears to be in the top right part of the spreadsheet. There, you can customize various aspects of the chart like; Chart style, Chart and axis titles, Series, and Legend.
Here’s a short video describing the same, take a look.
Now that your chart has been created and customized as per your requirements, here comes the next main part of the tutorial…
|Recommended Read: How to Store Contact Form 7 Data to Google Sheets|
Publishing the Chart to Your WordPress Website
There are two ways to share the chart on your website; first is as an image and second is as an interactive chart.
Important: Do not forget to name your chart. You can do that by going to the Customize section, after that click on the Chart & axis title and name your chart anything you want.
To start publishing, go to the chart options and select Publish after that a window will popup which will ask you to choose the type of chart that you want to publish on your website. You can either link or embed your document; if you link your document then it can be viewed only after clicking on the link, but you can show the chart directly on your website by embedding it.
After that click on the publish and copy the embed link which will be used at your WordPress site in order to show the chart.
Showing on Your WordPress Website
Login to your WordPress dashboard and open any post/page where you want to share the chart. After the WordPress editor opens, go to the text mode instead of visual mode and paste the copied embed code. You can also adjust the width and height of your chart by changing values of width and height in the embed code.
If you check option Automatically republish when changes are made while creating the embed code then when you change the graph inside Google Sheets, it will automatically be changed on your WordPress website.
If you have any questions/queries then drop a comment in the comment section below.