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:

Monthly revenue forecast

Annual revenues forecast

Team skills

My day at work

Planned

Done

Total planned

Total done

January

February

March

April

May

June

July

August

September

October

November

December

My day

Email

Meeting

Informal talks

Pause

Production

Skills radar

John

Jack

Data analysis

Redaction

Management

Presentation

Sales

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!