Create dynamic charts for your website
Use Appizy as a chart builder for your website. With the help of the spreadsheet converter, you can create your charts in Excel or LibreOffice and turn them into dynamic, responsive elements to animate the content of your website or mobile application. All of this is possible without writing a single line of code!
Here are some examples of interactive graphs that you can get out of a simple spreadsheet:
How to create and embed charts on your website?
Step 1: open your favorite spreadsheet editor and start putting data into it. We recommend you to follow Appizy’s best practices to create a workbook that will turn into a beautiful and performant web-application. Once you have data, select a range of cells and create a graph. Save the file. Your are done.
You can also convert spreadsheet examples proposed in the converter. This will give you a good starting point to experiment with charts and Appizy.
Step 2: login to Appizy, upload your spreadsheet and in a few seconds you will get a web-application containing your graph ready to be embedded into your website.
Step 3: download the code of the web application. This is an HTML and Javascript file. Depending on your website you can directly copy-paste the code or use an iframe to embed the widget.
Responsive chart for mobile display
Appizy does more than just writing the code of your Excel file equivalent. As usual the idea is to transform a spreadsheet in a modern web-app fitting all kind of displays. All this while keeping the original design that you gave to your tool.
Layouts and chart position
In the converter settings, the layouts “Fluid” and “Auto” are there to create responsive web applications. When you select one of these layouts, the charts are moved bellow the content of the current tab.
This might be surprising at first look, but it is the fastest and easiest way to create a generic responsive layout. Keep this in mind when you build your spreadsheet to create a mobile friendly app.
About Appizy charts conversion
ChartJs
There are already a lot of mature Javascript libraries to create charts. Our choice went for Chart.js. So far we have successfully tested the following types of graphics: scatter plot, lines, pie chart, histogram and radar. Appizy also supports labels, legends and series colour and names.
Limitations
Spreadsheet editors offer a large range of options and customisation when it comes to charts. However, there is no library to recreate all the effects. We chose to reduce the conversion scope to the main chart characteristic: type, labels, legend, series colours. We will add a few more in the coming weeks and months. Drop us an email if you have any requirement not yet met.
Chart edition
As usual the code generated by Appizy can be used as a starting point for further development. ChartJs has a very detailed documentation. Thus, you can always pimp the code written by Appizy using the editor of your choice and following ChartJs documentation.
Conclusion
Appizy now converts charts. They are dynamic and updated every time the calculation runs. As other features we encourage you to play with our sample applications to understand how it works. This is especially true if you want to create a responsive web-application. The main trick here lies in the chart position in mobile displays.
Please note that chart conversion is active for PRO and PLUS plan subscribers.
Feedback very welcome!
While being already stable, this brand-new feature might need some polishing in edge cases. Do not hesitate to send us your feedback on the conversion results.
Happy chart building!