Excel Scatter Plot With Filters: How to Set It Up

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, create a scatter chart from an Excel Table, then filter the table with its column dropdowns or a slicer; the chart will normally show only the visible rows. If the plotted points do not change, check that the chart uses the table data and that Excel is not set to plot data in hidden rows.

How filters affect a scatter chart

A scatter plot positions each observation using a numeric X value and a numeric Y value. Filtering the source records lets you focus on a subset—for example, compare advertising spend with sales for one region, product type, or date range—without rebuilding the chart each time.

Excel charts generally omit rows hidden by a worksheet filter. An Excel Table makes this behavior convenient: its filter controls hide records that do not match, and a chart tied to the table can redraw from the remaining visible records. A slicer filters table rows in much the same way, but offers clickable buttons instead of dropdown menus.

There is an important distinction between filtering the data and filtering the chart. A regular scatter chart can respond to filtered source rows, but it is not a PivotChart. Excel PivotCharts do not offer the XY scatter chart type, so a workflow that depends on a PivotChart is not the right route for a true scatter plot.

Prepare the source data

Set up one row per observation, with clear headers and separate columns for the two numeric measures and any fields you want to filter. For instance, a sales analysis might have Month, Advertising Spend, Sales, Region, and Product. Spend supplies X, Sales supplies Y, and Region or Product can be used as filters.

  • Keep X and Y values numeric. Text that looks like a number, error values, and blank cells can lead to missing or unexpected points.
  • Use one consistent unit in each measurement column, such as dollars for spend and units sold for sales.
  • Avoid blank rows inside the dataset, merged cells, and duplicate or missing header names.
  • Include the filter fields in the same table as the X and Y values. A separate list of regions cannot filter the chart unless it is connected through another mechanism.

Click a cell in the dataset and choose Insert > Table. Confirm that My table has headers is selected, then choose OK. Excel Tables expand when new records are added and provide built-in filters. Give the table a useful name on the Table Design tab if the workbook contains several tables; this makes the chart’s data source easier to identify.

Create the scatter plot

For a simple dataset with the X and Y columns beside each other, select their numeric values and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Choose the marker-only scatter option when you want to show individual observations. The straight-line and smooth-line options connect points and are more suitable when the order of observations has meaning.

If the X and Y columns are separated by other fields, or Excel assigns the wrong values to an axis, create or correct the series explicitly:

  1. Click the chart, then choose Chart Design > Select Data.
  2. Choose Add to create a series, or select an existing series and choose Edit.
  3. Set Series X values to the numeric X cells and Series Y values to the corresponding numeric Y cells. Select data rows only, not the header cells.
  4. Confirm the dialogs, then use Chart Design > Add Chart Element to add axis titles and a chart title if needed.

The X and Y ranges must contain matching observations in matching row order. If an X value is paired with the wrong Y value, the point is still plotted, but it represents a false relationship. A useful check is to select one record in the table and verify that its coordinates make sense on the chart.

Filter with table dropdowns

Once the chart is based on the table’s X and Y columns, use the dropdown arrow in a filter-field header. For example, open the Region filter, clear Select All, select West, and apply the filter. The table displays only matching rows, and the scatter plot should show the West observations. You can filter more than one field at once, such as Region and Product, to narrow the view further.

For a date field, use its dropdown to choose a date range or specific dates. For numeric filter fields, Excel also offers number-filter conditions such as greater than or between. These filters affect which records are visible; they do not change the underlying values. Clear a filter from its header dropdown when you want to restore all records.

Filters are useful for quick exploration, but they are less obvious to a reader than labeled controls. If other people will use the workbook, explain which table columns control the chart, or use slicers for the most important categories.

Add slicers for clickable filtering

A slicer is a visual filter containing buttons for values such as East, West, and Central. To add one, click inside the table, choose Table Design > Insert Slicer, select a field such as Region, and choose OK. Place the slicer near the chart. Clicking a button filters the table and, when the chart uses those table rows and hidden rows are excluded, updates the plotted points. Use the slicer’s clear-filter control to return to all values.

You can add separate slicers for different fields, such as Region and Product. A slicer can also allow multiple selections; use its multi-select control or the standard Ctrl-click interaction where available. Slicers take up worksheet space, so choose fields whose values are useful to compare and avoid adding a control for every column.

Table slicers and PivotTable slicers are not interchangeable. A slicer inserted for a table filters that table. PivotTable slicers can be connected to compatible PivotTables, but they do not turn an ordinary scatter chart into a PivotChart or automatically filter an unrelated table. If the chart remains unchanged, first verify that it draws from the filtered table.

Choose between filtering methods

Use the method that matches how the chart will be explored. For a personal analysis, a table dropdown is quick and needs no extra controls. For a dashboard where viewers should click a category, a table slicer is more discoverable. For a chart that needs a specific custom subset, a separate helper dataset can be appropriate, but it requires more setup and care to keep its criteria and chart ranges aligned.

  • Table dropdowns: best for ad hoc filtering, many possible filter fields, and compact worksheets.
  • Table slicers: best for a small number of visible categorical filters and interactive dashboards.
  • Separate helper data: best when the displayed records follow custom criteria or need to remain independent of the main table’s visible filter state.

A regular chart’s Chart Filters button is not the same as a table filter. It can control which chart series or categories appear, but scatter chart points do not behave like a list of category labels in every filtering scenario. For record-level filtering, filter the source table or provide a deliberately constructed subset of its rows.

Check hidden-row settings and troubleshoot

If filtering the table does not change the scatter plot, confirm the data source and chart settings before recreating anything. Select the chart and choose Chart Design > Select Data. Check that the X and Y series refer to the intended table columns and that they cover the same records. A chart created from a copied range or a different worksheet range will not necessarily respond to the table’s filter.

In the Select Data Source dialog, choose Hidden and Empty Cells. Make sure Show data in hidden rows and columns is not selected if you want filtered-out rows omitted. When that option is enabled, Excel can include data from hidden rows, so the chart may continue to show points that the table filter removed. The option is useful when you intentionally want a chart to include hidden data, but usually conflicts with filter-driven plotting.

  • Points disappear unexpectedly: check for blank or text-formatted X/Y cells, then inspect the series ranges.
  • The chart does not react: check that the filter is applied to the source table and that the chart is not using a separate static copy.
  • Only one point or series appears: edit the series and confirm that X and Y ranges include all data rows, not only the first row.
  • A slicer has no effect: confirm that it belongs to the same table used by the chart, rather than to an unrelated PivotTable or table.
  • New records are missing: add them within the table or expand the table, then check whether the series source includes the added rows.

On Excel for Mac, the same general approach applies, although ribbon placement and dialog appearance can differ slightly by release. Excel for the web can display and filter many workbook features, but if a chart or slicer control is unavailable in your current interface, open the workbook in the desktop app to configure it.

Make the filtered chart easier to read

Filtering can change the range and density of the plotted points, so check the axes after trying several selections. Automatic axis scaling may make a small subset fill the chart, which helps reveal detail but makes comparisons between different filter selections harder. Fixed axis limits make those comparisons more consistent, provided the chosen limits still show the relevant data.

Use descriptive axis titles with units, such as Advertising spend (USD) and Sales (units). If points overlap heavily, consider smaller markers or partial transparency in the series formatting. If the points represent different groups, use separate series only when comparing those groups is meaningful; too many colors can make the chart harder to interpret. A chart title or nearby note can also state that the view reflects the current table filters.

Remember that a filtered scatter plot shows an association in the selected records, not proof that one measure causes the other. A region or date filter can change the apparent pattern because it changes which observations are included. Keep that context in mind when sharing screenshots or drawing conclusions.

Frequently Asked Questions

Will an Excel scatter plot update when I filter a table?
Usually, yes, if the chart series use the table’s data and Excel is set to omit hidden rows. If it does not update, inspect the series ranges and the Show data in hidden rows and columns setting.

Can I use a slicer to filter a scatter chart?
Yes. Add a slicer to the Excel Table that supplies the chart, then use it to filter the table rows. The chart must be linked to that table data; a slicer connected to an unrelated PivotTable will not filter it.

Can I make an Excel PivotChart into a scatter plot?
No. Excel PivotCharts do not support the XY scatter chart type. Use a regular scatter chart connected to a filtered table, or build a separate subset of data for the chart.

Why does my chart still show filtered-out points?
The chart may be set to include hidden rows, or it may reference a range other than the filtered table. Check Chart Design > Select Data and the Hidden and Empty Cells setting.

Can I filter a scatter plot by a date range?
Yes. Include a date column in the source table and filter it using the table’s date dropdown. The chart will then display the observations whose rows remain visible, as long as its source and hidden-row settings are correct.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.