If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to add a trendline in Excel 2007
I was once an expert, guru even, helped everybody. Now I can't even find the
help menu. So very frustrating. I have a graph and need to add a trendline. The graph is embedded in a worksheet sitting alongside four other graphs that have trendlines i created with Excel 2003. Trendline is no longer a simple check box on a screen that i can get to. I see it on one of the menus, Trendline, all nice and pretty grey. There's no help on trendline using F1 key, other than giving the formulas. On-line I find instructions on how to add a trendline, duh, and the trendline option is grey. Would anyone mind trying to assess how I've become so incompetent so quickly, and tell me what I'm doing wrong? |
#2
|
|||
|
|||
How to add a trendline in Excel 2007
Click the data series in the chart
Look in Chart Tools | Layout | Analysis for Trendline Click the launcher (triangle pointing down) ; select the type of trendline needed Open the "More Trendline Options" to add equation. etc best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rookie Roger" wrote in message ... I was once an expert, guru even, helped everybody. Now I can't even find the help menu. So very frustrating. I have a graph and need to add a trendline. The graph is embedded in a worksheet sitting alongside four other graphs that have trendlines i created with Excel 2003. Trendline is no longer a simple check box on a screen that i can get to. I see it on one of the menus, Trendline, all nice and pretty grey. There's no help on trendline using F1 key, other than giving the formulas. On-line I find instructions on how to add a trendline, duh, and the trendline option is grey. Would anyone mind trying to assess how I've become so incompetent so quickly, and tell me what I'm doing wrong? |
#3
|
|||
|
|||
How to add a trendline in Excel 2007
That launcher is greyed out just like the trendline button, so I can't click
either one. I tried to install an Add-On of Data Analysis tools but that didn't change anything (and I didn't need it in the past.) "Bernard Liengme" wrote: Click the data series in the chart Look in Chart Tools | Layout | Analysis for Trendline Click the launcher (triangle pointing down) ; select the type of trendline needed Open the "More Trendline Options" to add equation. etc best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rookie Roger" wrote in message ... I was once an expert, guru even, helped everybody. Now I can't even find the help menu. So very frustrating. I have a graph and need to add a trendline. The graph is embedded in a worksheet sitting alongside four other graphs that have trendlines i created with Excel 2003. Trendline is no longer a simple check box on a screen that i can get to. I see it on one of the menus, Trendline, all nice and pretty grey. There's no help on trendline using F1 key, other than giving the formulas. On-line I find instructions on how to add a trendline, duh, and the trendline option is grey. Would anyone mind trying to assess how I've become so incompetent so quickly, and tell me what I'm doing wrong? |
#4
|
|||
|
|||
How to add a trendline in Excel 2007
The ATP has nothing to do with trendlines
What type of chart are you making? I am sure we can resolve this -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rookie Roger" wrote in message ... That launcher is greyed out just like the trendline button, so I can't click either one. I tried to install an Add-On of Data Analysis tools but that didn't change anything (and I didn't need it in the past.) "Bernard Liengme" wrote: Click the data series in the chart Look in Chart Tools | Layout | Analysis for Trendline Click the launcher (triangle pointing down) ; select the type of trendline needed Open the "More Trendline Options" to add equation. etc best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rookie Roger" wrote in message ... I was once an expert, guru even, helped everybody. Now I can't even find the help menu. So very frustrating. I have a graph and need to add a trendline. The graph is embedded in a worksheet sitting alongside four other graphs that have trendlines i created with Excel 2003. Trendline is no longer a simple check box on a screen that i can get to. I see it on one of the menus, Trendline, all nice and pretty grey. There's no help on trendline using F1 key, other than giving the formulas. On-line I find instructions on how to add a trendline, duh, and the trendline option is grey. Would anyone mind trying to assess how I've become so incompetent so quickly, and tell me what I'm doing wrong? |
#5
|
|||
|
|||
How to add a trendline in Excel 2007
Hi,
The following chart types don't support trendlines: all 3-D chart types, Radar charts, Surface plots, Area charts, all Stacked charts types. (I've probably missed some.) Trendline options will not be available if the sheet is protected. There were a number of chart related issues that were solved by SP1. Press Alt+1 and choose Resources, and see if SP1 is shown at the very bottom under about Microsoft Excel 2007 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Rookie Roger" wrote: That launcher is greyed out just like the trendline button, so I can't click either one. I tried to install an Add-On of Data Analysis tools but that didn't change anything (and I didn't need it in the past.) "Bernard Liengme" wrote: Click the data series in the chart Look in Chart Tools | Layout | Analysis for Trendline Click the launcher (triangle pointing down) ; select the type of trendline needed Open the "More Trendline Options" to add equation. etc best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rookie Roger" wrote in message ... I was once an expert, guru even, helped everybody. Now I can't even find the help menu. So very frustrating. I have a graph and need to add a trendline. The graph is embedded in a worksheet sitting alongside four other graphs that have trendlines i created with Excel 2003. Trendline is no longer a simple check box on a screen that i can get to. I see it on one of the menus, Trendline, all nice and pretty grey. There's no help on trendline using F1 key, other than giving the formulas. On-line I find instructions on how to add a trendline, duh, and the trendline option is grey. Would anyone mind trying to assess how I've become so incompetent so quickly, and tell me what I'm doing wrong? |
Thread Tools | |
Display Modes | |
|
|