The best way to visualize data is often with a chart. In this tutorial, we convert an Excel spreadsheet with a chart into an interactive web page. The chart 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

If you don’t want to practice using the product, you can download the pie-chart.xlsx example spreadsheet here.

Enable interactive charts

Your version of SpreadsheetConverter may offer other options, but for this tutorial we want to use the Interactive chart engine. Open the task pane and select the Workbook tab. The Chart options are near the end. Ensure that Choose Interactive Charts is selected.

Make your designs printable

If your web page or web form is to be printed, always 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. Don’t make your spreadsheets too wide.
  • If you are confident editing CSS files, use @media print directives in your CSS for print-specific formatting, e.g. to remove menus and sidebars.

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:

Screenshot of a spreadsheet with a chart imported in a web page

Verify that the chart is interactive by hovering your mouse above one of the slices, or the corresponding row in the legend. As you can see, interactive charts make it very easy to see what is what in a complex chart.

If you want to hide uninteresting data, just click on the corresponding row in the legend. In this example, we clicked on Group 1 and Group 4 to hide them. The pie chart now shows the relation between the remaining three data series.

Screenshot of a chart in the web page with two hidden series

Finally, to let you verify that the chart is indeed live in the web page, we changed the name for the first series to Section 1 and multiplied its value by 10.

Screenshot of a live chart in a web page with changed data

As you can see, the chart is live also on the web page!

Publish the page on the web

SpreadsheetConverter comes with built-in one-click web publishing. Your calculator is hosted on the distributed Amazon S3 infrastructure with superior performance, extreme reliability and massive scalability. Over a dozen server locations around the globe ensure that your calculator always is within easy reach of your global audience.

Our Publish to Cloud feature automatically generates all the HTML you need to add the calculator to your website. To learn more, read the help page for Publish to Cloud or one of the tutorials in the list below.

Conclusion

With SpreadsheetConverter, you can easily publish both simple and complex spreadsheets and charts on the web. Everything is live. If you change the value in any of the fields on the page, both the live chart and all other cells immediately reflect the new values.

Using charts does not require any effort. If your spreadsheet contains a chart, so does the converted web page.

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. Your users don’t even need a license for Excel.