How do I draw a line equation in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Arda -

In one column, list the relevant X values (minimum to maximum at an
appropriate spacing). Supposing you used column A, with the first X
value in A2, enter this formula in B2:

=100*2.71^(0,231*A2)

Don't know what exactly the comma means, mixed decimal indicator?
Anyway, copy this formula down column B as far as the X values reach in
column A. Select this data, and make an XY Scatter chart (no, not a line
chart). Double click the different elements of the chart to format them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top