How do I change the data selection in an Excel chart?

Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.

How do you select specific data for a chart?

Specify data ranges

  1. On the Insert tab, select the chart type you want.
  2. On the Chart Design tab, select Select Data.
  3. Click in the Chart data range box, and then select the data in your worksheet.

How do you create a chart from the selected range of cells?

Creating a chart

  1. Select the worksheet you want to work with.
  2. Select the cells you want to chart, including the column titles and row labels.
  3. Click the Insert tab.
  4. Hover over each Chart option in the Charts group to learn more about it.
  5. Select one of the Chart options.
  6. Select a type of chart from the list that appears.

How do I plot only certain rows in Excel?

How to get a graph to only plot certain data that meet a specific…

  1. Click Insert>pivotable>select your data range by dragging.
  2. Now you insert a pivot table to your new sheet, you can rename it.
  3. You can see a PivotTable Fields at right of the work sheet.

How do I select certain rows in Excel based on a cell value?

To select rows based on cell value:

  1. In the Grid view of an open table or worksheet, right-click the cell on which you want to base the row selection and point to Quick select where. The Trillion-Row Spreadsheet displays a list of selection options.
  2. Click the desired selection option.

How do you create an Excel chart with a dynamic range that you select?

Changing Source Data for the Chart to the Dynamic Named Range

  1. Right click on your chart and select “Select Data”.
  2. Under legend entries, click on edit.
  3. In series values, change range reference with named range “amount”.
  4. Click OK.
  5. In horizontal axis, click edit.
  6. Enter named range “months” for the axis label.
  7. Click Ok.

What is the fastest way to select a lot of data in Excel?

Click the first cell in the range you want to select. Scroll your sheet until you find the last cell in the range you want to select. Hold down your Shift key, and then click that cell. All the cells in the range are now selected.

How do you exclude data from a chart?

But even if you’re not using a Pivot chart, you can remove data points from a chart by filtering the data source. Use any of the filters in Autofilter and in the Chart source settings make sure that under Hidden and Empty Cells the option to Show data in hidden rows and columns is NOT selected.

How do I filter data in Excel graph?

Filter a Chart in Excel on Windows Select the chart and you’ll see buttons display to the right. Click the Chart Filters button (funnel icon). When the filter box opens, select the Values tab at the top. You can then expand and filter by Series, Categories, or both.

How do I select data in Excel without dragging?

To select a range of cells without dragging the mouse:

  1. Click in the cell which is to be one corner of the range of cells.
  2. Move the mouse to the opposite corner of the range of cells.
  3. Hold down the Shift key and click.

How do I select rows to contain specific text in Excel?

Show rows contain a specific string by Filter function

  1. Select the ranges you use, and click Data > Filter to enable the Filter function.
  2. Then click at the filter icon on the column you want to filter on, and select Text Filters > Contains.

How do I select large data in Excel without dragging?

A quick Excel keyboard trick for selecting large ranges

  1. Select A5.
  2. Press [F5].
  3. Enter C21 in the Reference field, but don’t click OK yet.
  4. Press and hold the [Shift] key.
  5. While holding down [Shift], click OK.