LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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



 
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
ADDING A TRENDLINE WHEN MAKING A CHART FROM A PIVOT TABLE leo Charts and Charting in Excel 1 May 2nd 07 03:57 PM
Adding Gridlines to an XY Scatter Area Chart [email protected] Charts and Charting in Excel 1 March 14th 07 01:03 AM
Adding lines of data to an area chart ahaigh Excel Discussion (Misc queries) 1 June 21st 06 09:25 PM
Adding Trendline To Just Some of the Bars in Chart Carroll Charts and Charting in Excel 2 February 27th 06 01:25 PM
Where is the "Chart Menu" for adding a trendline to a set of #s? Exceller In America Charts and Charting in Excel 1 August 5th 05 08:49 PM


All times are GMT +1. The time now is 02:32 AM.

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"