# [Help]3phase graphic using excel

Status
Not open for further replies.

#### Silent_Sense

##### New Member
hello guys, i need ur help again hehe..
can u give me some information or something to help me to make 3phase graphic using excel?
3 sinus graphic in one graphic..
There are 3 variable (a,b,c)
my graphic start from 10 degrees(a), so, b will be start from 130degrees, c will be 250degrees..thats right?
what i must compare to make it likes sinus graphic?
In this case, That degrees using for sign of my graphic that start from 10, 130, and 250 degrees..
I try to googling..but i cant..
So, i try to get information here..
I love this forum (sure)
Thx b4..

Last edited:

Like this?

#### Attachments

• 28.2 KB Views: 212

#### Silent_Sense

##### New Member
Like this?
Thats right..
but in my case, its start from 10degrees (line Blue)-
130degrees(line red)-
250degrees(line blue) ..
can u give me excel file??
so i can modify that file..
I using Micrs.Office 07..
u can send to my email
[email protected]
1 again, if i using current and torque to make graphic like that??
Thx a lot b4..

#### JimB

##### Super Moderator
OK, lets keep the discussion in the forum.

Refering to the attached screen shot.

1 Set up a series of data points for the x-axis, I have used 0 to 720 degrees in 10 degree steps.

2 Set up the phase differences, I used 0, 120 and 240 degrees.
You can use 10, 130 and 250 if you wish.

3 Set the formula for the first cell.
Excel uses radians for the Sin() function, so (2*PI()..../360) converts the degrees to radians.
B4 the cell with the degrees. (actually it would be better written as $B4.$C$3 the cell with the phase difference. The other columns will be$D$3 and$E\$3.

Now copy the formula to the other cells.

4 Select all four colomns of data and click on the "Scatter" chart icon, in the pop-up box click on the "Scatter with smooth lines" icon.

Job done! enjoy your pretty picture.

JimB

#### Attachments

• 120.4 KB Views: 264

#### Silent_Sense

##### New Member
Waw..very cool picture..
thx a lot sir..
but how to make pic like this..

when i input a, so b n c can be change..so we have the resultan of that picture..
Hehe..i`m sorry if i many ask to you hehe..