Insert an Excel chart sheet before a specific sheet

How to insert a single Excel chart sheet before a specific sheet using Excel, VBA and Shortcut methods

METHOD 1. Insert an Excel chart sheet before a specific sheet using sheet option

EXCEL

Right-click on a specific sheet > Insert > Chart > OK

1. Right-click on a specific sheet before which you want to insert a new chart sheet.
2. Click Insert.
Note: in this example a new chart sheet will be inserted in front of Sheet2, given we have right-clicked on Sheet2.		 Right-click on a specific sheet and select Insert - Excel

3. Select Chart and click OK. Select Chart and click OK - Excel

METHOD 1. Insert an Excel chart sheet before a specific sheet using VBA

VBA

Sub Insert_Chart_Sheet_Before_a_Specific_Sheet()
'insert a new chart sheet before a sheet named Data
Charts.Add Before:=Sheets("Data")

End Sub

OBJECTS
Charts: The Charts object is a collection of all chart sheets.
Sheets: The Sheets object is a collection of all sheets in a workbook, including worksheets and chart sheets.
PREREQUISITES
Sheet Name: Have a sheet named Data, this can be either a worksheet or a chart sheet.

ADJUSTABLE PARAMETERS
Sheet Name: Select the sheet before which you want to insert a new chart sheet by changing the Data sheet name in the VBA code to any sheet in the workbook.

METHOD 2. Insert an Excel chart sheet before a specific worksheet using VBA

VBA

Sub Insert_Chart_Sheet_Before_a_Specific_Worksheet()
'insert a new chart sheet before a worksheet named Data
Charts.Add Before:=Worksheets("Data")

End Sub

OBJECTS
Charts: The Charts object is a collection of all chart sheets.
Worksheets: The Worksheets object is a collection of all sheets in a workbook, except for chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Data.

ADJUSTABLE PARAMETERS
Worksheet Name: Select the worksheet before which you want to insert a new chart sheet by changing the Data worksheet name in the VBA code to any worksheet in the workbook.

METHOD 3. Insert an Excel chart sheet before a specific chart sheet using VBA

VBA

Sub Insert_Chart_Sheet_Before_a_Specific_Chart_Sheet()
'insert a new chart sheet before a chart sheet named Analysis Chart
Charts.Add Before:=Charts("Analysis Chart")

End Sub

OBJECTS
Charts: The Charts object is a collection of all chart sheets.
PREREQUISITES
Chart Sheet Name: Have a chart sheet named Analysis Chart.

ADJUSTABLE PARAMETERS
Chart Sheet Name: Select the chart sheet before which you want to insert a new chart sheet by changing the Analysis Chart chart sheet name in the VBA code to any chart sheet in the workbook.

Insert a chart sheet before a specific sheet using a Shortcut

SHORTCUT

WINDOWS SHORTCUT

F11

NOTES
The shortcut will insert a new chart sheet in front of an active sheet. Therefore, you need to activate (select) the sheet in front of which you want to insert a new chart sheet and then action the shortcut.

Explanation about how to insert a chart sheet before a specific sheet

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to insert a single chart sheet before a specific sheet using Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can insert a new chart sheet before a specific sheet with a sheet option.

VBA Methods: Using VBA you can insert a new chart sheet before a specific sheet, worksheet or chart sheet by referencing to a Sheets, Worksheets or Charts object, respectively. If you intend to insert a chart sheet before a specific worksheet or a chart sheet you will need to have at least one worksheet or chart sheet, respectively, in a workbook.

Shortcut Method: Using a Shortcut you can instantly insert a new chart sheet in front a specific sheet by activating (selecting) the sheet in front of which you want to insert a new chart sheet.

ADDITIONAL NOTES
Note 1: Using the sheet option, a new chart sheet will be inserted in front of the active sheet.