You can, however, move a chart object to a chart sheet and vice-versa. You will find all the resizing options for it disabled.

It usually takes up the entire space of the sheet and you have to make peace with that. Instead, it contains a chart.īoth the above types of sheets have different properties, and as such, you cannot perform the same actions on both.įor example, you cannot resize a chart on a chart sheet. The difference is that the sheet does not have cells and gridlines like a regular sheet. A chart sheet is a separate sheet in your workbook, that looks similar to any other worksheet (it has a separate tab at the bottom of the Excel window).It is embedded in and as part of a regular worksheet. A chart object is basically a graphical object, just like any other Excel object ( like pictures, shapes, etc.).Moving a Chart to a New Worksheet (or an Existing Worksheet) in Excelĭifference between a Chart Object and a Chart SheetĬharts can be displayed either within a chart object of a regular sheet or within its own chart sheet.Difference between a Chart Object and a Chart Sheet.

How to make a pie chart in excel on mac