Trendline
I'm attempting to add a trendline to a series of data points in Excell 2007.
But the trendline button is not highlighted and therefore not useful. Is there a problem with the spreadsheet or has anybody encountered this and knows of a fix? |
Trendline
What type of chart (XY/scatter; Line; column) ?
Can you give us some of the data you used? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "JerryB" wrote in message ... I'm attempting to add a trendline to a series of data points in Excell 2007. But the trendline button is not highlighted and therefore not useful. Is there a problem with the spreadsheet or has anybody encountered this and knows of a fix? |
Trendline
Did you select the series first?
In article , JerryB wrote: I'm attempting to add a trendline to a series of data points in Excell 2007. But the trendline button is not highlighted and therefore not useful. Is there a problem with the spreadsheet or has anybody encountered this and knows of a fix? |
Trendline
Hi,
Excel does not allow trendlines on certain chart types for example 3 D charts, what type of chart are you using? -- If this helps, please click the Yes button Cheers, Shane Devenshire "JerryB" wrote: I'm attempting to add a trendline to a series of data points in Excell 2007. But the trendline button is not highlighted and therefore not useful. Is there a problem with the spreadsheet or has anybody encountered this and knows of a fix? |
Trendline
It is a line chart and yes a series was checked.
"Shane Devenshire" wrote: Hi, Excel does not allow trendlines on certain chart types for example 3 D charts, what type of chart are you using? -- If this helps, please click the Yes button Cheers, Shane Devenshire "JerryB" wrote: I'm attempting to add a trendline to a series of data points in Excell 2007. But the trendline button is not highlighted and therefore not useful. Is there a problem with the spreadsheet or has anybody encountered this and knows of a fix? |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com