How To Create A Graph In Excel. From your dashboard sheet, select the range of data for which you want to create a pie chart. To create a line chart,…