The best way to visualize data is often with a chart. In this tutorial, we will use SpreadsheetConverter to convert an Excel chart into a live Flash animation that updates automatically when the values in the web page are changed.

All you need to create a live chart for the web is Microsoft Excel and SpreadsheetConverter. Create a data table, insert the chart, convert the spreadsheet to a web page and publish it on the web. It’s that easy!

Create the data table and chart in Excel

To create this tutorial, we opened a new spreadsheet in Excel and inserted the data table you see to the left in the screenshots below.

We selected the entire data table, i.e. the cell area A2:B6. When we later insert the chart, this cell range becomes the data series. If the rows and columns you want to select are not adjacent, just hold down the Ctrl key and mark any discontigous cell ranges before you insert your chart.

 

We asked Excel to insert a pie chart (Insert > Pie > chart type), automatically using the selected cell ranges as the data series. The chart was a little too big, so we adjusted its size by dragging the borders.

pie-excel-483-229

MAKE THE WEB PAGE PRINTABLE

If your web page or web form is to be printed, ensure that your spreadsheet design is appropriate.

  • Web page backgrounds are usually not printed. Avoid light text on dark background.
  • Web browsing and printing usually works best in portrait mode.
  • Use @media print in your CSS for printing-specific formatting, e.g. to remove menus.

If you don’t want to practice using the product, 

you can download the pie-chart.xlsx spreadsheet here.

Convert the spreadsheet to a web page

We selected the Html flavor in the Conversion section of the SpreadsheetConverter ribbon, and pressed “Convert”. After conversion, the converted web page automatically opened in the web browser.

Here’s the result:

pie-web-399-222

To verify that the chart is indeed live, we multiplied the first value by 10, and changed its name from “Group 1” to “Section 1”:

pie-web-updated-396-223 (1)

As you can see, the chart is live even on the web page.

Conclusion

With SpreadsheetConverter, you can easily publish both simple and complex spreadsheets and charts on the web. Everything is live, and if you change any of the cells in the spreadsheet, the live charts immediately reflect the new values.

With SpreadsheetConverter you can deliver advanced calculation and visualization tools to an unlimited number of users from one common central location. You don’t have to distribute files that eventually become outdated, and your users don’t need a license for Excel (or any other program).