You can move a chart in a workbook from one sheet to another true or false

Want to get more out of Google Docs for work or school? Sign up for a Google Workspace trial at no charge.

If you create a custom dashboard, you can add a slicer to filter your tables, charts, or pivot tables.

Slicers

To get an example spreadsheet and follow along with the video, click “Make a Copy” below.

Make a copy

Add a slicer

1. On your computer, open a spreadsheet at sheets.google.com.
2. Click the chart or pivot table you want to filter.
3. At the top, click Data
   
   Add a slicer.
4. At the right, choose a column to filter by.
5. Click the slicer and choose your filter rules:
   • Filter by condition: Choose from a list of conditions or create your own.
   • Filter by values: Uncheck any data points that you want to hide. 

Delete a Slicer

1. Click the Slicer.
   • Press Delete or Backspace.
   • Click Menu 
     
      Delete slicer. 

Notes:

• You can use one slicer per column. To filter by more than one column, add multiple slicers.
• Slicers apply to all charts and pivot tables in a sheet that use the same data set.
• Slicers don’t apply to formulas in a sheet that use the same data set.
• If you add multiple slicers that use the same source data, make sure the range of each slicer is the same as the others.
• A slicer’s filter selections remain private and unsaved unless you .

Example slicer

Filters, filter views & slicers

Filters:

• Visibility: Visible to everyone who can access the spreadsheet. Filters remain in place until they're removed or changed.
• Reuse: Can’t be stored as templates for reuse. 
• Permissions: Anyone who can view the spreadsheet will see an applied filter, but you can’t apply or change a filter without edit access.

Filter views:

• Visibility: If you apply a filter view, only you can see it.
• Reuse: You can save multiple filter views. Anyone with access to the spreadsheet can see and apply saved filter views.
• Permissions: You need edit access to save filter views, but if you have view access, you can create temporary filter views.

Slicers:

• Visibility: Anyone with access to the spreadsheet can see and adjust filters on a slicer. When you apply a filter on a slicer, changes are only visible to you, unless you set them as default. 
• Reuse: Filters applied on a slicer can’t be saved for reuse, unless you set them as default. When you set filter selections as default, they'll be applied for everyone that has access to the spreadsheet. 
• Permissions: Everyone with access to the spreadsheet can see slicers, but you need edit access to add or remove a new slicer.

Edit your slicer

1. On your computer, open a spreadsheet at sheets.google.com.
2. To change the data range, column, or title of a slicer, click the slicer you want to change.
3. On the right side, click More
   
   Edit slicer.

To change the filter options, click Filter

Save your slicer filtering selections

To keep the filters you apply on your slicer after you close your spreadsheet, set them as default. If you share your spreadsheet with others, they'll see the default filters.

When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.

You can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources. For example, you might have a filter that only includes a specific region or product of interest. Rather than adding this filter every time you create a new worksheet, you can simply create the filter once and then apply it to multiple worksheets.

Watch a Video: To see related concepts demonstrated in Tableau, watch these free training videos: Additional filtering topics(Link opens in a new window) (7 minutes), Ways to Filter(Link opens in a new window) (2 minutes), Where Tableau Filters(Link opens in a new window) (4 minutes). Use your tableau.com(Link opens in a new window) account to sign in.

For more examples of global filters, also see The Global Filters Tab(Link opens in a new window) on Ryan Sleeper's(Link opens in a new window) website, and Dashboard Design: Adding Interactivity(Link opens in a new window) on the Interworks blog(Link opens in a new window).

Apply filters to all worksheets that use a related primary data source

This option applies the filter to all worksheets in the dashboard that use the same data source or related data sources as their primary data source.

Can a chart can be moved to a separate sheet?

What is the use of inserting charts in a worksheet Class 9?