If the chart uses rows as series, then you can add only rows if it uses columns as series, then you can add only columns.Īdd data from a range of cells: Drag over the table cells.Īdd or remove data from an existing data series: Click the dot for the row or column, then drag the corner of the selection box to include the cells you want.Ĭhange the order of data series: In the Format sidebar, click the Series tab, click the disclosure arrow next to Data, then click the Order pop-up menu and choose a data series.Ĭhange the data that is plotted in a pivot chart: Click the dot for any column, then choose the Column, Row, or Value data you want to plot.Ĭlick Done in the bar at the bottom of the window. If the row or column doesn’t have a header cell, drag to select the cells. Remove a data series: Click the dot for the row or column you want to delete, then press Delete on your keyboard.Īdd an entire row or column as a data series: Click its header cell.

Restore an earlier version of a spreadsheetĬlick the chart, click Edit Data References, then do any of the following in the table containing the data:.

Save a large spreadsheet as a package file.

Place objects inside a text box or shape.

Format Chinese, Japanese, or Korean text.

Use a keyboard shortcut to apply a style Excel for Mac - When selecting data for charts on different sheet, selected cells rectangle is not shown When I'm selecting data fro XY chart, selected cells rectangle/area is shown only for the first time, when adding 'Series'.

Create, rename, or delete paragraph styles.

Bold, italic, underline, and strikethrough.

Format a spreadsheet for another language.

Select text and place the insertion point.

Add a legend, gridlines, and other markings.

Add column, bar, line, area, pie, donut, and radar charts A complete video tutorial on How to Make or Plot a Graph or Chart in Excel 2013.

Functions that accept conditions and wildcards as arguments.

String operator and wildcards in formulas.

Before she dives right in with creating her chart, Lucy should take some time to scroll through her data and fix any errors that she spotswhether it’s a digit that looks off, a month spelled incorrectly, or something else.

Quickly calculate a sum, average, and more How to build an Excel chart: A step-by-step Excel chart tutorial.

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

Add calculations to summarize group data.

Add checkboxes and other controls to cells.

Intro to images, charts, and other objects.

Select data for graph in excel mac