Excel Guides

Excluding some data from a chart in Excel

When creating a chart in Excel, you may want to exclude some data from the chart. For example, you may have a column of data that contains outliers that you don't want to include in the chart. Or, you may have a row of data that represents totals for each month, but you only want to include the data for the current year in the chart.

There are a few different ways that you can exclude data from a chart in Excel. One way is to simply select the data that you want to include in the chart, and then create the chart. This will exclude any data that is not selected. Another way is to use a filter on the data before creating the chart. This will allow you to select which data is included in the chart, and which is excluded.

If you want to exclude some data from a chart after it has been created, you can do so by selecting the data that you want to exclude and then deleting it. This will remove the data from the chart, but it will still be present in the worksheet. You can also use filters to hide specific data points from a chart.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.