Insert an Excel chart sheet as the first sheet
How to insert a single Excel chart sheet as the first sheet using Excel, VBA and Shortcut methods
| 1. Right-click on the first sheet. 2. Click Insert. |
 |
| 3. Select Chart and click OK. |  |
Charts.Add Before:=Sheets(1)
'the 1 in Sheets(1) represents the first sheet in the workbook.
End Sub
Charts: The Charts object represents all of the chart sheets in a workbook, excluding worksheets.
Sheets: The Sheets object represents all of the sheets in a workbook, including worksheets and chart sheets.
METHOD 2. Insert an Excel chart sheet as the first worksheet using VBA
VBA
Charts.Add Before:=Worksheets(1)
'the 1 in Worksheets(1) represents the first worksheet in the workbook
End Sub
Charts: The Charts object represents all of the chart sheets in a workbook, excluding worksheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Minimum Number of Worksheets: The workbook must have at least one worksheet. Given a workbook can comprise either or both worksheets and/or chart sheets, and the VBA code is to insert a new chart sheet in front of the first worksheet there must be at least one worksheet that the VBA code can refer to and insert a new chart sheet in front of it. If a workbook comprises only chart sheets the VBA code will return an error stating "Subscript out of range".
METHOD 3. Insert an Excel worksheet as the first chart sheet using VBA
VBA
Charts.Add Before:=Charts(1)
'the 1 in Charts(1) represents the first chart sheet in the workbook
End Sub
Charts: The Charts object represents all of the chart sheets in a workbook, excluding worksheets.
PREREQUISITES
Minimum Number of Chart Sheets: The workbook must have at least one chart sheet. Given a workbook can comprise either or both worksheets and/or chart sheets, and the VBA code is to insert a new chart sheet in front of the first chart sheet there must be at least one chart sheet that the VBA code can refer to and insert a new chart sheet in front of it. If a workbook comprises only worksheets the VBA code will return an error stating "Subscript out of range".
NOTES
To insert a chart sheet as the first sheet using this shortcut you will need to have the first sheet selected when actioning this shortcut, given the shortcut inserts a new chart sheet in front of an active sheet. If you have a combination of worksheets and chart sheets and only want to insert the new chart sheet in front of a worksheet or a chart sheet using this shortcut, then you need to select the first worksheet or chart sheet and action the shortcut.
This tutorial explains and provides step by step instructions on how to insert a chart sheet as the first sheet using Excel, VBA and Shortcut methods.
Excel Methods: Using Excel you can insert a chart sheet as the first sheet by using a ribbon or sheet option.
VBA Methods: Using VBA you can insert a chart sheet as the first sheet, worksheet or chart sheet by referencing to a Sheets, Worksheets or Charts object, respectively. If you intend to insert a chart sheet as the first 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 chart sheet as the first worksheet or chart sheet, by having selected the first worksheet or chart sheet, respectively, and actioning the shotcut.