"Add Trendline" grayed out

[RBear3]

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?

 

[Andy Pope]

Hi,

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

Cheers
Andy

 

[RBear3]

Ok, that was it. BUT, I can't seem to add the trendline without showing the
series in the chart. How can I only display series 1 data, and use a
separate column of data to create a trendline (without showing each value on
my chart.

Thanks!!!!

RBear3
..

 

[RBear3]

Nevermind. I figured that out.

Thanks so much for your help!

 

[judit crankfield]

I am having similar problems. Not just data trending but data source option is grayed out. Don't know how to resolve this issue. Noticed that when I click my data series not all data points selected and I believe this is the root cause of the issue. But I don't know why is this happening

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng