A separate chart sheet in excel can be created. The sheet will only have chart.
Create Chart Sheet
- Select your chart for which you want to create separate chart sheet.
- Go to Design tab. Last option is Location with option Move.
- Under option move select first option New sheet.
- A new sheet with name Chart 1 will come up as required. Result will be as below.
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.