Tabulys guide

Charts

Turn a range into a chart and keep it in sync with your data.

Insert a chart

  1. Select the range of data to chart, including any header labels.
  2. In the menu, open the submenu of a family, such as Column or Bar Chart, and pick a basic type.
  3. The chart appears as a floating overlay anchored to the cells.
  4. Click the chart to select it, showing an accent border and handles.

Tip Charts re-read their values from the cells, so they update when the data recalculates.

Move, resize and edit

  1. Click a chart once to select it; drag the body to move it or a handle to resize it.
  2. Use Add Element for the title, axis titles, legend, data labels, gridlines and trendline; Change Type to switch chart type; Select Data to repoint the range or switch rows/columns; Series Colors to recolour a series.
  3. Click Format Pane, or double-click the chart, to edit every element live in a side panel.
  4. The chart re-reads the source cells, so it updates on the next recalculation.

Tip Every edit is a single undo step and round-trips losslessly to the chart part of the .xlsx file.

Chart types

  1. Select your data range.
  2. In the menu, each chart family offers its types, in its own submenu or in the items that follow it.
  3. Column or Bar: clustered, stacked and 100% stacked columns/bars, plus Clustered Column - Line combos.
  4. Line or Area: line/stacked/100%/with-markers, area/stacked/100%, and radar/with-markers/filled.
  5. Pie or Doughnut; Scatter (XY)/smooth/Bubble; Hierarchy: Treemap and Sunburst; Waterfall, Funnel, Stock, Histogram, Pareto and Box & Whisker.
  6. Insert the chart of the chosen type from the current selection.

Tip All chart types are insertable: classic types (with stacked and 100% variants), combo, stock, and the modern types (treemap, sunburst, histogram, Pareto, waterfall, funnel, box & whisker). Maps need online geographic data and stay disabled.

Change colours, error bars and scatter

You can recolour the whole chart from a palette, add error bars to every series, and convert a category chart to an XY scatter.

  1. Select the chart.
  2. Open Change Colors and pick one of the ten palettes (Colorful 1–4 or Monochromatic 1–6): the series — or the slices of a pie or doughnut — are recoloured from the workbook theme's accent colours.
  3. Open Error Bars and choose None, Percentage (5%), Fixed value (1), Plus only or Minus only: Y-direction whiskers with caps are drawn on every series of a column, bar, line or scatter chart.
  4. To turn a category chart into an XY chart, open Change Type and choose Scatter: the categories become the X axis and the values the Y axis, keeping each series' colour, marker and name.
  5. Every command is a single undo step and round-trips losslessly to the chart part of the .xlsx file.

Tip To insert a scatter (XY) chart directly, pick a type from the Scatter Chart submenu. A palette bakes the colours in at apply time, so changing the theme afterwards does not recolour the chart.

PivotChart

  1. Select your data, then in the PivotChart submenu choose PivotChart & PivotTable to create a PivotTable and a linked chart together.
  2. With the cell cursor inside a PivotTable, click PivotChart to chart the existing pivot.
  3. The chart's source is the pivot: when you reconfigure fields, group, filter or refresh the pivot, the chart updates automatically.
  4. Field buttons on the chart (report filters top-left, axis fields bottom-left, legend fields bottom-right) open the same filter dropdown and filter the pivot.
  5. The default type is a clustered column; change it with the Chart Tools like any chart.

Tip The pivot↔chart link round-trips losslessly, and inserting a PivotChart is a single undo step.

Change, group and clear sparklines

Sparklines inserted together form a sparkline group that shares the type, highlighted points, colours and axis: changing one changes them all. Right-click a cell with a sparkline to edit them, change the data they draw, join or split them, and remove them.

  1. Right-click a cell that contains a sparkline.
  2. Choose Edit Sparkline… to change the type (Line, Column or Win/Loss), the markers, the highlighted points, the colours, the empty cells and the axis: the choice applies to the whole sparkline group.
  3. Choose Edit Data… to change the data range or the cells that show the sparklines: the new ones keep the format of the sparkline group they replace.
  4. Select cells from several sparkline groups and choose Group to make them one, with the format of the first; Ungroup makes each sparkline in the selection independent.
  5. Choose Clear Sparkline to remove the sparklines from the selected cells, or Clear Sparkline Group to remove every sparkline group the selection touches.

Tip Every change is a single undo step. On a protected sheet, sparklines can be changed only if the protection allows formatting cells.

Back to the guide

Productivity, made in Italy.

Bring the whole suite to your team — simple, secure and entirely yours.