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 ...

Click the "Trend Lines" option and select "Linear." Select the two "Equations" options to display the linear regression equation and r-squared value on your chart.

By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won’t display that data in a chart. For instance, it’s obvious from a quick look at the ...

To transform the display from data to formulas (see screenshot below) press Ctrl+~ (tilde). Toggle back to the data view by pressing those keys again. If you wish, you can print the worksheet, with or ...

You could leave the chart as is, as a combo chart, as shown in Figure D, but let’s remove the lines so it’s strictly a floating bar chart. Figure D To finish the Excel chart, delete the lines.