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:
[vixo url="http://wordpress-demo.vixo.com/graphs/a10:a10"]
Barcharts (or histograms) can contain multiple series of data, be stacked or side-by-side, and can be horizontal or vertical.
Pie charts
Pie charts are easy too:
With each graph I will give the vixo shortcode to make it easier for you to try them out.
[vixo url="http://wordpress-demo.vixo.com/graphs/a23:a23"]
They can be multi-series as well.
Line graphs
There are a range of line graphs types:
[vixo url="http://wordpress-demo.vixo.com/graphs/a43:a43"]
This is a common linegraph, and xy graphs, but there are also dategraphs for handling dated information, and equigraphs for plotting activity without a numerical x-axis.
Speedometers or gauge graphs
You can build speedometers like this one:
[vixo url="http://wordpress-demo.vixo.com/graphs/a63:a63"]
You can set the thresholds and the scales and customise them in other ways.
Sparklines for dashboards
Sometimes, when you need to really pack data in, you want sparklines. There are a number of different types, sparkline, sparkbar and sparkhist.
[vixo url="http://wordpress-demo.vixo.com/graphs/b53:c55"]
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:
[vixo url="http://example.com/some/graphs/b6:b6"]
(Read more about Vixo embeddable URL‘s)
Give it a go…