Create Chart sheet – MS Excel

A separate chart sheet in excel can be created. The sheet will only have chart.

Create Chart Sheet

  1. Select your chart for which you want to create separate chart sheet.
  2. Go to Design tab. Last option is Location with option Move.Create Chart Sheet
  3. Under option move select first option New sheet.Create Chart Sheet
  4. A new sheet with name Chart 1 will come up as required. Result will be as below.Create Chart Sheet MS Excel

In case you want to move your chart back to sheet, go Chart sheet select Move. This time select second opinion Object in, in drop down provide name of sheet you want your chart to move back to.