Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
jwiam45
 
Posts: n/a
Default Derive an equation from plotted data

Using Office/Excel 2003, is here a way to derive a formula from experimental
data plotted on a line graph?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton
 
Posts: n/a
Default Derive an equation from plotted data

jwiam45 -

For equal-time-interval time sequence data, you could use a Line chart type.
For paired XY data, use an XY (Scatter) chart type.

Create the chart, click on a point to select the data series, and choose Add
Trendline from the Chart main menu or from right-click shortcut menu. Choose
a trendline form, and on the Options dialog check the box for displaying the
equation. On the chart, select the equation textbox, and click Increase
Decimal to show more significant digits.

Other methods besides Add Trendline are worksheet functions and the
Regression tool.

- Mike
www.mikemiddleton.com

"" wrote in message
...
Using Office/Excel 2003, is here a way to derive a formula from
experimental
data plotted on a line graph?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM
Can I plot an equation in Excel instead of plotting data? raechickx Charts and Charting in Excel 3 September 21st 05 11:49 PM
Filter the way data is plotted Lars Charts and Charting in Excel 3 May 4th 05 01:38 PM
Excel Charts - Data being Plotted beyond Primary X-Axis Scale Yvonne Fochesato Charts and Charting in Excel 1 May 1st 05 03:36 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"