This blog post will show you how to put graphs from the Vixo spreadsheet on WordPress.
Here are a couple of spreadsheet graphs:
They are embedded into this blog using the Vixo WordPress plugin.
To add graphs, install the Vixo WordPress plugin and then get a Vixo spreadsheet site to build your graphs in.
Once you have installed the plugin get a Vixo spreadsheet:
(this is an embedded spreadsheet control too!)
Put your data into the spreadsheet and then use one of the graph functions to draw the graph you need. Unlike in Excel, Open Office Calc or Google Docs, graphs in Vixo are functions you put in cells. The functions take the form:
=dategraph.WxH(XRange, NoOfYs, Yrange1, Yrange2,..., [Title], [X-Axis-Label], [Y-Axis-Label], [Series_Names])
The function name has a Wide By High value tacked on the end to resize the graph. To get a small graph you would enter
=dategraph.3x6(A1:A10, 1, B1:B10). This will create a graph 3 cells wide by 4 cells high.
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:
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…