Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Using Office/Excel 2003, is here a way to derive a formula from experimental
data plotted on a line graph? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Can I plot an equation in Excel instead of plotting data? | Charts and Charting in Excel | |||
Filter the way data is plotted | Charts and Charting in Excel | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |