LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hanbotkot
 
Posts: n/a
Default How do I write a trendline constant into a cell?

Trendline equation constants.

A trendline has been drawn on a chart and an acceptable equation has been
obtained. The constants in this equation must be used in other formulas.

How are these constants written into cells that can be used in formulas?

This is needed when the data producing a trendline, can change and thus have
an effect through the page.
 
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
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
R² expression for trendline in chart jean Charts and Charting in Excel 1 December 23rd 04 07:51 AM
Cell value as chart scale maximum Phil Hageman Charts and Charting in Excel 9 December 17th 04 02:09 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM
Trendline error??? Eugepticus Charts and Charting in Excel 3 November 30th 04 04:40 AM


All times are GMT +1. The time now is 04:02 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"