SpreadJS provides many options to help you better visualize your data using charts. SpreadJS offers the highest level of compatibility with Excel Charts on the market, making it easy to import or export any Excel files that may contain charts. With extensive support for eleven chart groups, thirty-three chart types, trendlines, and combo chart ability, you can insert any two-dimensional charts in your spreadsheets. Set custom chart layouts, customize chart elements as per your preferences, and combine multiple chart types to evaluate financial information, perform stock analysis, present sales revenues, and much more.
A column chart represents data in vertical bars across the plot area on a horizontal axis. This type of chart is ideal for performing comparisons and analysis between two or more categories of data.
A line chart can help users visualize continuous data over time on an evenly scaled axis. These charts are ideal for analyzing trends in data at equal time intervals, like months, quarters, or fiscal years.
An area chart extensively displays the contribution of each data value over time. Typically, this chart is ideal when you need to show the plot change over time and depict the total value across a trend by showing the sum of the plotted values.
A bar chart extensively used to illustrate comparisons between individual items or categories.
These types of charts are best used to represent stages in a sales process to show the amount of potential revenue in each stage. You could also show a flow of users through an email campaign starting with emails sent out, then how many of those were viewed, clicked, etc., with values typically decreasing at each level, resembling a funnel.
100% Stacked Bar Chart
100% Stacked Bar Chart uses bars to show comparisons between categories of data, but with the ability to break down and compare parts represented as percentages of 100%. Each bar in the chart represents a whole, or a full 100%, and segments in the bar represent different parts or categories of that whole.
A scatter chart illustrates relationships between individual items or categories. This chart is ideal for showing comparisons for scientific, statistical, and engineering data.
Scatter with Smooth Lines
This line displays the non-random component of the association between the variables. Smoothing attempts to separate the non-random behavior in the data from the random fluctuations, removing or reducing these fluctuations, and allows prediction of the response based value.
A Radar chart (also referred to as spider chart) is a two-dimensional chart that can be used to represent multivariate data plotted in rows and columns in the graphical format.
A pie chart displays the size of each item in a single data series in proportion to a total quantity. Data points show as a percentage of the whole pie. This chart is ideal when you want to visualize data in terms of percentage or share.
A stock chart illustrates data range points during a period of time, such as daily stock prices or weather reports of daily rainfall or temperatures. Typically, this chart is ideal for analyzing financial data and visualizing stock information.
A treemap chart is a chart that displays the hierarchical data as a set of nested rectangles organized in a tree-like structure in the worksheet. These rectangles can have different colors and sizes that correlate to the structure of the tree, showcasing how the various items related to the whole in the hierarchy. Useful for showing the amount of stock in a store's inventory or the organization of employees in a company.
The sunburst chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. A sunburst chart without any hierarchical data (one level of categories), looks similar to a doughnut chart. However, a sunburst chart with multiple levels of categories shows how the outer rings relate to the inner rings. The sunburst chart is most effective at showing how one ring is broken into its contributing pieces.
A combo chart combines two or more chart types in a single chart, making it easier for users to interpret and understand data. This chart is ideal when you want to visualize the different types of data that are entirely unrelated (for instance, price and volume) or when you need to plot one or more data series on the secondary axis.
Gauge charts are a type of chart that combines elements of pie and doughnut charts into a single chart type. They are ideal for visualizing a single value in a quantitative way, making it easier to track progress and understand trends. Gauge charts are commonly used in dashboards, reports, and other web applications where it is important to quickly and clearly convey information about a particular metric or data point.
Add Trendlines to Charts
SpreadJS allows users to add trendlines to charts while visualizing data in the spreadsheets. A trendline, also called as a line of best fit, is an additional line in a chart that indicates the slope (trend) in a particular data series to help users in quickly analyzing the overall trend (even when there are ups and downs in your data points). Trendlines are supported on the following charts:
Add Error Bars to Charts
Error bars can help display margins of error and standard deviations in charts, but it has a few other uses as well, including step and Gantt charts. Error Bars support in the following charts:
What's New in SpreadJS v16.2
SpreadJS v16.2 is available. This release offers several great new features, some of which include:
- GanttSheet Add-On Beta
- New Formula Editor Panel
- Framework Support for Angular 16
- Cross-Sheet Reference Support in FormulaTextBox
- New Cell defaultValue Property
- More Accessibility Options
- New Designer Buttons for Excel Themes, Colors, and Fonts
- Window Aggregation Function Added to the TableSheet
- And Much More!