| Author |
 Topic  |
|
|
selanne
stripovi.com suradnik
.jpg)
Bosnia and Herzegovina
7655 Posts
Member since 11/09/2009 |
 Posted - 04/05/2017 : 16:41:27
|
Pozdrav, ljudi!
Nisam baš dobar prijatelj sa Excelom, malo sam danas guglao, ali nisam našao rješenje za svoj problem. Dakle, imam ovakvu tablicu:
Trebam napraviti graf koji će mi povezivati ove podatke, na način da na y osi s lijeve strane bude npr. "current", s desne "welding speed", a na x osi da bude "bead width".
Je li to moguće u excelu?
Nadam se da sam dobro pojasnio. 
|
Where other men blindly follow the truth, remember - nothing is true. Where other men are limited by morality or law, remember - everything is permitted. We work in the dark to serve the light. We are assassins! Nothing is true, everything is permitted. |
|
|
hitchhiker
Starting Member
54 Posts
Member since 01/08/2010 |
|
|
selanne
stripovi.com suradnik
Bosnia and Herzegovina
7655 Posts
Member since 11/09/2009 |
Posted - 04/05/2017 : 19:50:57
|
Hvala na pomoći, ali nije mi ovo bila zamisao.
Nije mi potrebno da imam dva seta varijabli na jednoj slici (tipa graf x-y1 i graf x-y2, kao što ovaj prvi link prikazuje), nego da imam tri varijable (a i b su neovisne, c je ovisna) i da nekako pokažem kako c ovisi o promjenama a i b.
Čini mi se da se to ipak ne može uraditi u excelu. |
Where other men blindly follow the truth, remember - nothing is true. Where other men are limited by morality or law, remember - everything is permitted. We work in the dark to serve the light. We are assassins! Nothing is true, everything is permitted. |
Edited by - selanne on 04/05/2017 19:51:18 |
 |
|
|
Fiju
New Member
Croatia
170 Posts
Member since 03/01/2003 |
Posted - 05/05/2017 : 09:17:55
|
Kolonu koja zelis da ti bude na x-osi premjesti na prvo mjesto i ukloni joj naziv iz prvog retka.
Insert chart -> Combo -> odaberi ChartType:Line za obje kolone (Current i Welding speed), a za Welding speed ukljuci Secondary Axis.
Dalje mozes i sam podesavati po svojim potrebama :) |
|
|
|
selanne
stripovi.com suradnik
Bosnia and Herzegovina
7655 Posts
Member since 11/09/2009 |
Posted - 05/05/2017 : 10:30:52
|
E, ovo je OK.
Puno hvala!  |
Where other men blindly follow the truth, remember - nothing is true. Where other men are limited by morality or law, remember - everything is permitted. We work in the dark to serve the light. We are assassins! Nothing is true, everything is permitted. |
|
|
| |
Topic |
|
Pomoć oko excella
