Download - GRAFICOS. EJEMPLOS. INFORMATICA.xlsx
![Page 1: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/1.jpg)
Locales Ene Feb Mar TotalTrujillo 5,466 8,783 8,711 22,960
Arequipa 5,850 7,047 8,511 21,408 Chiclayo 8,596 7,216 8,147 23,959
Lima 5,478 8,973 8,307 22,758 Piura 5,273 5,105 5,035 15,413
Tumbes 6,256 5,394 8,717 20,367 Totales x Mes 36,919 42,518 47,428 126,865
1. Se desea Graficar las ventas de los locales en los 3 meses indicados en gráficos de columnasSeleccionar desde A1:D7Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo ColumnaVamos a graficar los 3 tipos de columnas 2D y los demas gráficos son similares pero en 3D
SI SE SELECCIONA COLUMNA AGRUPADA 2D
SI SE SELECCIONA COLUMNA AGRUPADA 2DSeleccione este gráfico, vaya a la ficha DISEÑOy en el grupo DATOS selecciona CAMBIAR ENTREFILAS Y COLUMNAS
http://office.microsoft.com/es-es/excel-help/tipos-de-graficos-disponibles-HA010342187.aspx
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
![Page 2: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/2.jpg)
SI SE SELECCIONA COLUMNA APILADA 2D
SI SE SELECCIONA COLUMNA APILADA 100%
SI SE SELECCIONA COLUMNA AGRUPADA 3D
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFebMar
![Page 3: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/3.jpg)
SI SE SELECCIONA COLUMNA APILADA CON EFECTO 3D
SI SE SELECCIONA COLUMNA 3D APILADA 100%
SI SE SELECCIONA COLUMNA 3D
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujill
o
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000
EneFeb
Mar
EneFebMar
![Page 4: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/4.jpg)
Trujill
o
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000
EneFeb
Mar
EneFebMar
![Page 5: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/5.jpg)
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Columna
http://office.microsoft.com/es-es/excel-help/tipos-de-graficos-disponibles-HA010342187.aspx
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
![Page 6: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/6.jpg)
PARA TRUJILLO 5,466 5,466 8,783 14,249 8,711 22,960
PARA TRUJILLO 5,466 23.81% 23.81% 8,783 38.25% 62.06% 8,711 37.94% 100.00% 22,960
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFebMar
![Page 7: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/7.jpg)
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujill
o
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000
EneFeb
Mar
EneFebMar
![Page 8: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/8.jpg)
Trujill
o
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000
EneFeb
Mar
EneFebMar
![Page 9: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/9.jpg)
Locales Ene Feb Mar TotalTrujillo 5,466 8,783 8,711 22,960
Arequipa 5,850 7,047 8,511 21,408 Chiclayo 8,596 7,216 8,147 23,959
Lima 5,478 8,973 8,307 22,758 Piura 5,273 5,105 5,035 15,413
Tumbes 6,256 5,394 8,717 20,367 Totales x Mes 36,919 42,518 47,428 126,865
2. Se desea Graficar las ventas de los locales en los 3 meses indicados en gráficos de LíneasSeleccionar desde A1:D7
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo LineaVamos a graficar los 3 tipos de líneas sin marcadores y después 3D
SI SE SELECCIONA LINEAS
SI SE SELECCIONA LINEA APILADA
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
![Page 10: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/10.jpg)
SI SE SELECCIONA LINEA 100% APILADA
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 11: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/11.jpg)
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Linea
5,466 5,466 8,783 14,249 8,711 22,960
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
![Page 12: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/12.jpg)
PARA TRUJILLO 5,466 23.81% 23.81% 8,783 38.25% 62.06% 8,711 37.94% 100.00% 22,960
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 13: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/13.jpg)
Locales Ene Feb Mar TotalTrujillo 5,466 8,783 8,711 22,960
Arequipa 5,850 7,047 8,511 21,408 Chiclayo 8,596 7,216 8,147 23,959
Lima 5,478 8,973 8,307 22,758 Piura 5,273 5,105 5,035 15,413
Tumbes 6,256 5,394 8,717 20,367 Totales x Mes 36,919 42,518 47,428 126,865
3. Se desea Graficar las ventas totales de los locales gráficos circularesSeleccionar desde A1:A7 , presione control y sin soltarlo seleccione E1:E7
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Circular
SI SE SELECCIONA CIRCULAR 2D
SI SE SELECCIONA CIRCULAR 2D SECCIONADO
SI SE SELECCIONA CIRCULAR 2D CON SUBGRAFICO CIRCULAR
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 14: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/14.jpg)
SI SE SELECCIONA CIRCULAR 2D CON SUBGRAFICO DE BARRAS
SI SE SELECCIONA CIRCULAR 3D
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 15: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/15.jpg)
SI SE SELECCIONA CIRCULAR 3D SECCIONADOTotal
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 16: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/16.jpg)
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Circular
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 17: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/17.jpg)
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 18: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/18.jpg)
Total
TrujilloArequipaChiclayoLimaPiuraTumbes
![Page 19: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/19.jpg)
Locales Ene Feb Mar TotalTrujillo 5,466 8,783 8,711 22,960
Arequipa 5,850 7,047 8,511 21,408 Chiclayo 8,596 7,216 8,147 23,959
Lima 5,478 8,973 8,307 22,758 Piura 5,273 5,105 5,035 15,413
Tumbes 6,256 5,394 8,717 20,367 Totales x Mes 36,919 42,518 47,428 126,865
4. Se desea Graficar las ventas de los locales en los 3 meses indicados en gráficos de barrasSeleccionar desde A1:D7Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo BarraVamos a graficar los 3 tipos de barras 2D y 3D
SI SE SELECCIONA BARRA AGRUPADA
TAMBIEN SE PUEDE USAR LA OPCIONCAMBIAR ENTRE FILAS Y COLUMNAS
SI SE SELECCIONA BARRA APILADA
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 2,000 4,000 6,000 8,000 10,000
MarFebEne
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 5,000 10,000 15,000 20,000 25,000 30,000
EneFebMar
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
![Page 20: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/20.jpg)
SI SE SELECCIONA BARRA 100% APILADA
SI SE SELECCIONA BARRA 3D AGRUPADA
SI SE SELECCIONA BARRA 3D APILADA
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 2,000 4,000 6,000 8,000 10,000
MarFebEne
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 5,000 10,000 15,000 20,000 25,000
EneFebMar
![Page 21: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/21.jpg)
SI SE SELECCIONA BARRA 3D 100% APILADA
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
![Page 22: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/22.jpg)
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Barra
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 2,000 4,000 6,000 8,000 10,000
MarFebEne
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 5,000 10,000 15,000 20,000 25,000 30,000
EneFebMar
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
![Page 23: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/23.jpg)
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 2,000 4,000 6,000 8,000 10,000
MarFebEne
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
- 5,000 10,000 15,000 20,000 25,000
EneFebMar
![Page 24: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/24.jpg)
Trujillo
Arequipa
Chiclayo
Lima
Piura
Tumbes
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
EneFebMar
![Page 25: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/25.jpg)
Locales Ene Feb Mar TotalTrujillo 5,466 8,783 8,711 22,960
Arequipa 5,850 7,047 8,511 21,408 Chiclayo 8,596 7,216 8,147 23,959
Lima 5,478 8,973 8,307 22,758 Piura 5,273 5,105 5,035 15,413
Tumbes 6,256 5,394 8,717 20,367 Totales x Mes 36,919 42,518 47,428 126,865
5. Se desea Graficar las ventas de los locales en los 3 meses indicados en gráficos de AreasSeleccionar desde A1:D7Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo AreaVamos a graficar los 3 tipos de Areas barras 2D y 3D
SI SE SELECCIONA AREA 2D
SI SE SELECCIONA AREA 2D APILADA
SI SE SELECCIONA AREA 2D 100% APILADA
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 26: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/26.jpg)
SI SE SELECCIONA AREA 3D
SI SE SELECCIONA AREA 3D APILADA
SI SE SELECCIONA AREA 3D 100% APILADA
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes
-
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFeb
Mar
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes
-
5,000
10,000
15,000
20,000
25,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 27: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/27.jpg)
Trujillo Arequipa Chiclayo Lima Piura Tumbes
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 28: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/28.jpg)
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Area
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
10,000
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes -
5,000
10,000
15,000
20,000
25,000
30,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 29: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/29.jpg)
Trujillo Arequipa Chiclayo Lima Piura Tumbes0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes
-
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
EneFeb
Mar
EneFebMar
Trujillo Arequipa Chiclayo Lima Piura Tumbes
-
5,000
10,000
15,000
20,000
25,000
MarFebEne
Trujillo Arequipa Chiclayo Lima Piura Tumbes
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 30: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/30.jpg)
Trujillo Arequipa Chiclayo Lima Piura Tumbes
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
MarFebEne
![Page 31: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/31.jpg)
COTIZACION DEL DÓLAR 6. Se desea Graficar la cotización del dólar usando gráfico de dispersiónAugust - 2012 Seleccionar desde A3:C25
Día Compra Venta Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Dispersión1 2.628 2.629
2 2.624 2.625
3 2.628 2.63 SI SE SELECCIONA DISPERSION SOLO CON MARCADORES4 2.621 2.622
7 2.618 2.619
8 2.62 2.62
9 2.617 2.618
10 2.616 2.617
11 2.617 2.618
14 2.616 2.618
15 2.615 2.616
16 2.614 2.615
17 2.613 2.614
18 2.612 2.613
21 2.612 2.613
22 2.611 2.612
23 2.613 2.613
24 2.614 2.615
25 2.613 2.614
28 2.611 2.613
29 2.61 2.612 SI SE SELECCIONA DISPERSION SOLO CON LINEAS SUAVIZADAS Y MARCADORES30 2.609 2.61
FUENTE: SUNAT
SI SE SELECCIONA DISPERSION SOLO CON LINEAS SUAVIZADAS
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 32: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/32.jpg)
SI SE SELECCIONA DISPERSION SOLO CON LINEAS LINEAS RECTAS Y MARCADORES
SI SE SELECCIONA DISPERSION SOLO CON LINEAS LINEAS RECTAS
EL MISMO GRAFICO ANTERIOR PERO CAMBIANDO LA ESCALA DEL EJE HORIZONTAL
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 33: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/33.jpg)
SOLO HAY QUE DAR DOBLE CLIC EN EL EJE HORIZONTAL Y CAMBIAR
MAXIMA A FIJA Y COLOCAR 31UNIDAD MAYOR A FIJA E INDICAR 1LUEGO CERRAR
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 312.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 34: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/34.jpg)
PARA AGREGAR LINEA DE TENDENCIA POR EJEMPLO PARA LA VENTA DE CLIC DERECHO EN EL GRAFICO DE LA VENTA Y SELECCIONEAGREGAR LINEA DE TENDENCIA, OBSERVARA EL SIGUIENTE CUADRO
DEJAR LA TENDENCIA EN LINEAL Y EN LA PARTE DE ABAJO SELECCIONE PRESENTAR ECUACION…. Y PRESENTAR EL VALOR R…LUEGO CLIC EN CERRAR
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 312.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
f(x) = − 0.000523534140712117 x + 2.62511050024636R² = 0.790390908816656f(x) = − 0.000523534140712117 x + 2.62511050024636R² = 0.790390908816656
CompraVentaLinear (Venta)Linear (Venta)Linear (Venta)
![Page 35: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/35.jpg)
![Page 36: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/36.jpg)
6. Se desea Graficar la cotización del dólar usando gráfico de dispersión
Ir a Ficha Insertar y en Grupo GRAFICOS seleccionar el tipo de grafico principal, en este ejemplo Dispersión
SI SE SELECCIONA DISPERSION SOLO CON MARCADORES
SI SE SELECCIONA DISPERSION SOLO CON LINEAS SUAVIZADAS Y MARCADORES
SI SE SELECCIONA DISPERSION SOLO CON LINEAS SUAVIZADAS
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 37: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/37.jpg)
SI SE SELECCIONA DISPERSION SOLO CON LINEAS LINEAS RECTAS Y MARCADORES
SI SE SELECCIONA DISPERSION SOLO CON LINEAS LINEAS RECTAS
EL MISMO GRAFICO ANTERIOR PERO CAMBIANDO LA ESCALA DEL EJE HORIZONTAL
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
0 5 10 15 20 25 30 352.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 38: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/38.jpg)
SOLO HAY QUE DAR DOBLE CLIC EN EL EJE HORIZONTAL Y CAMBIAR
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 312.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
CompraVenta
![Page 39: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/39.jpg)
PARA AGREGAR LINEA DE TENDENCIA POR EJEMPLO PARA LA VENTA DE CLIC DERECHO EN EL GRAFICO DE LA VENTA Y SELECCIONEAGREGAR LINEA DE TENDENCIA, OBSERVARA EL SIGUIENTE CUADRO
DEJAR LA TENDENCIA EN LINEAL Y EN LA PARTE DE ABAJO SELECCIONE PRESENTAR ECUACION…. Y PRESENTAR EL VALOR R…
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 312.595
2.6
2.605
2.61
2.615
2.62
2.625
2.63
2.635
f(x) = − 0.000523534140712117 x + 2.62511050024636R² = 0.790390908816656f(x) = − 0.000523534140712117 x + 2.62511050024636R² = 0.790390908816656
CompraVentaLinear (Venta)Linear (Venta)Linear (Venta)
![Page 40: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/40.jpg)
![Page 41: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/41.jpg)
PRIMERO SE LLENA LOS VALORES CORRESPONDIENTES A X, EN EL EJEMPLO SE HA INDICAO DESDE -100 a 100X Y CON INCREMENTOS DE +5
-100 19901 SELECCIÓNE A3:B44-95 17956 LUEGO SELECCIONE EL TIPO DE GRAFICO DE DISPERSION CON LINEAS SUAVIZADAS-90 16111-85 14366-80 12721-75 11176-70 9731-65 8386-60 7141-55 5996-50 4951-45 4006-40 3161-35 2416-30 1771-25 1226-20 781-15 436-10 191
-5 460 15 56
10 21115 46620 82125 127630 183135 248640 324145 409650 505155 610660 726165 851670 987175 1132680 1288185 1453690 1629195 18146
100 20101
GRAFICAR: Y = SENO(X)
GRAFICAR: Y = 2X2 + X - 1
-150 -100 -50 0 50 100 1500
5000
10000
15000
20000
25000
Y
Y
![Page 42: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/42.jpg)
X Y-360 2.4503E-16-355 0.08715574-350 0.17364818-345 0.25881905-340 0.34202014-335 0.42261826-330 0.5-325 0.57357644-320 0.64278761-315 0.70710678-310 0.76604444-305 0.81915204-300 0.8660254-295 0.90630779-290 0.93969262-285 0.96592583-280 0.98480775-275 0.9961947-270 1-265 0.9961947-260 0.98480775-255 0.96592583-250 0.93969262-245 0.90630779-240 0.8660254-235 0.81915204-230 0.76604444-225 0.70710678-220 0.64278761-215 0.57357644-210 0.5-205 0.42261826-200 0.34202014-195 0.25881905-190 0.17364818-185 0.08715574-180 -1.2246E-16-175 -0.08715574-170 -0.17364818-165 -0.25881905-160 -0.34202014-155 -0.42261826-150 -0.5-145 -0.57357644-140 -0.64278761-135 -0.70710678-130 -0.76604444
-400 -300 -200 -100 0 100 200 300 400
-1.5
-1
-0.5
0
0.5
1
1.5
SENO
Y
-400 -300 -200 -100 0 100 200 300 400
-1.5
-1
-0.5
0
0.5
1
1.5
COSENO
Y
-400 -300 -200 -100 0 100 200 300 400
-2E+016
-1.5E+016
-1E+016
-5000000000000000
0
5000000000000000
1E+016
1.5E+016
2E+016
TANGENTE
Y
![Page 43: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/43.jpg)
-125 -0.81915204-120 -0.8660254-115 -0.90630779-110 -0.93969262-105 -0.96592583-100 -0.98480775
-95 -0.9961947-90 -1-85 -0.9961947-80 -0.98480775-75 -0.96592583-70 -0.93969262-65 -0.90630779-60 -0.8660254-55 -0.81915204-50 -0.76604444-45 -0.70710678-40 -0.64278761-35 -0.57357644-30 -0.5-25 -0.42261826-20 -0.34202014-15 -0.25881905-10 -0.17364818
-5 -0.087155740 05 0.08715574
10 0.1736481815 0.2588190520 0.3420201425 0.4226182630 0.535 0.5735764440 0.6427876145 0.7071067850 0.7660444455 0.8191520460 0.866025465 0.9063077970 0.9396926275 0.9659258380 0.9848077585 0.996194790 195 0.9961947
100 0.98480775105 0.96592583110 0.93969262
![Page 44: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/44.jpg)
115 0.90630779120 0.8660254125 0.81915204130 0.76604444135 0.70710678140 0.64278761145 0.57357644150 0.5155 0.42261826160 0.34202014165 0.25881905170 0.17364818175 0.08715574180 1.22465E-16185 -0.08715574190 -0.17364818195 -0.25881905200 -0.34202014205 -0.42261826210 -0.5215 -0.57357644220 -0.64278761225 -0.70710678230 -0.76604444235 -0.81915204240 -0.8660254245 -0.90630779250 -0.93969262255 -0.96592583260 -0.98480775265 -0.9961947270 -1275 -0.9961947280 -0.98480775285 -0.96592583290 -0.93969262295 -0.90630779300 -0.8660254305 -0.81915204310 -0.76604444315 -0.70710678320 -0.64278761325 -0.57357644330 -0.5335 -0.42261826340 -0.34202014345 -0.25881905350 -0.17364818
![Page 45: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/45.jpg)
355 -0.08715574360 -2.4493E-16
GRAFICAR Y = LN(X)
X Y0.5 -0.69314718
1 01.5 0.40546511
2 0.693147182.5 0.91629073
3 1.098612293.5 1.25276297
4 1.386294364.5 1.5040774
5 1.609437915.5 1.70474809
6 1.791759476.5 1.87180218
7 1.945910157.5 2.01490302
8 2.079441548.5 2.14006616
9 2.197224589.5 2.251291810 2.30258509
10.5 2.3513752611 2.39789527
11.5 2.4423470412 2.48490665
12.5 2.5257286413 2.56494936
13.5 2.6026896914 2.63905733
14.5 2.6741486515 2.7080502
15.5 2.7408400216 2.77258872
16.5 2.8033603817 2.83321334
17.5 2.8622008818 2.89037176
18.5 2.9177707319 2.94443898
19.5 2.9704144720 2.99573227
20.5 3.02042489
0 20 40 60 80 100 120-1
0
1
2
3
4
5
Y = LN(X)
Y
0 20 40 60 80 100 120-0.5
0
0.5
1
1.5
2
2.5
Y = LOG(X)
Y
-15 -10 -5 0 5 10 15
-1500
-1000
-500
0
500
1000
1500
Y = X3
Y
![Page 46: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/46.jpg)
21 3.0445224421.5 3.06805294
22 3.0910424522.5 3.11351531
23 3.1354942223.5 3.15700042
24 3.1780538324.5 3.19867312
25 3.2188758225.5 3.23867845
26 3.2580965426.5 3.27714473
27 3.2958368727.5 3.314186
28 3.3322045128.5 3.34990409
29 3.3672958329.5 3.38439026
30 3.4011973830.5 3.41772668
31 3.433987231.5 3.44998755
32 3.465735932.5 3.48124009
33 3.4965075633.5 3.51154544
34 3.5263605234.5 3.54095932
35 3.5553480635.5 3.5695327
36 3.5835189436.5 3.59731226
37 3.6109179137.5 3.62434093
38 3.6375861638.5 3.65065824
39 3.6635616539.5 3.67630067
40 3.6888794540.5 3.70130197
41 3.7135720741.5 3.72569343
42 3.7376696242.5 3.74950408
43 3.7612001243.5 3.77276094
44 3.7841896344.5 3.79548919
-15 -10 -5 0 5 10 15
-1500
-1000
-500
0
500
1000
1500
Y = X3
Y
![Page 47: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/47.jpg)
45 3.8066624945.5 3.81771233
46 3.828641446.5 3.83945231
47 3.850147647.5 3.86072971
48 3.8712010148.5 3.8815638
49 3.891820349.5 3.90197267
50 3.9120230150.5 3.92197334
51 3.9318256351.5 3.94158181
52 3.9512437252.5 3.96081317
53 3.9702919153.5 3.97968165
54 3.9889840554.5 3.9982007
55 4.0073331955.5 4.01638302
56 4.0253516956.5 4.03424064
57 4.0430512757.5 4.05178495
58 4.0604430158.5 4.06902675
59 4.0775374459.5 4.08597631
60 4.0943445660.5 4.10264337
61 4.1108738661.5 4.11903717
62 4.1271343962.5 4.13516656
63 4.1431347363.5 4.15103991
64 4.1588830864.5 4.16666522
65 4.1743872765.5 4.18205014
66 4.1896547466.5 4.19720195
67 4.2046926267.5 4.2121276
68 4.2195077168.5 4.22683375
![Page 48: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/48.jpg)
69 4.234106569.5 4.24132675
70 4.2484952470.5 4.25561271
71 4.2626798871.5 4.26969745
72 4.2766661272.5 4.28358656
73 4.2904594473.5 4.29728541
74 4.3040650974.5 4.31079913
75 4.3174881175.5 4.32413266
76 4.3307333476.5 4.33729074
77 4.3438054277.5 4.35027794
78 4.3567088378.5 4.36309862
79 4.3694478579.5 4.37575702
80 4.3820266380.5 4.38825718
81 4.3944491581.5 4.40060302
82 4.4067192582.5 4.41279829
83 4.4188406183.5 4.42484663
84 4.430816884.5 4.43675153
85 4.4426512685.5 4.44851638
86 4.454347386.5 4.46014441
87 4.4659081287.5 4.47163879
88 4.4773368188.5 4.48300255
89 4.4886363789.5 4.49423863
90 4.4998096790.5 4.50534985
91 4.5108595191.5 4.51633897
92 4.5217885892.5 4.52720864
![Page 49: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/49.jpg)
93 4.5325994993.5 4.53796144
94 4.5432947894.5 4.54859983
95 4.5538768995.5 4.55912625
96 4.5643481996.5 4.56954301
97 4.5747109897.5 4.57985238
98 4.5849674898.5 4.59005655
99 4.5951198599.5 4.60015764100 4.60517019
![Page 50: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/50.jpg)
PRIMERO SE LLENA LOS VALORES CORRESPONDIENTES A X, EN EL EJEMPLO SE HA INDICAO DESDE -100 a 100
LUEGO SELECCIONE EL TIPO DE GRAFICO DE DISPERSION CON LINEAS SUAVIZADAS
GRAFICAR: Y = COS(X) GRAFICAR: Y = TAN(X)
-150 -100 -50 0 50 100 1500
5000
10000
15000
20000
25000
Y
Y
![Page 51: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/51.jpg)
X Y X Y-360 1 -360 2.4503E-16-355 0.9961947 -355 0.08748866-350 0.98480775 -350 0.17632698-345 0.96592583 -345 0.26794919-340 0.93969262 -340 0.36397023-335 0.90630779 -335 0.46630766-330 0.8660254 -330 0.57735027-325 0.81915204 -325 0.70020754-320 0.76604444 -320 0.83909963-315 0.70710678 -315 1-310 0.64278761 -310 1.19175359-305 0.57357644 -305 1.42814801-300 0.5 -300 1.73205081-295 0.42261826 -295 2.14450692-290 0.34202014 -290 2.74747742-285 0.25881905 -285 3.73205081-280 0.17364818 -280 5.67128182-275 0.08715574 -275 11.4300523-270 -1.837E-16 -270 -5.4437E+15-265 -0.08715574 -265 -11.4300523-260 -0.17364818 -260 -5.67128182-255 -0.25881905 -255 -3.73205081-250 -0.34202014 -250 -2.74747742-245 -0.42261826 -245 -2.14450692-240 -0.5 -240 -1.73205081-235 -0.57357644 -235 -1.42814801-230 -0.64278761 -230 -1.19175359-225 -0.70710678 -225 -1-220 -0.76604444 -220 -0.83909963-215 -0.81915204 -215 -0.70020754-210 -0.8660254 -210 -0.57735027-205 -0.90630779 -205 -0.46630766-200 -0.93969262 -200 -0.36397023-195 -0.96592583 -195 -0.26794919-190 -0.98480775 -190 -0.17632698-185 -0.9961947 -185 -0.08748866-180 -1 -180 1.22465E-16-175 -0.9961947 -175 0.08748866-170 -0.98480775 -170 0.17632698-165 -0.96592583 -165 0.26794919-160 -0.93969262 -160 0.36397023-155 -0.90630779 -155 0.46630766-150 -0.8660254 -150 0.57735027-145 -0.81915204 -145 0.70020754-140 -0.76604444 -140 0.83909963-135 -0.70710678 -135 1-130 -0.64278761 -130 1.19175359
-400 -300 -200 -100 0 100 200 300 400
-1.5
-1
-0.5
0
0.5
1
1.5
SENO
Y
-400 -300 -200 -100 0 100 200 300 400
-1.5
-1
-0.5
0
0.5
1
1.5
COSENO
Y
-400 -300 -200 -100 0 100 200 300 400
-2E+016
-1.5E+016
-1E+016
-5000000000000000
0
5000000000000000
1E+016
1.5E+016
2E+016
TANGENTE
Y
![Page 52: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/52.jpg)
-125 -0.57357644 -125 1.42814801-120 -0.5 -120 1.73205081-115 -0.42261826 -115 2.14450692-110 -0.34202014 -110 2.74747742-105 -0.25881905 -105 3.73205081-100 -0.17364818 -100 5.67128182
-95 -0.08715574 -95 11.4300523-90 6.12323E-17 -90 -1.6331E+16-85 0.08715574 -85 -11.4300523-80 0.17364818 -80 -5.67128182-75 0.25881905 -75 -3.73205081-70 0.34202014 -70 -2.74747742-65 0.42261826 -65 -2.14450692-60 0.5 -60 -1.73205081-55 0.57357644 -55 -1.42814801-50 0.64278761 -50 -1.19175359-45 0.70710678 -45 -1-40 0.76604444 -40 -0.83909963-35 0.81915204 -35 -0.70020754-30 0.8660254 -30 -0.57735027-25 0.90630779 -25 -0.46630766-20 0.93969262 -20 -0.36397023-15 0.96592583 -15 -0.26794919-10 0.98480775 -10 -0.17632698
-5 0.9961947 -5 -0.087488660 1 0 05 0.9961947 5 0.08748866
10 0.98480775 10 0.1763269815 0.96592583 15 0.2679491920 0.93969262 20 0.3639702325 0.90630779 25 0.4663076630 0.8660254 30 0.5773502735 0.81915204 35 0.7002075440 0.76604444 40 0.8390996345 0.70710678 45 150 0.64278761 50 1.1917535955 0.57357644 55 1.4281480160 0.5 60 1.7320508165 0.42261826 65 2.1445069270 0.34202014 70 2.7474774275 0.25881905 75 3.7320508180 0.17364818 80 5.6712818285 0.08715574 85 11.430052390 6.12323E-17 90 1.6331E+1695 -0.08715574 95 -11.4300523
100 -0.17364818 100 -5.67128182105 -0.25881905 105 -3.73205081110 -0.34202014 110 -2.74747742
![Page 53: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/53.jpg)
115 -0.42261826 115 -2.14450692120 -0.5 120 -1.73205081125 -0.57357644 125 -1.42814801130 -0.64278761 130 -1.19175359135 -0.70710678 135 -1140 -0.76604444 140 -0.83909963145 -0.81915204 145 -0.70020754150 -0.8660254 150 -0.57735027155 -0.90630779 155 -0.46630766160 -0.93969262 160 -0.36397023165 -0.96592583 165 -0.26794919170 -0.98480775 170 -0.17632698175 -0.9961947 175 -0.08748866180 -1 180 -1.2246E-16185 -0.9961947 185 0.08748866190 -0.98480775 190 0.17632698195 -0.96592583 195 0.26794919200 -0.93969262 200 0.36397023205 -0.90630779 205 0.46630766210 -0.8660254 210 0.57735027215 -0.81915204 215 0.70020754220 -0.76604444 220 0.83909963225 -0.70710678 225 1230 -0.64278761 230 1.19175359235 -0.57357644 235 1.42814801240 -0.5 240 1.73205081245 -0.42261826 245 2.14450692250 -0.34202014 250 2.74747742255 -0.25881905 255 3.73205081260 -0.17364818 260 5.67128182265 -0.08715574 265 11.4300523270 -1.837E-16 270 5.4437E+15275 0.08715574 275 -11.4300523280 0.17364818 280 -5.67128182285 0.25881905 285 -3.73205081290 0.34202014 290 -2.74747742295 0.42261826 295 -2.14450692300 0.5 300 -1.73205081305 0.57357644 305 -1.42814801310 0.64278761 310 -1.19175359315 0.70710678 315 -1320 0.76604444 320 -0.83909963325 0.81915204 325 -0.70020754330 0.8660254 330 -0.57735027335 0.90630779 335 -0.46630766340 0.93969262 340 -0.36397023345 0.96592583 345 -0.26794919350 0.98480775 350 -0.17632698
![Page 54: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/54.jpg)
355 0.9961947 355 -0.08748866360 1 360 -2.4493E-16
GRAFICAR Y = LOG(X)
X Y X Y0.5 -0.30103 -10 -1000
1 0 -9 -7291.5 0.17609126 -8 -512
2 0.30103 -7 -3432.5 0.39794001 -6 -216
3 0.47712125 -5 -1253.5 0.54406804 -4 -64
4 0.60205999 -3 -274.5 0.65321251 -2 -8
5 0.69897 -1 -15.5 0.74036269 0 0
6 0.77815125 1 16.5 0.81291336 2 8
7 0.84509804 3 277.5 0.87506126 4 64
8 0.90308999 5 1258.5 0.92941893 6 216
9 0.95424251 7 3439.5 0.97772361 8 51210 1 9 729
10.5 1.0211893 10 100011 1.04139269
11.5 1.0606978412 1.07918125
12.5 1.0969100113 1.11394335
13.5 1.1303337714 1.14612804
14.5 1.16136815 1.17609126
15.5 1.190331716 1.20411998
16.5 1.2174839417 1.23044892
17.5 1.2430380518 1.25527251
18.5 1.2671717319 1.2787536
19.5 1.2900346120 1.30103
GRAFICAR Y = X3
0 20 40 60 80 100 120-1
0
1
2
3
4
5
Y = LN(X)
Y
0 20 40 60 80 100 120-0.5
0
0.5
1
1.5
2
2.5
Y = LOG(X)
Y
-15 -10 -5 0 5 10 15
-1500
-1000
-500
0
500
1000
1500
Y = X3
Y
![Page 55: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/55.jpg)
20.5 1.3117538621 1.32221929
21.5 1.3324384622 1.34242268
22.5 1.3521825223 1.36172784
23.5 1.3710678624 1.38021124
24.5 1.3891660825 1.39794001
25.5 1.4065401826 1.41497335
26.5 1.4232458727 1.43136376
27.5 1.4393326928 1.44715803
28.5 1.4548448629 1.462398
29.5 1.4698220230 1.47712125
30.5 1.4842998431 1.49136169
31.5 1.4983105532 1.50514998
32.5 1.5118833633 1.51851394
33.5 1.5250448134 1.53147892
34.5 1.537819135 1.54406804
35.5 1.5502283536 1.5563025
36.5 1.5622928637 1.56820172
37.5 1.5740312738 1.5797836
38.5 1.5854607339 1.59106461
39.5 1.596597140 1.60205999
40.5 1.6074550241 1.61278386
41.5 1.618048142 1.62324929
42.5 1.6283889343 1.63346846
43.5 1.6384892644 1.64345268
-15 -10 -5 0 5 10 15
-1500
-1000
-500
0
500
1000
1500
Y = X3
Y
![Page 56: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/56.jpg)
44.5 1.6483600145 1.65321251
45.5 1.658011446 1.66275783
46.5 1.6674529547 1.67209786
47.5 1.6766936148 1.68124124
48.5 1.6857417449 1.69019608
49.5 1.694605250 1.69897
50.5 1.7032913851 1.70757018
51.5 1.7118072352 1.71600334
52.5 1.720159353 1.72427587
53.5 1.7283537854 1.73239376
54.5 1.736396555 1.74036269
55.5 1.7442929856 1.74818803
56.5 1.7520484557 1.75587486
57.5 1.7596678458 1.76342799
58.5 1.7671558759 1.77085201
59.5 1.7745169760 1.77815125
60.5 1.7817553761 1.78532984
61.5 1.7888751262 1.79239169
62.5 1.7958800263 1.79934055
63.5 1.8027737364 1.80617997
64.5 1.8095597165 1.81291336
65.5 1.816241366 1.81954394
66.5 1.8228216567 1.8260748
67.5 1.8293037768 1.83250891
![Page 57: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/57.jpg)
68.5 1.8356905769 1.83884909
69.5 1.841984870 1.84509804
70.5 1.8481891271 1.85125835
71.5 1.8543060472 1.8573325
72.5 1.8603380173 1.86332286
73.5 1.8662873474 1.86923172
74.5 1.8721562775 1.87506126
75.5 1.8779469576 1.88081359
76.5 1.8836614477 1.88649073
77.5 1.889301778 1.8920946
78.5 1.8948696679 1.89762709
79.5 1.9003671380 1.90308999
80.5 1.9057958881 1.90848502
81.5 1.9111576182 1.91381385
82.5 1.9164539583 1.91907809
83.5 1.9216864884 1.92427929
84.5 1.9268567185 1.92941893
85.5 1.9319661186 1.93449845
86.5 1.9370161187 1.93951925
87.5 1.9420080588 1.94448267
88.5 1.9469432789 1.94939001
89.5 1.9518230490 1.95424251
90.5 1.9566485891 1.95904139
91.5 1.9614210992 1.96378783
![Page 58: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/58.jpg)
92.5 1.9661417393 1.96848295
93.5 1.9708116194 1.97312785
94.5 1.9754318195 1.97772361
95.5 1.9800033796 1.98227123
96.5 1.9845273197 1.98677173
97.5 1.9890046298 1.99122608
98.5 1.9934362399 1.99563519
99.5 1.99782308100 2
![Page 59: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/59.jpg)
ACCIONES ALICORP S.A.A. - 2012 SELECCIONE A3:A42, PRESIONE CTRL Y SELECCIONE C3:E42CLIC EN FICHA INSERTAR / GRUPO GRAFICOS OTROS / COTIZACIONES
cotización Apertura Máxima Mínima Cierre SI SE SELECCIONA EL PRIMERO: MAXIMOS, MINIMOS, CIERRE01/08 6.7 6.7 6.6 6.6502/08 6.65 6.65 6.6 6.603/08 6.7 6.79 6.65 6.7906/08 6.75 6.75 6.7 6.707/08 6.7 6.85 6.7 6.8508/08 6.8 6.8 6.75 6.7509/08 6.75 6.75 6.7 6.7510/08 6.75 6.8 6.72 6.7513/08 6.75 6.75 6.66 6.6614/08 6.67 6.67 6.67 6.6715/08 6.76 6.76 6.7 6.716/08 6.85 6.85 6.85 6.8517/08 6.85 6.85 6.83 6.8320/08 6.81 6.81 6.8 6.8121/08 6.85 6.85 6.78 6.7822/08 6.77 6.77 6.77 6.7723/08 6.77 6.77 6.66 6.6624/08 6.67 6.68 6.67 6.6827/08 6.68 6.82 6.68 6.8228/08 6.82 6.82 6.73 6.7329/08 6.77 6.77 6.77 6.7731/08 6.77 6.84 6.73 6.7303/09 6.73 6.77 6.73 6.7704/09 6.77 6.77 6.74 6.7505/09 6.76 6.77 6.76 6.7706/09 6.77 6.77 6.73 6.7307/09 6.76 6.8 6.76 6.7710/09 6.77 6.82 6.77 6.8211/09 6.82 6.88 6.82 6.8812/09 6.87 6.87 6.85 6.8513/09 6.85 7.02 6.85 714/09 7.1 7.18 7.05 7.1817/09 7.18 7.18 7.15 7.1518/09 7.14 7.14 7.14 7.1419/09 7.13 7.13 7.05 7.0520/09 7.02 7.02 6.92 6.9221/09 6.95 7.1 6.95 7.124/0925/09 7.1 7.12 7.05 7.1 SELECCIONE A3:E42
CLIC EN FICHA INSERTAR / GRUPO GRAFICOS OTROS / COTIZACIONESSI SE SELECCIONA EL SEGUNDO: APERTURA,MAXIMOS, MINIMOS, CIERRE
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre
31/0
701
/08
02/0
803
/08
04/0
805
/08
06/0
807
/08
08/0
809
/08
10/0
811
/08
12/0
813
/08
14/0
815
/08
16/0
817
/08
18/0
819
/08
20/0
821
/08
22/0
823
/08
24/0
825
/08
26/0
827
/08
28/0
829
/08
30/0
831
/08
01/0
902
/09
03/0
904
/09
05/0
906
/09
07/0
908
/09
09/0
910
/09
11/0
912
/09
13/0
914
/09
15/0
916
/09
17/0
918
/09
19/0
920
/09
21/0
922
/09
23/0
924
/09
25/0
926
/09
6.3
6.4
6.5
6.6
6.7
6.8
6.9
7
7.1
7.2
7.3
Cierre
Cierre
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre
![Page 60: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/60.jpg)
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre
![Page 61: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/61.jpg)
SELECCIONE A3:A42, PRESIONE CTRL Y SELECCIONE C3:E42CLIC EN FICHA INSERTAR / GRUPO GRAFICOS OTROS / COTIZACIONESSI SE SELECCIONA EL PRIMERO: MAXIMOS, MINIMOS, CIERRE
CLIC EN FICHA INSERTAR / GRUPO GRAFICOS OTROS / COTIZACIONESSI SE SELECCIONA EL SEGUNDO: APERTURA,MAXIMOS, MINIMOS, CIERRE
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre
31/0
701
/08
02/0
803
/08
04/0
805
/08
06/0
807
/08
08/0
809
/08
10/0
811
/08
12/0
813
/08
14/0
815
/08
16/0
817
/08
18/0
819
/08
20/0
821
/08
22/0
823
/08
24/0
825
/08
26/0
827
/08
28/0
829
/08
30/0
831
/08
01/0
902
/09
03/0
904
/09
05/0
906
/09
07/0
908
/09
09/0
910
/09
11/0
912
/09
13/0
914
/09
15/0
916
/09
17/0
918
/09
19/0
920
/09
21/0
922
/09
23/0
924
/09
25/0
926
/09
6.3
6.4
6.5
6.6
6.7
6.8
6.9
7
7.1
7.2
7.3
Cierre
Cierre
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre
![Page 62: GRAFICOS. EJEMPLOS. INFORMATICA.xlsx](https://reader035.vdocumento.com/reader035/viewer/2022081503/563dba3c550346aa9aa3d7b0/html5/thumbnails/62.jpg)
01/0803/0
805/0
807/0
809/0
811/0
813/0
815/0
817/0
819/0
821/0
823/0
825/0
827/0
829/0
831/0
802/0
904/0
906/0
908/0
910/0
912/0
914/0
916/0
918/0
920/0
922/0
924/0
90
5
10
15
20
25
30
35
40
45
Cierre