View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default "Add Trendline" grayed out

Hi,

I would assume the current chart is a Stacked area where as the other chart
is a standard area chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RBear3" wrote in message
...
I have an excel chart. I have a column with each day of the year, a column
with the balance for an account for each day (up to today) and a third
column that contains the desired balance for each day of the year (through
the end of the year).

I created an area chart that shows the daily balance. I want a trendline
that shows the expected balance for each day. This will allow me to
visually see where I am, and if I am above or below the expected level.

When I try to "Add Trendline" the option is grayed out in my Chart menu.
Why?

I have this on a similar chart in another spreadsheet. Why can't I get it
to work here?

--
Thanks!

RBear3
.