# And is it possible to, when signing the tick marks on the x-axis, instead of numbers was the number PI with the corresponding coefficients?

And is it possible to, when signing the tick marks on the x-axis, instead of numbers was the number PI with the corresponding coefficients?
There is a system of coordinates and the sine wave built in MS Excel. The x-axis has the price of division 1. The values for the graph calculated using PI from MS Excel. Tell me if you can make sure that the scale was "PI/2" scale value signed: P/2, P, 3P/2, 2P?
Thank you.
July 8th 19 at 15:41
July 8th 19 at 15:43
Possible.

Prepare the data for the function sine.
1. In column A values indicated on the x-axis from -2.5 to 2.5 in increments of 0.125; this is the minimum frequency step. Thus, in cell A2 write the formula `=\$A1+DEGREE(0,5;3)` and stretching to 41-th row, and in cell A1 write the value "`-2,5`"
2. In column B set the measure for the x-axis in multiples of PI using the formula: `=round(PI()*\$A1;2)`
3. In column C write a formula for the sine: `=SIN(PI()*\$A1)`

Build a chart of sine, pointing in the "chart data" column C. Custom chart:
1. Constructor (menu) -> Select data
2. Signatures on the horizontal axis (right column) -> Edit (button)
3. Choose to "label range" column B. Click OK.

Open the "advanced settings primary horizontal axis". In Excel 2010: Layout (tab) -> Axis (section).
1. Choose "axis Options" (menu left) -> Vertical axis crosses: in the category of number (switch). Enter the number of rows where column A has a value of "`0`" (in my example "21").
2. The position of the axis of the exposed "by divisions" (switch). Click OK.

To change the division value multiple of PI/4, now it is enough to change the formula in column B.
Insert formula into cell B1 and pull to the end:

=ESLI(\$A1=0;0;ESLI(OSTAT(\$A1;0,5)=0;ESLI(MOD(ABS(\$A1*2);4)=1;ESLE(ABS(\$A1)>1;\$A1*2;ESLI(SNAK(\$A1)=-1;"-";""))&"π/2";ESLI(ABS(\$A1)>1;\$A1;ESLI(SNAK(\$A1)=-1;"-";""))&"π");ESLI(OSTAT(\$A1;0,25)=0;ESLI(MOD(ABS(\$A1*4);8)=1;ESLE(ABS(\$A1)>=0,75;\$A1*4;ESLI(SNAK(\$A1)=-1;"-";""))&"π/4");"")))

It remains to define identical axes of a single cut, but you can handle it :)
July 8th 19 at 15:45
July 8th 19 at 15:47
This is a common diagram with the signature speakers, and I have a schedule.

Find more questions by tags InfographicsExcel