Charts and visuals
Charts
Select your data and choose a chart on the Insert tab, or press F11 for a chart of the selection. 8sheets draws every Excel chart family:
- column, bar, line, area, pie, doughnut, scatter, bubble, radar, stock and surface charts,
- 3D column, bar, line, area, pie and surface charts with perspective,
- combo charts with a secondary axis,
- treemap, sunburst, histogram, Pareto, box and whisker, waterfall and funnel,
- filled maps of countries and regions.
Charts have the familiar tools: Chart Design with quick layouts, chart styles and color schemes; Add Chart Element for titles, labels, legends, gridlines, data tables, trendlines and error bars; chart filters; and a Format pane for every element, with fills, gradients, patterns, pictures and effects. Click an element on the chart to select it, and click a title again to edit its text.
Charts can live on a sheet or on a chart sheet of their own, and charts from Excel files open, edit and save without losing their formatting.
Map shapes come from Natural Earth and are downloaded the first time a map is drawn. See Third-party notices.
Sparklines
Line, column and win/loss sparklines from Excel files are drawn and editable. 8sheets also has formula sparklines, a family of SPARK_ functions that draw small charts inside a cell from a formula.
Shapes, pictures and text
- 187 preset shapes and text warps, groups, connectors that stay attached, and alignment and distribution tools.
- Pictures from a file or a web address, with cropping, and pictures placed inside cells with
IMAGE. - Text boxes, WordArt, and an icon set based on Lucide.
- Form controls: buttons, check boxes, option buttons, list boxes, combo boxes, scroll bars and spinners linked to cells.
Cell types
Cells can show buttons, check boxes, dropdown lists, progress bars, hyperlinks and barcodes, set with the Cell Type button on the ribbon or from code.