Charts feature comparison
Compare Charts features, support, and compatibility with Microsoft Office, Google Workspace.
8 categories, 43 features; Univer supports 43, partially supports 0, and does not support 0.
Integration guide · All features
Comparison scope
Compares Univer Charts SDK with Microsoft 365 Excel for Windows desktop and Google Sheets, including official chart APIs. Only chart types are compared, excluding styling, axes, and interaction details. Images, cell color scales, and independent add-ons are not counted as built-in charts. Partial support notes the available combinations or approximations. All previews use demonstration data.
“Open source” marks full support in the open-source edition. Unmarked items may include basic subsets, optional modules, or commercial licensing; consult the corresponding module documentation.
Column and bar charts
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Clustered column | ✓ SupportedCompare categories or series with side-by-side columns. | ✓ Supported | ✓ Supported |
| Stacked column | ✓ SupportedShow totals and composition with stacked series. | ✓ Supported | ✓ Supported |
| 100% stacked column | ✓ SupportedCompare composition ratios as percentages. | ✓ Supported | ✓ Supported |
| 3D column | ✓ SupportedCompare categories and series with three-dimensional columns. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
| 3D stacked column | ✓ SupportedDisplay stacked totals and composition with 3D projection. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
| 3D 100% stacked column | ✓ SupportedCompare percentage composition with 3D projection. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
| Clustered bar | ✓ SupportedCompare categories or series with horizontal bars. | ✓ Supported | ✓ Supported |
| Stacked bar | ✓ SupportedShow totals and composition with stacked horizontal bars. | ✓ Supported | ✓ Supported |
| 100% stacked bar | ✓ SupportedCompare composition with percentage-stacked horizontal bars. | ✓ Supported | ✓ Supported |
| 3D bar | ✓ SupportedCompare categories and series with three-dimensional bars. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
| 3D stacked bar | ✓ SupportedShow stacked totals and composition with 3D projection. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
| 3D 100% stacked bar | ✓ SupportedShow percentage composition with 3D projection. | ✓ Supported | ✓ SupportedSupports three-dimensional appearances for column and bar charts. |
Line and area charts
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Line | ✓ SupportedShow trends with continuous lines. | ✓ Supported | ✓ Supported |
| 3D line | ✓ SupportedShow trends with lines in a 3D projection. | ✓ Supported | — Not supported |
| Area | ✓ SupportedShow values across categories with filled areas. | ✓ Supported | ✓ Supported |
| Stacked area | ✓ SupportedShow totals and series contributions with stacked areas. | ✓ Supported | ✓ Supported |
| 100% stacked area | ✓ SupportedShow changes in percentage composition. | ✓ Supported | ✓ Supported |
| 3D area | ✓ SupportedShow category values with filled areas in 3D projection. | ✓ Supported | — Not supported |
| 3D stacked area | ✓ SupportedShow totals and contributions with 3D projected stacked areas. | ✓ Supported | — Not supported |
| 3D 100% stacked area | ✓ SupportedShow percentage composition with 3D projected stacked areas. | ✓ Supported | — Not supported |
Pie and doughnut charts
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Pie | ✓ SupportedShow proportions as sectors. | ✓ Supported | ✓ Supported |
| Doughnut | ✓ SupportedShow proportions in a ring. | ✓ Supported | ✓ Supported |
| Pie of pie | ✓ SupportedSplit smaller sectors into a second pie. | ✓ Supported | — Not supported |
| Bar of pie | ✓ SupportedSplit smaller sectors into a secondary bar chart. | ✓ Supported | — Not supported |
| 3D pie | ✓ SupportedShow proportions as sectors with 3D projection. | ✓ Supported | ✓ Supported |
Scatter, bubble, and multiseries charts
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Scatter | ✓ SupportedShow relationships between two numeric variables. | ✓ Supported | ✓ Supported |
| Bubble | ✓ SupportedShow numeric dimensions through position and bubble size. | ✓ Supported | ✓ Supported |
| Radar | ✓ SupportedCompare data across multiple dimensions. | ✓ Supported | ✓ Supported |
| Combination | ✓ SupportedCombine column, line, or area series in one chart. | ✓ Supported | ✓ Supported |
Statistics and distributions
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Histogram | ✓ SupportedBin raw values to show frequency distributions. | ✓ Supported | ✓ Supported |
| Box plot | ✓ SupportedShow medians, quartiles, and data distributions. | ✓ Supported | ◐ PartialStock charts approximate boxes and whiskers; no dedicated box-and-whisker type. |
| Pareto | ✓ SupportedShow descending columns with a cumulative-percentage line. | ✓ Supported | ◐ PartialCombination charts with precomputed cumulative percentages approximate Pareto charts; no dedicated Pareto type. |
| Candlestick | ✓ SupportedShow price movements through open/high/low/close values. | ✓ SupportedSupports open-high-low-close stock charts. | ✓ SupportedSupports open-high-low-close stock charts. |
Hierarchy and process charts
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Treemap | ✓ SupportedShow hierarchy using nested rectangle areas. | ✓ Supported | ✓ Supported |
| Sunburst | ✓ SupportedShow hierarchy and proportions through nested rings. | ✓ Supported | — Not supported |
| Funnel | ✓ SupportedShow quantities across process stages. | ✓ Supported | — Not supported |
| Waterfall | ✓ SupportedShow how increases/decreases accumulate to a final result. | ✓ Supported | ✓ Supported |
Relationships and flows
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Graph | ✓ SupportedShow relationships through nodes and edges. | — Not supported | — Not supported |
| Sankey | ✓ SupportedShow flow between sources and destinations through link widths. | — Not supported | — Not supported |
| Chord | ✓ SupportedShow connections and flows between categories in a circle. | — Not supported | — Not supported |
Heatmaps, word clouds, and gauges
| Chart type and preview | Univer ChartsIndependent chart SDK · shared across products | Microsoft OfficeMicrosoft 365 · Windows desktop | Google WorkspaceWeb · includes official chart APIs |
|---|---|---|---|
| Heatmap | ✓ SupportedShow two-dimensional values through color intensity. | — Not supported | — Not supported |
| Word cloud | ✓ SupportedShow term weights through text size. | — Not supported | — Not supported |
| Gauge | ✓ SupportedShow a metric through a scale and pointer. | — Not supported | ✓ Supported |
Official documentation: Univer Charts · Microsoft Office · Google Workspace
How is this guide?