There are several ways to put graphs and tables into a blog on WordPress. One of them is Visualizer plug-in, which is easy to handle and straightforward to input data.
[ Barchart using Visualizer (example: Monthly Bill for Utility) ]
[visualizer id=”1656″]
However, the plug-in is limited to use CSV file and does not reflect real-time changes of data. If you need to use CSV file in your desktop or a folder in a dropbox without further changes, Visualizer will be enough. Otherwise, I recommend you to use iframe function of Google sheets to insert an interactive table as follows:
1. Create (or open) a sheet in Google Drive.
2. Click “File” and choose “Publish to the Web”.
3. Click “Embed” and check “Sheet1”. Copy the iframe statement. You can check the status is interactive, which means that data will sync according to changes in an original Google sheet.
4. Put this iframe statement into TEXT (HTML) window of your post.
The following table is the interactive table example.
Inserting charts into WordPress is very similar with the previous case. I’ll use the same sheet that I made for the former example.
1. Click “Insert” and then “Chart”
2. Make a chart for the purpose and click the arrow button on the top right.
3. Click “Publish Chart”
4. From “Embed” tab, copy and paste the iframe statement (you can change set-up of chart such as width and height)
You can insert the interactive chart like the following one.