|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-19-2008, 07:56 AM
|
|||
|
|||
|
making y(x) dependence
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. 
|
|
#3
08-19-2008, 08:17 AM
|
|||
|
|||
|
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?
|
|
#5
08-19-2008, 08:32 AM
|
|||
|
|||
|
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.
|
|
#6
08-19-2008, 08:39 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.
|
|
#7
08-19-2008, 08:59 AM
|
|||
|
|||
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.
|
|
#8
08-19-2008, 09:32 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
|
|
#12
09-30-2008, 03:43 AM
|
|||
|
|||
|
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.
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Making Tab Sizes smaller or creating multiple rows of tabs. | kingbiscuit | Excel General | 4 | 03-05-2008 04:44 PM |
| Making a cell reference itself | dsykes | Excel Miscellaneous | 1 | 12-21-2007 03:00 PM |
| Requiring Save As without making file read only | redstang423 | Excel Miscellaneous | 5 | 04-07-2007 12:02 PM |
Linear Mode
