If you unhide the rows in the old table, you can see the rows are still there. Now the new table only contains the rows that were visible. Press Command-Shift-v to finish the move. ![]() ![]() Press Command-Shift-x to mark the data for move. 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. Select all the cells in the table with the hidden rows. 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. ![]() Click the chart, click Edit Data References, then do any of the following in the table containing the data:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |