To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

However, Microsoft Excel grants you the convenient option in Chart Tools to move this chart to a new sheet, which also enlarges it for easier viewing.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.