This blog post will show you how to put charts and graphs from the Vixo spreadsheet on WordPress.
The graphs and charts are created in the Vixo spreadsheet using functions. Then can then be inserted into a WordPress blog using the Vixo plugin.
A simple chart – barchart or histogram
This is inserted into this page with the Vixo WordPress plugin and the shortcode:
Barcharts (or histograms) can contain multiple series of data, be stacked or side-by-side, and can be horizontal or vertical.
Pie charts are easy too:
With each graph I will give the vixo shortcode to make it easier for you to try them out.
They can be multi-series as well.
There are a range of line graphs types:
Speedometers or gauge graphs
You can build speedometers like this one:
You can set the thresholds and the scales and customise them in other ways.
Sparklines for dashboards
Inserting graphs and charts in wordpress
To add graphs, install the Vixo plugin and then get a Vixo spreadsheet site to build your graphs in:
Put your data into the spreadsheet and then use one of the graph functions to draw the graph you need.
Take a note of the cell that you create the graph in – you will need it later.
Once you have the graph you need to publish the spreadsheet as a webpage and make it public. This can be done with the views menu in the toolbar at the top right of the spreadsheet:
Finally you need to come back to your WordPress blog and insert the graph.
If you created the graph in cell
b6 on page
/my/graphs/ you would use the following shortcode:
(Read more about Vixo embeddable URL‘s)
Give it a go…