Insert a ChartSheet with a chart (using selected data)

Master this Excel shortcut with our comprehensive guide

Charting Shortcuts F11 ⌘ + Option + F11

F11

1. Select the dataset
2. Press F11
3. Excel creates a new ChartSheet with the chart displayed on a separate tab

⌘ + Option + F11

1. Highlight the data
2. Press Command + Option + F11
3. A new ChartSheet tab opens with the chart

💡 Pro Tip: Use ChartSheet when you want a dedicated sheet just for visualizing data.

Insert chart in the works...

Alt + F1