News: Interactive charts

For SpreadsheetConverter v12, see the help, installation guide or product tour.

Earlier versions: show the original page

Interactive charts

Your visitors can interact with the new charts directly on the web page

Interactive charts

With the new charting engine you can highlight one of the series by hovering your mouse above its label, or click on the label to hide the series.

The new interactive charts in version 9 allow your visitors to use the mouse to tailor the chart to their needs. They can focus on a certain data series or completely hide one or more data series.

Supported chart types

Bar and Stacked Bar charts
Column and Stacked Column charts
Line and Stacked Line charts
Area and Stacked Area charts
Radar charts
Pie charts
Doughnut charts
Scatter charts

Supported chart features

Chart Title
Legend
Axis Title
Secondary Axis
Grid Lines
Line Color
Line Style
Data labels
Font Formatting
Logarithmic series

How to interact with the charts

Screenshot of a simple chart with four series

The interactive charts allow you to highlight one of the series just by hovering your mouse above its label.

In the screenshot below, we just held the mouse pointer above the Revenue series’ label. As you can see, the other three series faded out to let you focus on the highlighted series.

Screenshot of a simple chart with four series, one highlighted

If you find some of the series distracting, just click once on the series labels and the series will be hidden. In the chart below, we simple clicked on the Industry average revenue and Industry Average Profit labels to hide them. Click on each label again to make the series visible.

Screenshot of a simple chart with four series, two hidden

If you want to try this for yourself, create a Combo chart in Excel. In Excel 2016, it is at the bottom of the All charts tab.

Screenshot of the Change Chart Type window in Excel 2016, with Combo charts selected

You can also download our example spreadsheet just to see how charts can look in converted web pages.

Test an example of interactive charts

Download the example spreadsheet

Limitations

Interactive charts are only supported in the Professional edition of SpreadsheetConverter. Upgrade to the Professional edition to use lots of new chart types and the new interactive charting engine, more Excel functions and many other advanced features.