Remember Me?

#1
January 8th 10, 05:01 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jan 2010 Posts: 50
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
January 8th 10, 11:32 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 120
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ALaw Charts and Charting in Excel 1 April 2nd 08 08:00 PM progprog Charts and Charting in Excel 1 November 6th 06 06:21 PM Kat Charts and Charting in Excel 4 September 2nd 06 12:30 PM Blackcat Excel Discussion (Misc queries) 1 May 2nd 05 02:06 AM MAWII Excel Discussion (Misc queries) 1 April 29th 05 03:00 PM

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