Wagon wheel graph in Excel

[mohsinbipu]

Dear Excel expert,
Can you please kindly help me to find out a way to draw a graph like this

 

[awoohaw]

I don't understand the relationships of LIne Lenght or Line Qty? For instance, assuming this is like a trigonometry map where 0 degree is the far right of the circle, so the 280 line is the line in the 4th quadrant (+x,-y), but the I don't see how the length of hte line is 6, or the quantity is 3. Labelling your chart would be helpful.

Regardless, i think a scatter plot with lines is the way to go, but you'll need to calculate the end points of the line and have each vector start at zero.
take a look at this youtube video and see if it can give you some help:

 

[awoohaw]

Here is a picture of the chart I did, convertingthe length and angle to the x and y values. I still do not know what "Line Quantity" means.

Here is the xl2bb for the data and calculations above:

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3	Vector	Line Degree	Line Length	Line Qty		Origin x	Orign y	Vector x	Vector y
4	Vector1	30	2	2		0	0	1.00	1.73
5	Vector2	50	4	1		0	0	3.06	2.57
6	Vector3	60	2	2		0	0	1.73	1.00
7	Vector4	20	4	1		0	0	1.37	3.76
8	Vector5	120	1	2		0	0	0.87	-0.50
9	Vector6	140	4	1		0	0	2.57	-3.06
10	Vector7	280	6	3		0	0	-5.91	1.04
11
12
13
mohsinbipu

Cell Formulas
Range	Formula
H4:H10	H4	=C4*SIN(RADIANS(B4))
I4:I10	I4	=C4*COS(RADIANS(B4))

 

[mohsinbipu]

Length means the radius of the circle.
Let's say the Circle radius is 4.
Now If the Line length is 2, then the Line will go half.
If the Line length is 4, then the Line will go up to the circumference.

 

[mohsinbipu]

Please ignore the line qty. I think your solution is perfect. Can you please kindly attach the excel file with the graph?

 

[BigBeachBananas]

Here is a picture of the chart I did, convertingthe length and angle to the x and y values. I still do not know what "Line Quantity" means.

View attachment 100287


Here is the xl2bb for the data and calculations above:

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3	Vector	Line Degree	Line Length	Line Qty		Origin x	Orign y	Vector x	Vector y
4	Vector1	30	2	2		0	0	1.00	1.73
5	Vector2	50	4	1		0	0	3.06	2.57
6	Vector3	60	2	2		0	0	1.73	1.00
7	Vector4	20	4	1		0	0	1.37	3.76
8	Vector5	120	1	2		0	0	0.87	-0.50
9	Vector6	140	4	1		0	0	2.57	-3.06
10	Vector7	280	6	3		0	0	-5.91	1.04
11
12
13
mohsinbipu

Cell Formulas
Range	Formula
H4:H10	H4	=C4*SIN(RADIANS(B4))
I4:I10	I4	=C4*COS(RADIANS(B4))

x should corresponds with cos() and y should corresponds with sin(). You have them swapped.

 

[mohsinbipu]

Here is a picture of the chart I did, convertingthe length and angle to the x and y values. I still do not know what "Line Quantity" means.

View attachment 100287


Here is the xl2bb for the data and calculations above:

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3	Vector	Line Degree	Line Length	Line Qty		Origin x	Orign y	Vector x	Vector y
4	Vector1	30	2	2		0	0	1.00	1.73
5	Vector2	50	4	1		0	0	3.06	2.57
6	Vector3	60	2	2		0	0	1.73	1.00
7	Vector4	20	4	1		0	0	1.37	3.76
8	Vector5	120	1	2		0	0	0.87	-0.50
9	Vector6	140	4	1		0	0	2.57	-3.06
10	Vector7	280	6	3		0	0	-5.91	1.04
11
12
13
mohsinbipu

Cell Formulas
Range	Formula
H4:H10	H4	=C4*SIN(RADIANS(B4))
I4:I10	I4	=C4*COS(RADIANS(B4))

This solution is perfect. This is what I am looking for.

 

[awoohaw]

x should corresponds with cos() and y should corresponds with sin(). You have them swapped.

thanks, i'll post a correction.

 

[awoohaw]

Please ignore the line qty. I think your solution is perfect. Can you please kindly attach the excel file with the graph?

Here is the data:

Mr excel questions 67.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2
3	Vector	Line Degree	Line Length	Line Qty		Origin x	Vector x	Orign y	Vector y
4	Vector1	30	2	2		0	1.73	0	1.00
5	Vector2	50	4	1		0	2.57	0	3.06
6	Vector3	60	2	2		0	1.00	0	1.73
7	Vector4	20	4	1		0	3.76	0	1.37
8	Vector5	120	1	2		0	-0.50	0	0.87
9	Vector6	140	4	1		0	-3.06	0	2.57
10	Vector7	280	6	3		0	1.04	0	-5.91
11
12
mohsinbipu

Cell Formulas
Range	Formula
G4:G10	G4	=C4*COS(RADIANS(B4))
I4:I10	I4	=C4*SIN(RADIANS(B4))