View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Excel Chart Trendlines and percentages of increase or decrease

If you want to know what percentage B1 is of A1, use the formula =B1/A1 and
format as percentage.
If you are wanting to calculate a different percentage, modify the formula
accordingly.
--
David Biddulph

"no trend wizard" <no trend wrote in
message ...
Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?