This will open the Move Chart dialog box, where you will be given two options – New sheet and Object in. If you’re on a Mac, click on Move Chart under the Chart Design tab. Under the Design tab, from the Location group, select the Move Chart button. Under Chart Tools, click on the Design tab. This will display a new set of tabs for the Chart Tools option on the ribbon. Select the chart by clicking anywhere on it. Select the tab of the worksheet containing the chart you want to move. This will be the sheet you want to move your chart to. Create a new sheet by clicking on the ‘+’ symbol at the bottom of the Excel window. Here’s how you can move it to another regular sheet: Let’s say you have a chart in a regular Excel sheet as shown below: Moving a Chart to a New Worksheet (or an Existing Worksheet) in Excel move a chart as an object in a new Excel Sheet.īesides using the Excel menus and tools, we will also see how you can use VBA code to move charts from all the sheets in a workbook to a single new sheet in Excel. 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.
0 kommentar(er)
