Creating a Phasor (Quadrant) diagram (chart)

[BillV]

Can someone provide step by step instructions for how to make a Phasor (Quadrant) diagram (chart) like the screen shot below? This is 360° chart, that should rotate counterclockwise. V1 will always be at 0°.
Here is the data for the attached chart:
V1=0°
I1=10°
V2=120
I2=130°
V3=240°
I3=250°

 

[BillV]

I probably didn't explain this well enough. This is a 360 phasor that counts clockwise but the vectors rotate counter-clockwise. And so, if the I1 angle is 10° then it lags V1 but if I1 is at 330° then it leads V1.
Since these are voltage and current (amp) vectors:
V1 is expected to always be at 0°
The I1 angle is always measured in relation to V1
The I2 angle is always measured in relation to V2 and will normally lag V2 but it's possible to lead under certain conditions. V2 will always be at either 120° or 240°.
The I3 angle is always measured in relation to V3 and will normally lag V3 but it's possible to lead under certain conditions. V3 will always be at either 120° or 240° but never the same as V2.

 

[BillV]

The screen shot I provided is from an instrument but I'd like to build a spreadsheet as a verification and training tool.

 

[Cubist]

I probably didn't explain this well enough. This is a 360 phasor that counts clockwise but the vectors rotate counter-clockwise. And so, if the I1 angle is 10° then it lags V1 but if I1 is at 330° then it leads V1.
Since these are voltage and current (amp) vectors:
V1 is expected to always be at 0°
The I1 angle is always measured in relation to V1
The I2 angle is always measured in relation to V2 and will normally lag V2 but it's possible to lead under certain conditions. V2 will always be at either 120° or 240°.
The I3 angle is always measured in relation to V3 and will normally lag V3 but it's possible to lead under certain conditions. V3 will always be at either 120° or 240° but never the same as V2.

I asked for this in post#2 but didn't get an answer. The formula is currently always measuring the angle from V1 counterclockwise. If you want clockwise, then take the complement of 360.

Book1
	A	B	C	D	E	F	G
1		r	deg	x_origin	x	y_origin	y
2	V1	5	0	0	5	0	-1.22515E-15
3	I1	5	10	0	4.92403877	0	-0.868240888
4	V2	5	120	0	-2.5	0	-4.330127019
5	I2	5	130	0	-3.21393805	0	-3.830222216
6	V3	5	240	0	-2.5	0	4.330127019
7	I3	5	250	0	-1.71010072	0	4.698463104
Sheet1

Cell Formulas
Range	Formula
E2:E7	E2	=B2*COS(RADIANS(360-C2))
G2:G7	G2	=B2*SIN(RADIANS(360-C2))

 

[BillV]

Adding radian's has matched the voltage and current vectors correctly but with the angles that I've provided voltage should be leading current in all three phases. Plus, V1 I1 should be in the 1st quadrant, V2 I2 should be in the 2nd quadrant and V3 I3 should be in the 3rd quadrant. The 4th quadrant should be empty.

Is it possible to remove the "r" numerals on the chart, add the 360 phasor numbers and add the quadrant numbers to each section?

 

[Cubist]

Adding radian's has matched the voltage and current vectors correctly but with the angles that I've provided voltage should be leading current in all three phases. Plus, V1 I1 should be in the 1st quadrant, V2 I2 should be in the 2nd quadrant and V3 I3 should be in the 3rd quadrant. The 4th quadrant should be empty. - See post #13.

Is it possible to remove the "r" numerals on the chart, - Click on the axis -> Axis Options -> label position -> none

...add the 360 phasor numbers and - Click on each chart -> Add data labels -> Label options -> Value from cell -> Select the phasor numbers

add the quadrant numbers to each section? - Create additional points below and add to the charts. The labels are the same as the 360 phasor.

Book1
	A	B	C	D	E	F	G
1		r	deg	x_origin	x	y_origin	y
2	V1	5	0	0	5	0	-1.22515E-15
3	I1	5	10	0	4.924038765	0	-0.868240888
4	V2	5	120	0	-2.5	0	-4.330127019
5	I2	5	130	0	-3.213938048	0	-3.830222216
6	V3	5	240	0	-2.5	0	4.330127019
7	I3	5	250	0	-1.710100717	0	4.698463104
8
9
10	quadrants labels	x	y
11	Q4	2.5	2.5
12	Q3	-2.5	2.5
13	Q2	-2.5	-2.5
14	Q1	2.5	-2.5
Sheet1

Cell Formulas
Range	Formula
E2:E7	E2	=B2*COS(RADIANS(360-C2))
G2:G7	G2	=B2*SIN(RADIANS(360-C2))
B13	B13	=-2.5

 

[BillV]

My apologies for not being clear.
I've added 360 to the formula and that has corrected the current to lag and placed the vectors in the correct quadrant.

 

[BillV]

Do you have an idea why the quadrants labels are catching the Y coordinate and not the series name?

 

[Cubist]

By default, the labels are set to x-value. You can change it.

 

[BillV]

Thank you for your time.