Click in the top-right corner of the table to add a column, or drag it to add or delete multiple columns.

Restore an earlier version of a spreadsheetĪdd or delete a row or column at the edge of the table: Click in the bottom-left corner of the table to add a row, or drag it to add or delete multiple rows.

Save a large spreadsheet as a package file.

See the latest activity in a shared spreadsheet.

Place objects inside a text box or shape.

Format Chinese, Japanese, or Korean text.

Use a keyboard shortcut to apply a style.

Create, rename, or delete paragraph styles.

Bold, italic, underline, and strikethrough.

Format a spreadsheet for another language.

Select text and place the insertion point.

Change the look of chart text and labels.

Add a legend, gridlines, and other markings.

Add column, bar, line, area, pie, donut, and radar charts.

Calculate values using data in table cells.

Quickly calculate a sum, average, and more.

View the source data for a pivot table value.

Change how pivot table data is sorted, grouped, and more.

Add calculations to summarize group data.

Add checkboxes and other controls to cells.

Use VoiceOver to create formulas and autofill cells.

Intro to images, charts, and other objects.

The last button helps you filter the data in the chart. The second one lets you modify the style of the chart. The first button allows you to add elements. More options for customizing your chart are available when you select from three shortcut buttons to the right of the chart. If you would like to make changes to the column chart, use the Design tab. In the Charts group in the Ribbon, select Column.Īlternatively, you can choose “Recommended Rharts” and choose from a selection of frequently used charts. If not, press the CTRL key on your keyboard – or CMD if you’re using a Mac – and hold it down. If all your columns are next to each other, you can select them all in one go. Start by selecting all the data you want to include in your chart, making sure to include column titles and row headings.

This is very useful if you want to compare values, such as data from different years. This video will show you how to make clustered column charts in Excel. Excel Help - How to Create a Clustered Column Chart in Excel 2013

How to insert column in excel on mac