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

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
.

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

"Andy Pope" wrote in message
...
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
.

Nevermind. I figured that out.

Thanks so much for your help!

--
RBear3
..

"Andy Pope" wrote in message
...
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
.

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