Enter the equation that appears on the chart in cell C1, but replace "X" with "A1." As an example, if the displayed equation is "y = 362.46x + 26259, enter "=362.46*A1+26356" without quotes in ...

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

The Pointy Haired Dilbert blog runs down the details of this nifty Excel trickery, which uses a formula and an image to conditionally show or hide the chart —neat stuff sure to impress the boss.

In Excel 2003, choose Chart from the Insert menu. We won’t actually use this graph, but it’s wise to create a default chart so you can see how well the chart window will accommodate the data.

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

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