Skip to Main Content

Digital Scholarship Center: Excel: How To Convert Data Into A Chart/Graph

Information about the resources in the Digital Scholarship Center

Excel: How To Convert Data Into A Chart/Graph

Converting your data into a chart/graph is helpful for any school projects or assignments. Doing this is made easier with this tutorial. 


1: Open Microsoft Excel, Click the plus button to open a blank workbook.  


2: Enter the first group of data along with a title in column A. If you have more data groups, enter them accordingly in columns B, C, and so forth. 


3:Use your mouse to select the cells that contain the information for the table. 


4: Click the "Insert" tab and find the charts section



5: Depending on the type of graph you want to create, select the symbol representing the specific chart type. 


6: Symbol meanings (starting from top to bottom)

  • Bar graph
  • Line graph
  • Pie Chart
  • Tree Map
  • Histogram
  • Scatter Plot
  • Waterfall
  • Combo Graph



7: To add axis titles, data labels, legend, trendline, and more, click the graph you just created. A new tab titled "Chart design" should appear. In the upper menu of that tab, you should see a section called "add chart element." 



8: In "add chart element," you can customize your graph to your liking



STEP 9: Don't forget to save your work!