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
..