Cuc Tu
02-03-2012, 05:14 PM
I'm trying to show the growth in Web traffic on our site and Excel's trendline is not showing me what I want.
The goal is to set a benchmark and then achieve 5% growth by end of year. The benchmark is the traffic for the month of May. I have copied the number of page views for each month below, along with a percentage growth calculation.
May 93 0.00%
June 108 16.13%
July 94 1.08%
August 175 88.17%
September 116 24.73%
October 93 0.00%
November 77 -17.20%
December 126 35.48%
January 109 17.20%
The goal is to set a benchmark and then achieve 5% growth by end of year. The benchmark is the traffic for the month of May. I have copied the number of page views for each month below, along with a percentage growth calculation.
May 93 0.00%
June 108 16.13%
July 94 1.08%
August 175 88.17%
September 116 24.73%
October 93 0.00%
November 77 -17.20%
December 126 35.48%
January 109 17.20%