ExploreTheData

ExploreTheData enables you to visualize and explore your data with interactive, cross-linked charts and tables. To create a chart with automatic settings, simply select the data and the variables to be plotted. The add-in provides you different views and helps you gain useful insights about the data. It is powered by a library of Scalable Vector Graphics (SVG) components which smoothly displays large datasets.

The charts can display line plots, scatter plots, and area plots with linear or logarithmic scales. The zoom-dependent rendering provides fast access to single data points of the data set. The tables provide conventional functionality such as row selection, sorting, data searching, and filtering. The tables also include a zoomable graphical view of numerical data. Table column data operations (e.g., sum, mean, minimum, and maximum) are selectable from a menu, and the list of operations is extensible. The charts and tables are cross-linked, meaning that the data corresponding to the selected table rows are highlighted on the chart and vice versa. Furthermore, filtering the data in the table updates the chart accordingly. ExploreTheData can handle large tables because all views are pre-calculated before rendering.

Data import is performed using text files (comma-separated values), JavaScript data files, or a range of cells selected in a worksheet open in Excel. ExploreTheData makes its own copy of the data without data binding between the source worksheet and the add-in.

ExploreTheData is customizable by users in two ways: style files and JavaScript configuration files. The latter enables listing multiple data and style files which are then easily accessible from the drop-down menus.