To select Here's what to do Multiple adjacent columns Position the cursor in the column header of the first column, and click and hold while you drag to select adjacent columns. Multiple adjacent rows Position the cursor in the row header of the first row, and click and hold while you drag to select adjacent rows.
Oct 19, 2018 - Change the data graphed in a chart by modifying the chart's cell references. Click the chart, click Edit Data References, then do any of the following in the. Add an entire row or column as a data series: Click its header cell. Click once on the pie chart in the plot area to select it. Click once on the Lemon slice of the pie chart to select just that section of the chart – make sure that only the lemon slice is surrounded by the small blue highlight dots. Click and drag the Lemon slice out from the pie chart to explode it.
Partial rows or columns Position the cursor in the top left cell, and click and hold while you drag to the bottom right cell. All content in a table Position the cursor anywhere in the table. All content in a named range Position the cursor anywhere in the named range. Tips:.
If your data is formatted as a table and you want to select nonadjacent information for a chart, first convert the table back to a normal range. Put the cursor in the table, and on the Table tab, select Convert to Range. To select Here's what to do Data in nonadjacent rows or columns Position your cursor in the first row or column.
Press COMMAND and select the other rows and columns you want. You can also do this by hiding the rows or columns in your worksheet. However, when you unhide the rows or columns, they will automatically show up in the chart.
Data in nonadjacent cells Position your cursor in the first cell. Press COMMAND and select the other cells you want. Create a summary worksheet to pull the data from multiple worksheets together, and create the chart from the summary worksheet. To create the summary worksheet, copy data from each source worksheet, and then on the Paste menu, select Paste Link. With Paste Link, when the data is updated on your source worksheets, the summary worksheet and chart will also be updated. For example, if you have one worksheet for each month, you could make a 13th worksheet for the entire year—that includes data from each of the monthly worksheets that you want for your chart.