Add trend line to chart

D

David_F._Plummer

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I try to add a trend line, and click on the Chart menu, the "Add Trend Line" is grayed out? How can I add a trend line, or get the Chart menu changed so the "Add Trend Line" option operates?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I try to add a trend line, and click on the Chart menu, the "Add Trend
Line" is grayed out? How can I add a trend line, or get the Chart menu
changed so the "Add Trend Line" option operates?

From Help (the topic "Display the trend series by using a trendline in a
chart", which I found by searching for "trend line"), the first step is:

1. Click the data series to which you want to add a trendline or
moving average.
 
G

Guest

Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) > Processor:
Intel > > When I try to add a trend line, and click on the Chart menu,
the "Add Trend > Line" is grayed out? How can I add a trend line, or get
the Chart menu > changed so the "Add Trend Line" option operates?





From Help (the topic "Display the trend series by using a trendline in
a chart", which I found by searching for "trend line"), the first step
is:





1. Click the data series to which you want to add a trendline or moving
average.




Hi JEMcG!

Yes, I've highlighted the data series, but when I click on the 'Chart' menu, the "Add Trend Line" option is grayed out. Now what?

Dave P.
 
M

Mike Middleton

Dave P. -
Yes, I've highlighted the data series, ... <

To avoid a misunderstanding: Select the data series by clicking once on one
of the data points in the chart.

Also, be sure you're using an appropriate chart type. From Excel Help: "A
trendline or moving average can be added to any data series in an unstacked,
2-D, area, bar, column, line, stock, xy (scatter), or bubble chart. Note A
trendline cannot be added to data series in a stacked, 3-D, radar, pie,
surface, or doughnut chart."

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



wrote in message news:[email protected]...
 
D

David_F._Plummer

Hi Mike!

My data/chart is a simple 'line' chart. Clicking on one of the data points in the plot "illuminates" the rest of the data, but opening the 'Chart' menu still results in a grayed-out 'Add Trend Line' label, so there is no way to cause the line to be created and inserted in the chart. I've tried to get a trend line created with other sets of data, and with xy scatter charts, and get the same result ("Add Trend Line" is grayed out in the "Chart" menu.

My Excel version is 12.1.3 (080930) with the 12.1.4 update; my Mac OS X is 10.5.5.
 
J

JE McGimpsey

Hi Mike!

My data/chart is a simple 'line' chart. Clicking on one of the data points in
the plot "illuminates" the rest of the data, but opening the 'Chart' menu
still results in a grayed-out 'Add Trend Line' label, so there is no way to
cause the line to be created and inserted in the chart. I've tried to get a
trend line created with other sets of data, and with xy scatter charts, and
get the same result ("Add Trend Line" is grayed out in the "Chart" menu.

Hmm... I'm able to add trend lines to line charts (but not stacked line
charts - are you using that style by any chance)?

Does this workaround work for you: Switch to an X-Y scatter chart. Add
the trend-line. Switch back to the line chart.
 
N

Nic

IT WORKED!
After and hour of fiddling around it finally worked; now i know where to turn if another similar issue arises
thanks, J. E. McGimpsey
 
J

jonn2

comment3, <http://edovi.com/dsw-shoes/index.html> Dsw Shoes, %[[, <http://edovi.com/dsw-shoes/dsw-shoe-warehouse.html> Dsw Shoe Warehouse, 8P, <http://edovi.com/dsw-shoes/dsw-shoe-warehouse-online.html> Dsw Shoe Warehouse Online, =DDD, <http://edovi.com/dsw-shoes/dsw-shoe.html> Dsw Shoe, zhrc, <http://edovi.com/dsw-shoes/dsw-shoe-store.html> Dsw Shoe Store, zurnkq, <http://edovi.com/dsw-shoes/dws-shoes.html> Dws Shoes, :[[[, <http://edovi.com/dsw-shoes/dswshoes.html> Dswshoes, cecv, <http://edovi.com/dsw-shoes/dsw-shoes.html> Dsw Shoes, yyobf, <http://edovi.com/dsw-shoes/dsw-shoes-warehouse.html> Dsw Shoes Warehouse, 8OOO, <http://edovi.com/dsw-shoes/dsw-shoes-store.html> Dsw Shoes Store, mzjvjz, <http://edovi.com/dsw-shoes/dsw-shoes-online.html> Dsw Shoes Online, 5900, <http://edovi.com/dsw-shoes/shoes-dsw.html> Shoes Dsw, 2733, <http://edovi.com/dsw-shoes/dsw-shoes-woman.html> Dsw Shoes Woman, 344088, <http://edovi.com/dsw-shoes/dsw-shoes-website.html> Dsw Shoes Website, 036, <http://edovi.com/dsw-shoes/dsw-warehouse-shoes.html> Dsw Warehouse Shoes, kgu, <http://edovi.com/dsw-shoes/show-shoes-at-dsw.html> Show Shoes At Dsw, =-DD, <http://edovi.com/dsw-shoes/dsw-shoes-coupon.html> Dsw Shoes Coupon, 522870, <http://edovi.com/dsw-shoes/dsw-shoes-com.html> Dsw Shoes Com, bxkpyi, <http://edovi.com/dsw-shoes/shop-dsw-shoes.html> Shop Dsw Shoes, xlqs, <http://edovi.com/dsw-shoes/dsw-shoes-stores.html> Dsw Shoes Stores, ufj, <http://edovi.com/dsw-shoes/dsw-shoes-locations.html> Dsw Shoes Locations, eryc, <http://edovi.com/dsw-shoes/unionbay-shoes-at-dsw.html> Unionbay Shoes At Dsw, ldwgt, <http://edovi.com/dsw-shoes/dsw-online-shoes.html> Dsw Online Shoes, ctlg, <http://edovi.com/dsw-shoes/dsw-discount-shoes-location.html> Dsw Discount Shoes Location, lav, <http://edovi.com/dsw-shoes/dsw-shoes-feet.html> Dsw Shoes Feet, >:[, <http://edovi.com/dsw-shoes/dsw-shoes-coupons.html> Dsw Shoes Coupons, caae, <http://edovi.com/dsw-shoes/catalog-dsw-shoes.html> Catalog Dsw Shoes, rgpll, <http://edovi.com/dsw-shoes/dsw-shoes-in-northridge-california.html> Dsw Shoes In Northridge California, %PP, <http://edovi.com/dsw-shoes/dsw-shoes-passion.html> Dsw Shoes Passion, ure, <http://edovi.com/dsw-shoes/dsw-shoes-online-shopping.html> Dsw Shoes Online Shopping, 3463, <http://edovi.com/dsw-shoes/dsw-girls-shoes.html> Dsw Girls Shoes, zrp, <http://edovi.com/dsw-shoes/dsw-shoes-connecticut.html> Dsw Shoes Connecticut, 8-[[[, <http://edovi.com/dsw-shoes/dsw-shoes-outlet.html> Dsw Shoes Outlet, jmindi, <http://edovi.com/dsw-shoes/dsw-shoes-wharehouse.html> Dsw Shoes Wharehouse, 558, <http://edovi.com/dsw-shoes/search-dsw-shoes.html> Search Dsw Shoes, 5506, <http://edovi.com/dsw-shoes/shoes-at-dsw.html> Shoes At Dsw, :mad:, <http://edovi.com/dsw-shoes/dsw-designer-shoes.html> Dsw Designer Shoes, ljzuzu, <http://edovi.com/dsw-shoes/dsw-shoes-germantown-md.html> Dsw Shoes Germantown Md, vutbw, <http://edovi.com/dsw-shoes/dsw-shoes-women.html> Dsw Shoes Women, :pP, <http://edovi.com/dsw-shoes/website-for-dsw-shoes.html> Website For Dsw Shoes, :-OO, <http://edovi.com/dsw-shoes/aerosoles-spark-attack-at-dsw-shoes.html> Aerosoles Spark Attack At Dsw Shoes, 10026, <http://edovi.com/dsw-shoes/dsw-shoes-aurora-colorado.html> Dsw Shoes Aurora Colorado, :pPP, <http://edovi.com/dsw-shoes/dsw-shoes-denver.html> Dsw Shoes Denver, :pP, <http://edovi.com/dsw-shoes/dsw-shoes-nj.html> Dsw Shoes Nj, bdik, <http://edovi.com/dsw-shoes/dsw-unionbay-shoes.html> Dsw Unionbay Shoes, 7932, <http://edovi.com/dsw-shoes/dsw-womens-shoes.html> Dsw Womens Shoes, =-(((, <http://edovi.com/dsw-shoes/dallas-dsw-shoes-warehouse.html> Dallas Dsw Shoes Warehouse, puzxjj, <http://edovi.com/dsw-shoes/shoes-brand-dsw.html> Shoes Brand Dsw, 30128, <http://edovi.com/dsw-shoes/com-dsw-shoes.html> Com Dsw Shoes, almfe, <http://edovi.com/dsw-shoes/shoes-store-dsw.html> Shoes Store Dsw, :-[,
 
J

jonn2

comment1, <http://edovi.com/vonage/index.html> Vonage, =-]], <http://edovi.com/vonage/vonage-account.html> Vonage Account, nuyd, <http://edovi.com/vonage/vonage-phone.html> Vonage Phone, 4494, <http://edovi.com/vonage/vonage-phone-service.html> Vonage Phone Service, =PPP, <http://edovi.com/vonage/vonage-voip.html> Vonage Voip, ubcmf, <http://edovi.com/vonage/account-customer-vonage.html> Account Customer Vonage, xme, <http://edovi.com/vonage/vonage-internet-phone-service.html> Vonage Internet Phone Service, 596, <http://edovi.com/vonage/vonage-broadband-phone-service.html> Vonage Broadband Phone Service, mllp, <http://edovi.com/vonage/vonage-canada.html> Vonage Canada, 3828, <http://edovi.com/vonage/vonage-review.html> Vonage Review, 810808, <http://edovi.com/vonage/account-customer-phone-service-vonage.html> Account Customer Phone Service Vonage, =-PPP, <http://edovi.com/vonage/vonage-com.html> Vonage Com, 87552, <http://edovi.com/vonage/vonage-phone-company.html> Vonage Phone Company, =[, <http://edovi.com/vonage/phone-v-vonage.html> Phone V Vonage, 045069, <http://edovi.com/vonage/vonage-internet.html> Vonage Internet, oof, <http://edovi.com/vonage/vonage-internet-phone.html> Vonage Internet Phone, 07625, <http://edovi.com/vonage/vonage-login.html> Vonage Login, bbs, <http://edovi.com/vonage/vonage-cell-phone.html> Vonage Cell Phone, kuye, <http://edovi.com/vonage/american-card-offer-service-vonage.html> American Card Offer Service Vonage, ydqnd, <http://edovi.com/vonage/vonage-broadband-phone.html> Vonage Broadband Phone, 6064, <http://edovi.com/vonage/vonage-customer-service.html> Vonage Customer Service, dkx, <http://edovi.com/vonage/vonage-.com.html> Vonage .Com, ztcj, <http://edovi.com/vonage/commercial-girl-vonage.html> Commercial Girl Vonage, vyqkri, <http://edovi.com/vonage/vonage-service.html> Vonage Service, 49665, <http://edovi.com/vonage/vonage-phone-number.html> Vonage Phone Number, :mad:, <http://edovi.com/vonage/vonage-dsl.html> Vonage Dsl, >:), <http://edovi.com/vonage/vonage-song.html> Vonage Song, rup, <http://edovi.com/vonage/account-mail-voice-vonage-web.html> Account Mail Voice Vonage Web, 5982, <http://edovi.com/vonage/vonage-broadband.html> Vonage Broadband, :]]], <http://edovi.com/vonage/192.168.15.1-vonage.html> 192.168.15.1 Vonage, :mad:(, <http://edovi.com/vonage/vonage-commercial.html> Vonage Commercial, 01301, <http://edovi.com/vonage/vonage-the-broadband-phone-company.html> Vonage The Broadband Phone Company, :[, <http://edovi.com/vonage/account-online-vonage.html> Account Online Vonage, 86538, <http://edovi.com/vonage/vonage-router.html> Vonage Router, =-(((, <http://edovi.com/vonage/vonage-phone-services.html> Vonage Phone Services, miuhv, <http://edovi.com/vonage/vonage-unlimited.html> Vonage Unlimited, ysqwp, <http://edovi.com/vonage/vonage-internet-service.html> Vonage Internet Service, 0250, <http://edovi.com/vonage/vonage-holding.html> Vonage Holding, gesb, <http://edovi.com/vonage/vonage-holding-corp.html> Vonage Holding Corp, xkgjqr, <http://edovi.com/vonage/vonage-voice-mail.html> Vonage Voice Mail, ipfhdo, <http://edovi.com/vonage/vonage-phone-system.html> Vonage Phone System, rxa, <http://edovi.com/vonage/broadband-phone-service-unlimited-vonage.html> Broadband Phone Service Unlimited Vonage, =-O, <http://edovi.com/vonage/vonage-softphone.html> Vonage Softphone, =-]], <http://edovi.com/vonage/account-customer-service-vonage.html> Account Customer Service Vonage, yef, <http://edovi.com/vonage/vonage-wireless.html> Vonage Wireless, 8803, <http://edovi.com/vonage/linda-oneil-vonage.html> Linda Oneil Vonage, dnifok, <http://edovi.com/vonage/vonage-girl.html> Vonage Girl, :p, <http://edovi.com/vonage/vonage-offer.html> Vonage Offer, %D, <http://edovi.com/vonage/vonage-ca.html> Vonage Ca, 561, <http://edovi.com/vonage/call-digital-vonage.html> Call Digital Vonage, 654089,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top