How can I select data and draw chart using a button in Excel?

Answer 1

To create a chart with a button,

First Select the dataset, and Press F11 on the keyboard.

After that your chart will appear in a new chart sheet.

Happy Learning !!!!