How do I draw a line equation in Excel

J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top