#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default excel chart

After completing a chart and wanting a trend line, why is it that of all the
buttons under chart are available, however the trend line button never lights
up, so you can't add one?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default excel chart

I suspect it will be available if you select a series.

"Jim Shoe" wrote:

After completing a chart and wanting a trend line, why is it that of all the
buttons under chart are available, however the trend line button never lights
up, so you can't add one?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default excel chart

Hi,

Certain chart types do not have the trendline feature.
Neither do any of the 3d chart styles.

Cheers
Andy

Jim Shoe wrote:
After completing a chart and wanting a trend line, why is it that of all the
buttons under chart are available, however the trend line button never lights
up, so you can't add one?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default excel chart

Hi,

Trendlines can not be applied in any 3-D chart, any stacked chart type and
Radar Charts, Pie Charts, Doughnut, Surface or Area charts.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jim Shoe" wrote:

After completing a chart and wanting a trend line, why is it that of all the
buttons under chart are available, however the trend line button never lights
up, so you can't add one?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Excel 2003: How to nudge a chart element or shape on a chart? Ted M H Charts and Charting in Excel 5 June 30th 08 07:08 PM
Chart Titles not showing in excel chart Window Greg_tnwre Excel Discussion (Misc queries) 0 July 15th 06 03:41 AM
Excel chart - how to assign the file name in the chart title? TGreen Charts and Charting in Excel 1 August 16th 05 10:35 AM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"