View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default How do I calculate a trendline?

Or use 2 plotting series, one containing all but the high an low (which will
form the basis for the trendline) and the second simply displaying the high
and low on the graph FYI

Jerry

"David Biddulph" wrote:

Look in Excel's Help at functions such as LINEST, LOGEST, and TREND.
--
David Biddulph

"anromath" wrote in message
...
I don't think I can use the system-generated one in my chart because my
boss
wants to drop the high and low values.