GRAFICO

Post on 14-Apr-2016

4 views 0 download

description

practica de excel graficos de venta

transcript

INGRESO DE LOS 6 PRIMEROS MESES-GRPUPO PERUEnero Febrero Marzo Abril

Windows S/. 2,503.00 S/. 3,941.00 S/. 4,527.00 S/. 1,987.00 Word S/. 2,263.00 S/. 4,714.00 S/. 3,370.00 S/. 8,764.00 Excel S/. 2,606.00 S/. 1,795.00 S/. 1,860.00 S/. 5,356.00 Access S/. 3,912.00 S/. 4,272.00 S/. 1,997.00 S/. 3,532.00 Corel S/. 4,944.00 S/. 3,277.00 S/. 1,982.00 S/. 2,456.00 Power Point S/. 2,583.00 S/. 3,030.00 S/. 3,854.00 S/. 3,357.00

Enero Febrero Marzo Abril Mayo Junio S/.-

S/.1,000.00 S/.2,000.00 S/.3,000.00 S/.4,000.00 S/.5,000.00 S/.6,000.00 S/.7,000.00 S/.8,000.00 S/.9,000.00

S/.10,000.00

INGRESO SEMESTRAL

Windows Word Excel

Access Corel Power Point

INGRESO DE LOS 6 PRIMEROS MESES-GRPUPO PERU Millones de DolaresMayo Junio 2011 2012 S/. 3,941.00 S/. 3,423.00 Microsoft $ 18,883.00 $ 21,999.00 S/. 3,322.00 S/. 3,370.00 Apple $ 17,989.00 $ 21,898.00 S/. 4,522.00 S/. 4,245.00 Google $ 16,987.00 $ 21,780.00 S/. 8,642.00 S/. 1,997.00 S/. 1,325.00 S/. 2,322.00 S/. 6,432.00 S/. 3,854.00

Enero Febrero Marzo Abril Mayo Junio S/.-

S/.1,000.00 S/.2,000.00 S/.3,000.00 S/.4,000.00 S/.5,000.00 S/.6,000.00 S/.7,000.00 S/.8,000.00 S/.9,000.00

S/.10,000.00

INGRESO SEMESTRAL

Windows Word Excel

Access Corel Power Point

2011 2012 2013 $-

$5,000.00

$10,000.00

$15,000.00

$20,000.00

$25,000.00

$30,000.00

VENTAS ANUALES

Microsoft Apple Google

Años

Millones de Dolares

2013 Total $ 23,988.00 $ 64,870.00 $ 25,879.00 $ 65,766.00 $ 24,657.00 $ 63,424.00

2011 2012 2013 $-

$5,000.00

$10,000.00

$15,000.00

$20,000.00

$25,000.00

$30,000.00

VENTAS POR AÑO

Microsoft Apple Google

$64,870.00

$65,766.00

$63,424.00

CRECIMIENTO EN 3 AÑOS

Microsoft Apple Google

2011 2012 2013 $-

$5,000.00

$10,000.00

$15,000.00

$20,000.00

$25,000.00

$30,000.00

VENTAS ANUALES

Microsoft Apple Google

Años

Millones de Dolares

2011 2012 2013 $-

$5,000.00

$10,000.00

$15,000.00

$20,000.00

$25,000.00

$30,000.00

VENTAS POR AÑO

Microsoft Apple Google

$64,870.00

$65,766.00

$63,424.00

CRECIMIENTO EN 3 AÑOS

Microsoft Apple Google

INGRESO DE LOS 6 PRIMEROS MESES-GRPUPO PERUEnero Febrero Marzo Abril

Windows S/. 2,503.00 S/. 3,941.00 S/. 4,527.00 S/. 1,987.00 Word S/. 2,263.00 S/. 4,714.00 S/. 3,370.00 S/. 8,764.00 Excel S/. 2,606.00 S/. 1,795.00 S/. 1,860.00 S/. 5,356.00 Access S/. 3,912.00 S/. 4,272.00 S/. 1,997.00 S/. 3,532.00 Corel S/. 4,944.00 S/. 3,277.00 S/. 1,982.00 S/. 2,456.00 Power Point S/. 2,583.00 S/. 3,030.00 S/. 3,854.00 S/. 3,357.00

INGRESO DE LOS 6 PRIMEROS MESES-GRPUPO PERU Millones de DolaresMayo Junio 2011 2012 S/. 3,941.00 S/. 3,423.00 Microsoft $ 18,883.00 $ 21,999.00 S/. 3,322.00 S/. 3,370.00 Apple $ 17,989.00 $ 21,898.00 S/. 4,522.00 S/. 4,245.00 Google $ 16,987.00 $ 21,780.00 S/. 8,642.00 S/. 1,997.00 S/. 1,325.00 S/. 2,322.00 S/. 6,432.00 S/. 3,854.00

2013 Total $ 23,988.00 $ 64,870.00 $ 25,879.00 $ 65,766.00 $ 24,657.00 $ 63,424.00

Primavera Verano Otoño Invierno0

1000

2000

3000

4000

5000

6000

7000

8000

9000

Chart Title

Golf tenis Balonc Futbol Gimnasia

Primavera Verano Otoño Invierno0

1000

2000

3000

4000

5000

6000

7000

8000

9000

Chart Title

Golf tenis Balonc Futbol Gimnasia

Formato de Serie de datos

Productos Primavera Verano Otoño InviernoGolf 4200 4700 3820 4171tenis 5000 6000 4750 5138Balonc 2400 8000 4840 4642Futbol 3000 4000 3050 3253Gimnasia 1000 2000 1350 1368

Primavera

Verano

Otoño

Invierno

0 5000 10000 15000 20000 25000

Cia Full Sport

Golf tenis Balonc Futbol Gimnasia

Total16891208881988213303

5718

Primavera

Verano

Otoño

Invierno

0 5000 10000 15000 20000 25000

Cia Full Sport

Golf tenis Balonc Futbol Gimnasia

Enero Febrero Marzo Abril MayoWindows 2,503.00 3,941.00 4,527.00 1,987.00 3,941.00 Word 2,263.00 4,714.00 3,370.00 8,764.00 3,322.00 Excel 2,606.00 1,795.00 1,860.00 5,356.00 4,522.00 Access 3,912.00 4,272.00 1,997.00 3,532.00 8,642.00 Corel 4,944.00 3,277.00 1,982.00 2,456.00 1,325.00 Power Point 2,583.00 3,030.00 3,854.00 3,357.00 6,432.00

Junio 3,423.00 3,370.00 4,245.00 1,997.00 2,322.00 3,854.00

Enero Febrero Marzo Abril Mayo Junio -

1,000.00 2,000.00 3,000.00 4,000.00 5,000.00 6,000.00 7,000.00 8,000.00 9,000.00

Windows

Word

Excel

Access

Corel

Power Point

Chart Title

Windows Word Excel Access Corel Power Point

Enero Febrero Marzo Abril Mayo Junio -

1,000.00 2,000.00 3,000.00 4,000.00 5,000.00 6,000.00 7,000.00 8,000.00 9,000.00

Windows

Word

Excel

Access

Corel

Power Point

Chart Title

Windows Word Excel Access Corel Power Point