Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 6th 06, 06:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 3
Default How to add trendline over multiple series and a segment of x-value

How do I add a trendline that covers multiple series and over a partial
section of a series (for example, one for the first 5 x-values, and one for
the next 6 x-values for data from 4 series)?



  #2   Report Post  
Old November 6th 06, 06:21 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How to add trendline over multiple series and a segment of x-value

The first part is not possible (or I do not know how to do it!)
For the second part, rather than add trendline use TREND to fit each partial
dataset and add the results as new series in the chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"progprog" wrote in message
news
How do I add a trendline that covers multiple series and over a partial
section of a series (for example, one for the first 5 x-values, and one
for
the next 6 x-values for data from 4 series)?






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
multiple series from one column Maarten Charts and Charting in Excel 1 October 5th 06 04:40 AM
Bubbles with multiple series Kim Charts and Charting in Excel 3 July 2nd 06 09:09 PM
Disappearing scales on bar charts with multiple series Patrick Charts and Charting in Excel 3 November 3rd 05 09:10 PM
Trendline and multiple data series Blackcat Excel Discussion (Misc queries) 1 May 2nd 05 02:06 AM
Single trendline for multiple series MAWII Excel Discussion (Misc queries) 1 April 29th 05 03:00 PM


All times are GMT +1. The time now is 01:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017