Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't add trendline in Excel 2007
I have created a simple two line chart and I'm trying to add a trendline to
both, however, under layout tab, the trendline box is greyed out (under analysis) preventing me from selecting the type of trendline that I want to add (linear). I checked the Microsoft site related to adding trendlines in Excel 2007 to no avail as the steps provided is what I'm trying to do and still the trendline box is greyed out. Any assistance that can be provided would be much appreciated. Thanks, Lionel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't add trendline in Excel 2007
Hi,
Double check the chart type. A stacked line chart will not allow trendlines. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Lionel" wrote in message ... I have created a simple two line chart and I'm trying to add a trendline to both, however, under layout tab, the trendline box is greyed out (under analysis) preventing me from selecting the type of trendline that I want to add (linear). I checked the Microsoft site related to adding trendlines in Excel 2007 to no avail as the steps provided is what I'm trying to do and still the trendline box is greyed out. Any assistance that can be provided would be much appreciated. Thanks, Lionel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't add trendline in Excel 2007
Thanks Andy - appreciate your response.
Regards, Lionel "Andy Pope" wrote: Hi, Double check the chart type. A stacked line chart will not allow trendlines. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Lionel" wrote in message ... I have created a simple two line chart and I'm trying to add a trendline to both, however, under layout tab, the trendline box is greyed out (under analysis) preventing me from selecting the type of trendline that I want to add (linear). I checked the Microsoft site related to adding trendlines in Excel 2007 to no avail as the steps provided is what I'm trying to do and still the trendline box is greyed out. Any assistance that can be provided would be much appreciated. Thanks, Lionel . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't add trendline in Excel 2007
On Tuesday, 1 December 2009 14:53:33 UTC, Andy Pope wrote:
Hi, Double check the chart type. A stacked line chart will not allow trendlines. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Lionel" wrote in message ... I have created a simple two line chart and I'm trying to add a trendline to both, however, under layout tab, the trendline box is greyed out (under analysis) preventing me from selecting the type of trendline that I want to add (linear). I checked the Microsoft site related to adding trendlines in Excel 2007 to no avail as the steps provided is what I'm trying to do and still the trendline box is greyed out. Any assistance that can be provided would be much appreciated. Thanks, Lionel Spot on! - Thanks. No idea why one can't add a trendline to a stacked graph, but you're right (albeit 8 years ago :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Polynomial trendline order in Excel 2007 | Charts and Charting in Excel | |||
How to add a trendline in Excel 2007 | Charts and Charting in Excel | |||
how to: polynomial regression trendline excel 2007 | Charts and Charting in Excel | |||
excel 2007 trendline equation | Charts and Charting in Excel | |||
Trendline Equation error Excel 2007? | Charts and Charting in Excel |