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
3 answers
July 8th 19 at 15:43
Possible.
c66ffb163af34fdc9492eef8859bc72a.png
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
4f5fc863a90d45bdb22ef4fcd724320d.jpg
July 8th 19 at 15:47
This is a common diagram with the signature speakers, and I have a schedule.
b0a5954ec3304d0e9de6bc91220c14b4.png

Find more questions by tags InfographicsExcel