Org Chart Sales - Excel by hpa11919

VIEWS: 15 PAGES: 2

Org Chart Sales document sample

More Info
									           Dynamic Chart with Check-boxes

    Year          Sales      Profits   No. of customers
    2003         1,515         145                  48                      ACME Inc. Peformance since 2
                                                                 1800
    2004         1,526       1,174                 391
                                                                 1600
    2005         1,444         524                 262
    2006         1,562         331                 110           1400

    2007         1,490         873                 873           1200
    2008         1,571         318                 159           1000
    2009         1,702         619                 206
                                                                  800
 Status           TRUE         TRUE                 TRUE
                                                                  600
                  Sales      Profits   No. of customers
                                                                  400
                  1515          145                  48
                  1526        1174                  391           200

                  1444          524                 262            0
                  1562          331                 110                  2003      2004      2005
                  1490          873                 873
                  1571          318                 159
                                                                         Sales                Profits
                  1702          619                 206

How this works?

1. The three checkboxes are linked to cells C13, D13 a nd E13
2. Now, we use the true / false status of C13:E13 to show either actual values or NA() in the cells C15:E22
3. The chart is made from cells C15:E22

   For more information visit: http://chandoo.org/wp/dynamic-charts/
                   Chandoo.org             FREE Newsletter




Inc. Peformance since 2003




        2005       2006          2007     2008       2009    use this checkboxes

         Profits                  No. of customers




() in the cells C15:E22

								
To top