From data to chart in one step - Monday's Excel essential shortcut.From data to chart – Monday’s essential Excel shortcut

    1. Select the data. Include column and row labels in your selection and they will be used to label the chart.
    2. Press F11.

Done! The chart is created on a separate sheet in full page mode instead of embedded where the source data is.

Want to get more out of Excel? We run hands-on Excel training courses for teams, on-site or online, and build custom Excel solutions when you would rather hand the work over.