Data Visualizer
Create interactive charts from manually entered data in an Excel-like spreadsheet interface with multiple visualization types and aggregation options
Specs
Version
1.2.0 (updated on 2025-04-21)
Developer
Labii Inc.
Type
Section
Support Configuration
Yes
Overview
The Data Visualizer widget provides spreadsheet-style charting capabilities that allow users to create interactive visualizations from manually entered data directly within laboratory records. Similar to Excel's charting functionality, this widget combines a tabular data input interface with powerful visualization options, transforming structured data into bar charts, line graphs, pie charts, and more. Users can paste data from external sources, type values directly, or use example templates to quickly build custom visualizations for ad hoc analysis, summary reporting, or data not stored in existing tables. This flexibility makes it ideal for presenting external results, comparing literature values, or creating summary charts from calculated or aggregated data.
Use Cases
External Data Visualization: Display results from external laboratory instruments, collaborators, or literature sources that aren't in your database
Summary Reporting: Create visual summaries by manually entering aggregated or calculated values from multiple experiments
Comparison Charts: Build side-by-side comparisons of data from different sources, methods, or time periods
Presentation Graphics: Generate publication-ready charts for reports, presentations, or grant proposals with custom data entry
Literature Data: Visualize reference data, standard values, or benchmark comparisons from published sources
Quick Analysis: Perform rapid exploratory visualization of small datasets without creating formal database tables
Theoretical Comparisons: Plot expected values, theoretical predictions, or target specifications alongside experimental data
Meeting Reports: Create instant visualizations during meetings or discussions with flexible data entry
Interface
Read-only View
The read-only view displays both the data table and the generated chart. Users can see the structured tabular data along with its visual representation, making it easy to verify data accuracy and interpret results.
Data Table Display: Shows the input data in a structured grid format with series names in the first column and x-axis values in the first row
Chart Visualization: Interactive chart displays the data according to the selected chart type
Chart Interactions: Hover over chart elements to view exact values and data point labels
Export Access: Download button available for extracting chart data for external analysis
Edit View
The edit view provides an Excel-like spreadsheet interface for entering and modifying data. Users can type directly into cells, paste data from Excel or other spreadsheet applications, and organize data with series names and axis labels.
Spreadsheet Interface: Grid-based data entry with rows and columns similar to Excel
Paste Support: Copy data from external spreadsheets and paste directly into the widget
Data Structure: First row defines x-axis values (categorical or numeric), first column defines series names for the legend
Example Data: Access sample data templates to understand proper data formatting
Save Functionality: Save button to commit data changes and generate/update the chart
Real-time Validation: Interface provides feedback on data structure and formatting requirements
Configuration
Initial Setup
Add the Data Visualizer widget to your section by clicking Add Widget and selecting Data Visualizer from the Custom Input Charts category
The widget will appear with an empty data grid ready for input
Optionally click the Configure button to set chart title, aggregation method, and height before entering data
Required Settings
No settings are strictly required - the widget will function with default values. However, entering data is necessary to generate a meaningful chart.
Optional Settings
Customize your visualization with these configuration options:
Chart Appearance
Chart title: Provide a descriptive title for your chart. This title appears at the top of the visualization and helps identify the data being displayed. Clear titles are essential for scientific documentation and presentations
Height: Set the chart height in pixels. Default is 300px. Adjust based on the complexity of your data and available space. Larger heights provide better readability for charts with many data series or categories
Data Processing
Data aggregation: Define how multiple values should be combined when aggregating data across rows or series
Sum: Calculate the total of all values (useful for cumulative totals)
Average: Calculate the mean of all values (useful for typical or representative values)
Max: Display the maximum value (useful for peak or highest measurements)
Median: Calculate the median value (useful for central tendency with outliers)
Min: Display the minimum value (useful for lowest or baseline measurements)
Data aggregation applies when you have multiple data series and want to combine them mathematically. For most simple visualizations, aggregation is not applied unless specifically needed.
Click the Configure or settings button in the widget header
Enter a descriptive Chart title that explains what data is being visualized
Select a Data aggregation method if you need to combine multiple values mathematically
Adjust Height to ensure your chart is readable and fits well within your section
Click Save to apply your configuration settings
Advanced Configuration
For complex visualization scenarios:
Use the Example data button to load a template showing proper data structure
Configure Data aggregation when working with multiple series that need mathematical combination
Adjust Height based on the number of data series and categories to prevent overcrowding
Start with example data to understand the expected format, then replace it with your actual values. This ensures proper data structure and reduces errors.
Additional Functions
Data Preparation and Entry
The Data Visualizer widget uses a specific data structure for proper chart generation:
Data Structure Requirements:
First Row (X-axis): Contains x-axis labels or values. Can be categorical (treatment names, time points) or numerical (concentrations, dates)
First Column (Series Names): Contains the names of each data series that will appear in the legend
Data Grid: Remaining cells contain the actual values to be plotted
Click in the widget to enter edit mode and access the spreadsheet interface
Enter x-axis values in the first row (starting from the second cell)
Enter series names in the first column (starting from the second cell)
Fill in the data values in the corresponding cells
Click Save to commit your data and generate the chart
Click the Example data button to load a pre-formatted template that demonstrates the correct data structure. You can then modify this template with your own values.
Pasting Data from External Sources
The widget supports pasting data directly from Excel, Google Sheets, or other spreadsheet applications:
In your external spreadsheet, select and copy the data range (Ctrl+C or Cmd+C)
Click in the first cell of the Data Visualizer widget where you want to paste
Paste the data (Ctrl+V or Cmd+V) - the widget will populate multiple cells automatically
Verify the data structure matches the expected format (first row = x-axis, first column = series names)
Click Save to generate the chart from the pasted data
When pasting from Excel, include your column headers in the first row and row labels in the first column to automatically structure your data correctly.
Chart Type Selection
The Data Visualizer widget supports 11 different chart types to best represent your data:
Available Chart Types:
Bar Chart: Rectangular bars with heights proportional to values, ideal for comparing discrete categories
Stacked Bar Chart: Multiple series stacked on top of each other showing composition and totals simultaneously
Line Chart: Data points connected by straight line segments, perfect for showing trends over time or ordered categories
Monotone Line Chart: Smooth curves between data points for cleaner trend visualization without sharp angles
Area Chart: Filled area under the line emphasizing magnitude and cumulative values
Stacked Area Chart: Multiple area series stacked showing cumulative totals and individual contributions
Percent Area Chart: Stacked areas normalized to 100% showing relative proportions over categories
Pie Chart: Circular chart divided into slices showing proportional distribution (best with one data series)
Scatter Chart: Individual dots representing values for two numeric variables, ideal for showing distribution
Joint Line Scatter: Scatter plot with dots connected by line segments combining distribution and trend views
Scatter with Fit: Scatter plot with least squares regression line showing correlation and prediction
After saving your data, the chart appears with the default bar chart type
Locate the chart type selector near the chart display
Click on different chart type options to switch visualization styles
Choose the chart type that best communicates your data patterns and insights
Chart Type Selection Guide:
Use Bar Charts for comparing values across categories
Use Line Charts for trends over time or ordered sequences
Use Area Charts to emphasize magnitude or cumulative values
Use Pie Charts for showing parts of a whole (limit to 5-7 categories)
Use Scatter Charts for exploring relationships between two numeric variables
Use Scatter with Fit to quantify correlations with regression analysis
Data Export and Download
Export your chart data for use in external analysis tools or documentation:
Locate the Download button in the widget interface
Click Download to export the data
Save the downloaded file to your desired location
The exported data includes:
Complete data table with series names and x-axis values
All entered values in a structured format
Can be imported into Excel, R, Python, or other analysis tools
Updating Charts
Refresh the chart when you modify data or change configuration:
After modifying data in the spreadsheet interface, click Save to commit changes
The chart automatically regenerates with the updated data
Alternatively, click the Update button to manually reload the chart from the data table
Best Practices
Data Organization
Clear Structure: Always use the first row for x-axis labels and first column for series names to ensure proper chart generation
Consistent Units: Ensure all values within a series use the same units for meaningful comparisons
Logical Ordering: Arrange x-axis categories in a logical order (chronological, alphabetical, or by magnitude) for easier interpretation
Descriptive Labels: Use meaningful series names and axis labels that clearly identify what data represents
Data Entry Efficiency
Use Example Data: Start with the example template to understand format, then replace with your actual values
Paste from Excel: Copy and paste data directly from spreadsheets to save time versus manual entry
Verify Structure: After pasting data, verify the first row and column are properly formatted before saving
Save Frequently: Click Save after entering data to avoid losing work and to preview the chart
Chart Selection Strategy
Match Chart to Data: Choose chart types appropriate for your data structure (categorical vs. numeric, single vs. multiple series)
Limit Pie Chart Categories: Use pie charts only when you have 5-7 categories or fewer for readability
Use Stacked Charts Carefully: Ensure stacked charts are appropriate when you want to show both individual values and cumulative totals
Scatter for Relationships: Use scatter plots when exploring relationships between two numeric variables
For time-series data, use line or area charts to clearly show trends. For category comparisons, use bar charts for easier value comparison across groups.
Common Pitfalls to Avoid
Avoid: Leaving the first row and column empty or using them for data values
Instead: Always populate first row with x-axis labels and first column with series names
Avoid: Mixing text and numbers within the same data column
Instead: Use consistent data types within each series for proper chart rendering
Avoid: Creating pie charts with too many slices (10+) which become difficult to read
Instead: Limit pie charts to top categories or use bar charts for many categories
Avoid: Forgetting to click Save after entering or modifying data
Instead: Always click Save to commit changes and regenerate the chart
Visualization Best Practices
Descriptive Titles: Use chart titles that clearly explain what data is displayed and its context
Appropriate Heights: Adjust chart height based on complexity - more series or categories need more vertical space
Color Considerations: The widget automatically assigns colors, but ensure your series count allows for distinguishable colors
Legend Clarity: Use concise but descriptive series names that are easily understood in the legend
Documentation and Compliance
Data Sources: Document where manually entered data comes from (external instruments, literature references, calculations)
Regular Updates: When entering time-sensitive data, note the date or time period the data represents
Export for Records: Download chart data regularly to maintain backup copies for audit trails
Verify Accuracy: Double-check entered values against source data to prevent transcription errors
Related Widgets
Chart By Category X: Use together when you need both manually entered charts and table-driven categorical visualizations. Data Visualizer handles ad hoc data while Chart By Category X connects to database tables
Chart By Numeric X: Combine when you need scatter plots from both manual entry (Data Visualizer) and table data (Chart By Numeric X)
Record Summary: Pair with Record Summary to provide high-level record patterns alongside detailed custom visualizations from external data
Last updated