Data Visualizer
Create charts by inputting data in an Excel-like format
Overview
The Labii Data Visualizer widget allows users to create charts by inputting data in an Excel-like format directly within Labii. Similar to Excel’s charting functionality, this widget transforms structured tabular input into visual representations such as bar charts, line graphs, or pie charts. Users can define rows and columns manually, making it ideal for visualizing custom datasets or ad hoc summaries that are not stored in existing tables. With its intuitive interface and flexible configuration, the Data Visualizer widget brings powerful, spreadsheet-style charting capabilities into your ELN or LIMS workflows.
Use case
Provide a chart in report
Configuration
The widget functions without any additional configurations. However, you can customize the chart settings under the configuration section.
Chart title - Please provide the title of the chart.
Data aggregation - Data aggregation is the process where raw data is gathered and expressed in a summary form.
Sum
Average
Max
Median
Min
Height - Chart height in px. Default to 300px.
Interface
The widget’s interface includes a user input section that enables users to paste Excel-like data. It also features labels for the X and Y axes. Additionally, it has a chart section that displays the chart based on the input data.
Data preparation
Please prepare the data in the following manner for the Chart widget to work:
The first row is the X axis. Values can be categorical or numerical.
The first column contains the names of the data series.
To view a copy of example data, click Example data.
To save the data, click Save.
Insert chart
As soon as the data is correctly prepared, the chart will automatically appear.
Choose a chart type to display the chart. See below for a list of supported chart type.
To download the chart data for your own analysis, click the Download button.
You can reload the chart from the data table by clicking on the Update button.
To modify other chart settings, click Edit:
Chart types
Labii support the chart of the following types:
Bar chart - presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.
Stacked bar chart - The stacked bar chart (aka stacked bar graph) extends the standard bar chart from looking at numeric values across one categorical variable to two.
Line chart - displays information as a series of data points called 'markers' connected by straight line segments.
Monotone line chart - displays smooth curves between points
Area chart - displays graphically quantitative data.
Stacked area chart - Stacked Area Chart is plotted in the form of several area series stacked on top of one another.
Percent area chart - A percent stacked area chart is used to depict the series of data points with positive and negative values shown overtime to reveal values of multiple series for the same data point.
Pie chart - a circular statistical graphic, which is divided into slices to illustrate numerical proportion.
Scatter chart - A scatter plot (aka scatter chart, scatter graph) uses dots to represent values for two different numeric variables.
Joint line scatter - Connect each dots with straight line segments.
Scatter with fit - Predicts the results with Least Squares Regression.
Last updated
