View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
RBear3 RBear3 is offline
external usenet poster
 
Posts: 10
Default Need help adding trendline to area chart

Thanks in advance!

I recently upgraded to Office 2007. I have a spreadsheet that looks like
this:

Column 1: Dates from January 1, 2008 through December 31, 2008
Column 2: Account balance goal for each day. Basically, this amount starts
at $130,000 and increases about $75 each day. I can look at this and see
what my balance should be for each date.
Column 3: Actual account balance as of this date. There are currently
entries for the first 14 days of the year, the rest are blank and will be
filled in at the end of each day.


Okay, I have an Area chart added to my spreadsheet. Series 1 data includes
the first and third column. Basically, it shows me the account balance for
each day in an area graph with the amounts up the left axis and the dates on
the bottom axis.

What I want to do is add a trend line that shows my daily goal for each
date. I did this many times before I upgraded, but I can't figure out how
to do it in 2007. I want the graph to look like a mountain (hopefully
growing larger each day) with a black line showing where each day's balance
should be. If I am doing well, the series one data would always be above
the trend line.

Can you tell me how to add the trend line? I have all the other elements
working fine. Thanks!!!

--
RBear3