Pivot excel

Date post:27-Feb-2018
Category:
View:233 times
Download:0 times
Share this document with a friend
Transcript:
  • 7/25/2019 Pivot excel

    1/19

    Rezultatul brut al exercitiului (mil.lei)

    Sector 2008 2009

    TOTAL 32534 13088

    INDUSTRIE 9171 2484

    CONSTRUCII 5156 3017COMER 9400 3495

    SERVICII 8807 4092

  • 7/25/2019 Pivot excel

    2/19

    2010 2011 2012 2013 2014 1)

    5732 15649 19753 27934 34957

    6042 9255 8638 14081 12477

    1005 763 -623 482 1494

    248 4861 5864 7260 10469

    -1563 769 5874 6111 10517

  • 7/25/2019 Pivot excel

    3/19

  • 7/25/2019 Pivot excel

    4/19

    Sum of 2013 Sum of 2014 1)

    260 10469

    482 1494

    14081 1246111 1051

    2934 3495

    55868 69914

  • 7/25/2019 Pivot excel

    5/19

    Numar de intreprinderi

    Sector 2008 2009 2010 2011 2012 2013

    TOTAL 534525 519441 470080 430608 447938 461484

    INDUSTRIE 61260 58853 53448 49715 50896 52233

    CONSTRUC 59389 60135 49348 43503 44447 45382

    COMER 214138 197611 181903 165100 169133 171259

    SERVICII 199738 202842 185381 172290 183462 192610

  • 7/25/2019 Pivot excel

    6/19

    2014

    483066

    53865

    47814

    176202

    205185

    0

    200000

    400000

    600000

    800000

    1000000

    1200000

  • 7/25/2019 Pivot excel

    7/19

    SER"ICII

    COMER

    CONSTRUC

    II

    INDUSTRIE

    TOT#$

  • 7/25/2019 Pivot excel

    8/19

  • 7/25/2019 Pivot excel

    9/19

    2008 2009 2010 2011 2012 2013 2014 1)

    0

    100000

    200000

    300000

    400000

    500000

    600000

    SE

    CO

    CO

    II

    IND

    TO

    Axis Title

    Axis

    Title

  • 7/25/2019 Pivot excel

    10/19

    "ICII

    ER

    STRUC

    USTRIE

    $

  • 7/25/2019 Pivot excel

    11/19

    "n#etitia bruta (mil.lei)

    Sector 2008 2009 2010 2011 2012 2013

    TOTAL 144031 99763 92199 143363 120880 110175

    INDUSTRIE 53182 40602 41382 83777 54378 51357

    CONSTRUC 24191 16943 12865 17251 25760 22123

    COMER 23299 14297 12857 13586 12960 11664

    SERVICII 43359 27921 25095 28749 27782 25031

  • 7/25/2019 Pivot excel

    12/19

    2014 1)

    105583

    51529

    12403

    12479

    29172

    2008 2009 2010 2011 2012

    0

    50000

    100000

    150000

    200000

    250000

    300000

    350000

    Axis Title

    AxisT

    itle

  • 7/25/2019 Pivot excel

    13/19

    013 2014 1)

    SER"ICII

    COMER

    CONSTRU

    CII

    INDUSTRIE

    TOT#$

  • 7/25/2019 Pivot excel

    14/19

    Numar mediu de alariati

    $ector 2008 2009 2010 2011 2012 2013

    %&%' 4418713 3964185 3725645 3858595 3852570 3871905

    INDUSTRI 1643676 1423107 1346280 1387110 1379989 1372905

    CONSTRU 554399 469182 393339 418202 399413 369343

    COMER 1019791 901376 843752 857445 854401 858385

    SERVICII 1200847 1170520 1142274 1195838 1218767 1271272

  • 7/25/2019 Pivot excel

    15/19

    2014 1)

    3832502

    1372430

    352063

    831513

    1276496

    20082009

    20102011

    2012

    0

    1000000

    2000000

    3000000

    4000000

    5000000

    TOT#$ INDUSTRIE CONSTRUCII COMER S

  • 7/25/2019 Pivot excel

    16/19

    20132014 1)

    R"ICII

  • 7/25/2019 Pivot excel

    17/19

    Rezultatul brut al exercitiului (mil.lei)

    Sector 2008 2009 2010 2011 2012 2013 2014 1)

    TOTAL 32534 13088 5732 15649 19753 27934 34957

    INDUSTRIE 9171 2484 6042 9255 8638 14081 12477

    CONSTRUCII 5156 3017 1005 763 -623 482 1494

    COMER 9400 3495 248 4861 5864 7260 10469

    SERVICII 8807 4092 -1563 769 5874 6111 10517

    1) Date pr!"#r""

  • 7/25/2019 Pivot excel

    18/19

    2008 2009 2010 2011 2012 2013 20141)

    !5000

    0

    5000

    10000

    15000

    20000

    25000

    30000

    35000

    Chart Title

    TOT#

    INDU

    CONS

    II

    COME

    SER"I

    Axis Title

    Axis

    Title

  • 7/25/2019 Pivot excel

    19/19

    TRIE

    TRUC

    R

    II

Embed Size (px)
Recommended