From data to chart – Monday’s essential Excel shortcut
- Select the data. Include column and row labels in your selection and they will be used to label the chart.
- Press F11.
Done! The chart is created on a separate sheet in full page mode instead of embedded where the source data is.