Charts

Overview

Data visualization is fundamental to analysis and communication in spreadsheet applications. These charting tools transform raw numeric and text data into visual representations that reveal patterns, trends, and relationships that might otherwise remain hidden in tables of numbers.

Chart Generation capabilities include line charts, bar charts, scatter plots, and specialized visualizations through the BASIC_CHART tool. Built on Matplotlib, Python’s foundational plotting library, these tools accept 2D numeric data and return PNG images encoded as base64 strings for direct embedding in spreadsheet cells or documents. The implementation handles axis scaling, labels, legends, and color schemes automatically while allowing customization when needed.

Word Cloud Generation via WORDCLOUD creates text-based visualizations where word size corresponds to frequency or importance. This is particularly useful for analyzing survey responses, document content, or any text corpus where identifying dominant themes quickly is valuable.

For basic chart types, specialized tools like LINE provide streamlined interfaces for common use cases, offering simpler parameters than the general-purpose chart generator while maintaining visual quality suitable for reports and presentations.

3d

Tool	Description
AREA_3D	Create a 3D filled area chart between two 3D lines.
BAR_3D	Create a 3D bar chart.
LINE_3D	Create a 3D line plot.
QUIVER_3D	Create a 3D quiver (vector) plot.
SCATTER_3D	Create a 3D scatter plot.
STEM_3D	Create a 3D stem plot.
SURFACE_3D	Create a 3D surface plot.
TRISURF_3D	Create a 3D triangular surface plot.
VOXELS	Create a 3D voxel plot from a 3D grid of values.
WIREFRAME_3D	Create a 3D wireframe plot.

Basic

Tool	Description
AREA	Create a filled area chart from data.
BAR	Create a bar chart (vertical or horizontal) from data.
GROUPED_BAR	Create a grouped/dodged bar chart from data.
LINE	Create a line chart from data.
PIE	Create a pie chart from data.
SCATTER	Create an XY scatter plot from data.
STACKED_BAR	Create a stacked bar chart from data.
STEP	Create a step plot from data.

Categorical

Tool	Description
DONUT	Create a donut chart from data.
DOT_PLOT	Create a Cleveland dot plot from data.
DUMBBELL	Create a dumbbell plot (range comparison) from data.
FUNNEL	Create a funnel chart for stages in a process.
PARETO_CHART	Create a Pareto chart (bar chart + cumulative line).
SLOPE	Create a slope chart for comparing paired changes across categories.
STEM	Create a stem/lollipop plot from data.
WATERFALL	Create a waterfall chart (change analysis) from data.

Matrix

Tool	Description
CLUSTER_MAP	Create a hierarchically-clustered heatmap.
CORRELATION	Create a correlation matrix heatmap from data.
HEATMAP	Create a heatmap from a matrix of data.
TRIANGULAR_HEATMAP	Create a lower or upper triangular heatmap.

Scientific

Tool	Description
BARBS	Plot a 2D field of wind barbs.
CONTOUR	Create a contour plot.
CONTOUR_FILLED	Create a filled contour plot.
LOGLOG	Create a log-log plot from data.
PCOLORMESH	Create a pseudocolor plot with a rectangular grid.
POLAR_BAR	Create a bar chart in polar coordinates (also known as a Rose diagram).
POLAR_LINE	Create a line plot in polar coordinates.
POLAR_SCATTER	Create a scatter plot in polar coordinates.
QUIVER	Create a quiver plot (vector field arrows).
RADAR	Create a radar (spider) chart.
SEMILOGX	Create a plot with a log-scale X-axis.
SEMILOGY	Create a plot with a log-scale Y-axis.
STREAMPLOT	Create a streamplot (vector field streamlines).
TRICONTOUR	Draw contour lines on an unstructured triangular grid.
TRICONTOUR_FILLED	Draw filled contour regions on an unstructured triangular grid.
TRIPCOLOR	Create a pseudocolor plot of an unstructured triangular grid.
TRIPLOT	Draw an unstructured triangular grid as lines and/or markers.

Specialty

Tool	Description
BULLET	Create a bullet chart for visual comparison against a target.
GANTT	Create a Gantt chart (timeline of tasks).
GAUGE	Create a speedometer/gauge style chart.
SANKEY	Create a Sankey flow diagram.
TABLE	Render data as a graphical table image.
WORDCLOUD	Generates a word cloud image from provided text data and returns a PNG image as a base64 string.

Statistical

Tool	Description
BOXPLOT	Create a box-and-whisker plot from data.
DENDROGRAM	Performs hierarchical (agglomerative) clustering and returns a dendrogram as an image.
DENSITY	Create a Kernel Density Estimate (KDE) plot.
ECDF	Create an Empirical Cumulative Distribution Function plot.
ERRORBAR	Create an XY plot with error bars.
EVENTPLOT	Create a spike raster or event plot from data.
HEXBIN	Create a hexagonal binning plot from data.
HIST2D	Create a 2D histogram plot from data.
HISTOGRAM	Create a frequency distribution histogram from data.
VIOLIN	Create a violin plot from data.