A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Help with area under trendline



 
 
Thread Tools Display Modes
  #1  
Old July 19th 12, 03:40 PM
alexnocera alexnocera is offline
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 1
Default Help with area under trendline

Hello,

I have created a line chart with two Y-axes, and I need to shade under one of the trendlines. I have already replicated the trendline using the equation, so it is displayed as a data series. It is essentially one trendline with 4 different "sections" (1-4,5-9,10-15,16-22) and every time I try to change one of these series to an area chart, it pushes it to the y-axis and overlaps the others. Sorry for the wordy post and any help would be great!

Thanks,

Alex
Ads
  #2  
Old July 19th 12, 06:15 PM
Spencer101 Spencer101 is offline
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 654
Default

Quote:
Originally Posted by alexnocera View Post
Hello,

I have created a line chart with two Y-axes, and I need to shade under one of the trendlines. I have already replicated the trendline using the equation, so it is displayed as a data series. It is essentially one trendline with 4 different "sections" (1-4,5-9,10-15,16-22) and every time I try to change one of these series to an area chart, it pushes it to the y-axis and overlaps the others. Sorry for the wordy post and any help would be great!

Thanks,

Alex
Hi Alex,

Could you post an example?
It makes these things far easier to solve...

S.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding area codes only to phone numbers missing an area code RC Excel Discussion (Misc queries) 3 February 12th 08 09:22 PM
Need help adding trendline to area chart RBear3 Charts and Charting in Excel 3 January 16th 08 12:40 PM
area under the curve of a trendline Josh Excel Worksheet Functions 5 March 22nd 07 11:41 PM
Area under trendline Josh Excel Discussion (Misc queries) 2 March 20th 07 03:44 AM
Graph Size not adjusting with Chart Area and Plot Area Jon Peltier Excel Programming 1 September 12th 06 07:01 PM


All times are GMT +1. The time now is 10:47 AM.


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