Question: how to transfer excel data to chart?
Answer: Open the Excel file that contains the data that you want to make into a chart.
Add column headers to your data, if applicable. ... 
Select any cell within the data field. ... 
Click on the "Insert" tab at the top of the Excel window. ... 
Click anywhere on the chart and select the "Design" tab at the top of the screen.