When you first create a chart in Microsoft Excel, it is placed in the currently focused worksheet. The default position may be convenient for referencing existing data while viewing the chart, but it can also be cramped on a data-inundated page. 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.
Click anywhere on the chart. This opens the Chart Tools at the top of the window.
Click "Move Chart" at the far right of the Chart Tools section.
Click "New Sheet" and enter the name for your new sheet in the field provided.
Click "OK" to move the chart to a new sheet.