Excel Basics

Back to Physics Formulas and Derivations

  • Do not mix data types, only have words and letters or only numbers in each cell.
  • _____ vs. _____ translates to y-axis vs. x-axis
  • Have all data for one axis all in one column with no spaces
  • Data for x-axis on the left and data for y-axis on the right
  • Insert trendline with 'more' menu using the dark arrow at the top of the right-click menu and include the best fit equation. 
  • It is possible to switch the axes if data is switch when graph gets generated.