I have two series of numbers & I want to make a graph, illustrating the dependence of the 2nd serie on the 1st one. But Diagram Master always makes the 2 independent graphs on a diagram instead of the combined one. I can put the 1st serie as signature, but that is not the thing i want. Changing signature doesn't change dependence.
Exel, which I have is a part of the licence 2007 MsOffice pack.
If anyone help, I'll be very greatful.
Last edited by szk; 08-19-2008 at 08:11 AM.
Are you trying to create a xy-scatter chart?
Can you post example workbook and let us know which version of excel you are using.
Yes, need y(x).
y --------- x
16 285--- 35 574
8 278---- 19 289
3 124---- 11 011
981------ 7 887
696------ 6 906
611------ 6 210
527------ 5 498
452------ 4 971
Exel version 2007, Microsoft Office Exel. Files format xlsx.
& dont you know, is it possible here to set the dependence directly by a formula? like y=(sin(x))^2?
Excel expects the columns to be X and then Y values.
See attached.
The simplest way to create the required Y values is with a formula.
big thanks, i see.
but what is with the 1st question?
i have 8 (x;y) dots:
(35 574;16 285)
(19 289;8 278)
(11 011;3 124)
(7 887;981)
.....
how to illustrate them & to make a diagram?
is it possible to calculate(approximate) this data to a formula in excel?
Last edited by szk; 08-19-2008 at 08:35 AM.
Ah, those spaces where gaps between values rather than missing decimal places.
You would need to create the chart based on 1 set of data and then use
Chart Tools > Design > Data > Select Data
to add another series.
The attached contained formula in column D to calculate Y values.
if i will do like you are saying, i will get <attached>
i dont need this. i need an y(x) dependence. i need a line through 8 dots which i have.
and about formula, i need not sinx^2. i need excel to calculate the approximate formula y(x), using the data which i have (8 dots). the formula, which i dont even know yet. as i know, earlier versions of excel were able to solve it. hope the newest one is not the worst one
Last edited by szk; 08-19-2008 at 09:02 AM.
Sorry, I'm confused now.
Your example has Y values in first column and X values in second.
But the chart has 2 series where the X values are not related to any cells. Instead a simply sequential value of 1 to 8 is applied.
The Y values for the first line come from column 1
The Y values for the second line come from column 2
See Stephen Bullen's ChtFrmla.zip example, for a way of plotting a formula.
http://www.oaltd.co.uk/Excel/Default.htm
the problem is that i dont know how to relate the data in exel
thx for ChtFrmla, but that all coud be done with hands. i hoped to find a fitted in excel approximation
do you want excel to determine a formula for those x and y value? If so see LINEST formula
If not then sorry but I don't understand what you want
Are you thinking of a Trendline? Right-click the plotted series and select Trendline.
Thanks, but not exactly ) I need a straight formula, calculated by Excel.
For example:
1.
I have 4 (x;y) dots.
(1;1,12) (2;1,90) (3;2,72) (4;4,42)
If you drow these dots, you will get a liner relation.
I want Excel to calculate this formula(probably will be like y=2*x) plus calculation error. Smth like a mean-square deflection/dispersion.
2.
or you have 5 (x;y) dots
(0,5;0,22) (1;1,09) (2;3,7) (3;10) (4;15,2)
If you will drow these dots, you will see that the relation(x;y) is a polynomial, with the 2nd power. You set these settings, Excel again gives you a formula. Now it will be like y=x^2. Ofcourse with all errors.
Is it possible in Excel now?
Hope now the subject is clear. )
Last edited by szk; 09-30-2008 at 03:45 AM.
You need to look at the LINEST formula.
You should be able to find previous threads on the subject
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks