Excel provides accessible tools to create a graph and display the linear equation. Customize your graph with Excel's built-in tools to display it in presentations, deliverables, press ...

Press "Enter" to get the equation for the first set of data. Type "LINEST (yrange,xrange,TRUE,FALSE)" into a second blank cell in your Excel spreadsheet.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.