Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 10, 05:01 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 50
Default adding trendline to plots from multiple series

I have a line chart with multiple series and I am looking to create another
line based on a third group of data that is based off the original datas
plots on the graph. Basically its like this. On the y-axis I have flow
and on the x-axis I have pressure. There are multiple series plotted. I
want to add another line to the chart based on efficiency that will always
run through a certain set of plots from the multiple series. Is this
possible? Did this even make any sense? Thank you for any help that you can
give.

  #2   Report Post  
Old January 8th 10, 11:32 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 120
Default adding trendline to plots from multiple series

aintlifegrand,

There are two possible intentions of yours that are difficult to reveal:

- To insert a new characteristic into the family of the existing ones, with
a new value of parameter (size, design parameter, power etc.) that determines
each of your series. This could(!) be resolved, indeed, by trendlining the
other series, at least in the decisive part of the characteristics, most
probably by a three-parameter regression. These three parameters should be
each further fitted by the next (linear, i.e. two-parameter) regressions on
the discussed parameter. Fortunately, at least one of these relationships
should be almost constant (similar shapes opf curves). By a simple
mathematical treatment you should obtain a general (six-parameter)equation
for a characteristic line where you will substitute independent variable and
a new parameter.

- To draw efficiency lines. If you should come out only from tabulated data
including efficiencies, you could be lucky enough to find out the proper
number of point co-ordinates valid for each selected value of efficiency. The
simple task would be only to gather them properly to a chart series range. If
the data would be too scarce, than you would have ahead a more complicated
work with interpolations.

Regards

--
Petr Bezucha


"aintlifegrand79" wrote:

I have a line chart with multiple series and I am looking to create another
line based on a third group of data that is based off the original datas
plots on the graph. Basically its like this. On the y-axis I have flow
and on the x-axis I have pressure. There are multiple series plotted. I
want to add another line to the chart based on efficiency that will always
run through a certain set of plots from the multiple series. Is this
possible? Did this even make any sense? Thank you for any help that you can
give.



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
Creating one trendline for multiple series ALaw Charts and Charting in Excel 1 April 2nd 08 08:00 PM
How to add trendline over multiple series and a segment of x-value progprog Charts and Charting in Excel 1 November 6th 06 06:21 PM
scatter plots with multiple series Kat Charts and Charting in Excel 4 September 2nd 06 12:30 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 12:52 PM.

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