Ways To Select Chart Items. Use Charts index where index is the chart-sheet index number or name to return a single Chart object. Starting with Excel 2016 youll need to hold down the control key when you use the arrow keys to select chart elements.
Here is the other method to add charts using Chart Object. We have data in the range A1B13. We can create a chart by pressing the only one key on the keyboard.
Click the chart item you want.
ChartsChartsCount is the last rightmost. Charts1 is the first leftmost chart in the workbook. Pressing the Tab key to cycle through the frames. Right-clicking an element and choosing an option from the Select submenu.