About App See pricing ZoomCharts website

ZoomCharts

Spreadsheet Analytics

Back

Spreadsheet Analytics application requires JavaScript to be enabled in your browser.

Prepare your excel file:

Date
To build a timeline there has to be at least one column with the date format dd/mm/yyyy values in the rows.
Value
At least one of the columns must have numeric values to group the data.
Facets
All other columns will be converted into donut charts by sum of values.

Show all charts

Matching results

Table rows:

Showing sample data. Refresh the page to load your own Excel file or open the sidebar for more data source options.

Close
Showing only the first 10 data rows as instant preview. Please login with a valid subscription to see the whole data set.
Error

Close

Share your dashboard in various ways Close tileblock

Embed

Embed interactive report into a web app Close tileblock

Developer subscription is required in order to use Embedding.

See pricing

Data

Manage data sources Close tileblock Clear all data

Unavailable

Data source functionality is only available after you login to the application and have a valid subscription.

With a valid subscription (or using the trial) you will be able to merge different data sources, open data from Google Sheets (PRO subscription only), import JSON data and also use simple geocoding tools, for example, to view data on map by countries.

Add new data

Browse Excel File

Add

The application can automatically load Excel files (*.xlsx). For best results please consult the sample file on how to add metadata to the file so that the application can better understand the contents.

However almost any file can be loaded. The most common problem is automatic recognition of dates - you should either format the cells as dates in Excel or use the ISO date format "2015-01-31 23:59:59".

Template excel files

Sales dataDownload Salaries payoutsDownload Bug reportsDownload

Colors

Change the color schema Close tileblock

You must be logged in to the system in order to use the customizations.

PRO subscription is required in order to use customizations.

See pricing

Default Black - Gray Black Grayscale Earth Evening Sunset Ocean

Time Chart

Advanced chart configuration Close tileblock

You must be logged in to the system in order to use the customizations.

PRO subscription is required in order to use customizations.

See pricing

Unavailable

To enable the Time Chart in the dashboard, you have to import a dataset that contains dates in at least one of its columns. Please review sample data on how the dates should be formatted.

Category Charts

Advanced chart configuration Close tileblock

You must be logged in to the system in order to use the customizations.

PRO subscription is required in order to use customizations.

See pricing

Unavailable

To configure the charts, please first import a dataset that contains at least one category field.

Layout

Configure the dashboard layout Close tileblock

Fixed Responsive 2 columns

Presets

Save and load dashboard state Close tileblock

You must be logged in to the system in order to use the presets.

A data file must be loaded in order to save or load presets.

PRO subscription is required in order to save or load presets.

See pricing

Saved presets

Presets allow you to persist dashboard state such as active filters and chart configuration. After loading a new dataset, you can restore the preset on this new data.

The presets are stored with your user account and will be available across all devices once you login.

You can store up to 50 presets. To overwrite an existing preset, delete the existing first.

Spreadsheet Analytics

Cannot load data

Embed

Data

Unavailable

Current data sources

Add new data

Template excel files

Template json files

Step 4 - confirm merge

Colors

Time Chart

Unavailable

Category Charts

Unavailable

Select a chart to customize:

Layout

Presets

Save preset

Saved presets