Tables and charts

Put structured data on a slide and edit its values and appearance.

Insert and edit a table

Select Insert › Table. Click a cell to enter text. With the table selected, open Format Pane for table and cell controls. The Table cell section can insert or delete rows and columns, merge cells to the right or below, unmerge, and change text, fill, alignment, borders, padding and row or column size.

Table and Chart are both on the Insert ribbon.

The table workflow controls offer Select row, Select column, and Select table. Automatic sizing can keep fixed sizes, fit row heights to text, or fit the table to text. There are controls to fit slide width, fit selected rows or columns, distribute rows or columns, and apply a Table style. You can also insert copied rows or columns and split a selected cell into a specified number of rows and columns.

Insert a chart

Select Insert › Chart, then select the chart and open Format Pane. Under Chart, change its type, title, legend, labels and axis appearance. The type list includes column, bar, line, area, pie, doughnut, scatter, bubble, radar, stock, combo, waterfall, histogram, pareto, box and whisker, funnel, treemap and sunburst. Some controls only appear for compatible chart types.

Selecting a chart exposes its Chart tab and Format Pane command for further editing.

Under Chart data, choose a series, edit its name and values, and add or remove categories and series. Click an individual chart part on the slide when you want to format that title, legend, axis, series, point or data label. The Format Pane shows settings for the selected part, including a way to Restore automatic layout after moving a part.

For more involved data, the chart controls can Create editable workbook. The workbook editor lets you enter cell values or formulas, bind a range to categories or a series, paste tab-separated cells and Recalculate. If you link a local file, use its refresh controls to update values. A linked chart may restrict direct category or value edits until you detach its workbook or link.