Docstoc

Chart - Community

Document Sample
Chart - Community Powered By Docstoc
					20,000,000


18,000,000


16,000,000


14,000,000


12,000,000


10,000,000


 8,000,000


 6,000,000


 4,000,000


 2,000,000


        0
0.25




0.2




0.15   Actual YTD NI
       Actual Net Inc
       Forecast YTD NI
       Forecast Net Inc
0.1
       Budget Net Inc
       Net Margin


0.05




0
           (Net
           Margin)/
           Net
           Income/N                 (Forecast YTD (Forecast Net    (Actual YTD (Actual Net
           et          (Budget Net Inc)YTD for     Inc)Net         NI)YTD for Inc)Net
Date       Revenue     Inc)YTD      Chart          Income          Chart       Income
Jan-2012      12.00%     $1,000,000             $0    $1,000,000            $0     $700,000
Feb-2012       8.50%     $2,500,000    $1,500,000     $1,500,000    $1,300,000 $1,000,000
Mar-2012      13.00%     $3,000,000    $3,000,000     $1,700,000    $2,000,000 $1,500,000
Apr-2012      11.00%     $5,000,000    $4,000,000     $1,400,000    $3,500,000 $1,300,000
May-2012      12.00%     $7,000,000    $6,000,000     $1,500,000    $4,500,000 $1,100,000
Jun-2012      18.00%     $8,000,000    $7,500,000     $1,700,000    $6,000,000 $1,500,000
Jul-2012      17.00%    $10,000,000    $8,500,000     $1,300,000    $7,000,000 $1,400,000
Aug-2012      15.00%    $12,000,000 $10,000,000       $1,400,000    $8,500,000 $1,100,000
Sep-2012       0.00%    $13,000,000 $11,000,000         $900,000
Oct-2012       0.00%    $15,000,000 $13,000,000       $1,300,000
Nov-2012       0.00%    $16,000,000 $14,000,000       $1,500,000
Dec-2012       0.00%    $18,000,000 $15,500,000       $1,700,000
Date          Measure Value       DestinationOrder
12/28/2011    A               1   Bar               1
12/28/2011    B               2   Bar               2
   1/4/2012   C               3   Bar               3
 1/28/2012    A               2   Bar               4
 1/28/2012    B               1   Bar               5
   2/4/2012   C               4   Bar               6
   1/1/2012   D               6   Line              7
   2/1/2012   D               7   Line              8
   1/1/2012   E               7   Line              9
   2/1/2012   E               6   Line             10
   1/4/2012   F               2   Bar              11
   2/4/2012   F               3   Bar              12
   1/1/2012   N                   Bar
   2/1/2012   N                   Bar
          Measure Value
Month of Date
1/1/2012 D                6
2/1/2012 D                7
3/1/2012 D                8
Date          Measure                        Value             Addition
   1/1/2012   (Actual Net Inc)Net Income               $0.00
   1/1/2012   (Actual Net Inc)Net Income        $700,000.00                    0
   2/1/2012   (Actual Net Inc)Net Income               $0.00
   2/1/2012   (Actual Net Inc)Net Income       $1,000,000.00                   0
   3/1/2012   (Actual Net Inc)Net Income               $0.00
   3/1/2012   (Actual Net Inc)Net Income       $1,500,000.00                   0
   4/1/2012   (Actual Net Inc)Net Income               $0.00
   4/1/2012   (Actual Net Inc)Net Income       $1,300,000.00                   0
   5/1/2012   (Actual Net Inc)Net Income               $0.00
   5/1/2012   (Actual Net Inc)Net Income       $1,100,000.00                   0
   6/1/2012   (Actual Net Inc)Net Income               $0.00
   6/1/2012   (Actual Net Inc)Net Income       $1,500,000.00                   0
   7/1/2012   (Actual Net Inc)Net Income               $0.00
   7/1/2012   (Actual Net Inc)Net Income       $1,400,000.00                   0
   8/1/2012   (Actual Net Inc)Net Income               $0.00
   8/1/2012   (Actual Net Inc)Net Income       $1,100,000.00                    0
   1/1/2012   (Actual YTD NI)YTD for Chart             $0.00        $700,000.00
   1/1/2012   (Actual YTD NI)YTD for Chart                          $700,000.00
   2/1/2012   (Actual YTD NI)YTD for Chart     $1,300,000.00       $1,000,000.00
   2/1/2012   (Actual YTD NI)YTD for Chart                         $1,000,000.00
   3/1/2012   (Actual YTD NI)YTD for Chart     $2,000,000.00       $1,500,000.00
   3/1/2012   (Actual YTD NI)YTD for Chart                         $1,500,000.00
   4/1/2012   (Actual YTD NI)YTD for Chart     $3,500,000.00       $1,300,000.00
   4/1/2012   (Actual YTD NI)YTD for Chart                         $1,300,000.00
   5/1/2012   (Actual YTD NI)YTD for Chart     $4,500,000.00       $1,100,000.00
   5/1/2012   (Actual YTD NI)YTD for Chart                         $1,100,000.00
   6/1/2012   (Actual YTD NI)YTD for Chart     $6,000,000.00       $1,500,000.00
   6/1/2012   (Actual YTD NI)YTD for Chart                         $1,500,000.00
   7/1/2012   (Actual YTD NI)YTD for Chart     $7,000,000.00       $1,400,000.00
   7/1/2012   (Actual YTD NI)YTD for Chart                         $1,400,000.00
   8/1/2012   (Actual YTD NI)YTD for Chart     $8,500,000.00       $1,100,000.00
   8/1/2012   (Actual YTD NI)YTD for Chart                         $1,100,000.00
   1/1/2012   (Budget Net Inc)YTD              $1,000,000.00
   2/1/2012   (Budget Net Inc)YTD              $2,500,000.00
   3/1/2012   (Budget Net Inc)YTD              $3,000,000.00
   4/1/2012   (Budget Net Inc)YTD              $5,000,000.00
   5/1/2012   (Budget Net Inc)YTD              $7,000,000.00
   6/1/2012   (Budget Net Inc)YTD              $8,000,000.00
   7/1/2012   (Budget Net Inc)YTD             $10,000,000.00
   8/1/2012   (Budget Net Inc)YTD             $12,000,000.00
   9/1/2012   (Budget Net Inc)YTD             $13,000,000.00
  10/1/2012   (Budget Net Inc)YTD             $15,000,000.00
  11/1/2012   (Budget Net Inc)YTD             $16,000,000.00
  12/1/2012   (Budget Net Inc)YTD             $18,000,000.00
   1/1/2012   (Forecast Net Inc)Net Income     $1,000,000.00
   1/1/2012   (Forecast Net Inc)Net Income
 2/1/2012   (Forecast Net Inc)Net Income           $1,500,000.00
 2/1/2012   (Forecast Net Inc)Net Income
 3/1/2012   (Forecast Net Inc)Net Income           $1,700,000.00
 3/1/2012   (Forecast Net Inc)Net Income
 4/1/2012   (Forecast Net Inc)Net Income           $1,400,000.00
 4/1/2012   (Forecast Net Inc)Net Income
 5/1/2012   (Forecast Net Inc)Net Income           $1,500,000.00
 5/1/2012   (Forecast Net Inc)Net Income
 6/1/2012   (Forecast Net Inc)Net Income           $1,700,000.00
 6/1/2012   (Forecast Net Inc)Net Income
 7/1/2012   (Forecast Net Inc)Net Income           $1,300,000.00
 7/1/2012   (Forecast Net Inc)Net Income
 8/1/2012   (Forecast Net Inc)Net Income           $1,400,000.00
 8/1/2012   (Forecast Net Inc)Net Income
 9/1/2012   (Forecast Net Inc)Net Income            $900,000.00
 9/1/2012   (Forecast Net Inc)Net Income
10/1/2012   (Forecast Net Inc)Net Income           $1,300,000.00
10/1/2012   (Forecast Net Inc)Net Income
11/1/2012   (Forecast Net Inc)Net Income           $1,500,000.00
11/1/2012   (Forecast Net Inc)Net Income
12/1/2012   (Forecast Net Inc)Net Income           $1,700,000.00
12/1/2012   (Forecast Net Inc)Net Income
 1/1/2012   (Forecast YTD Inc)YTD for Chart               $0.00    $1,000,000.00
 1/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,000,000.00
 2/1/2012   (Forecast YTD Inc)YTD for Chart        $1,500,000.00   $1,500,000.00
 2/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,500,000.00
 3/1/2012   (Forecast YTD Inc)YTD for Chart        $3,000,000.00   $1,700,000.00
 3/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,700,000.00
 4/1/2012   (Forecast YTD Inc)YTD for Chart        $4,000,000.00   $1,400,000.00
 4/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,400,000.00
 5/1/2012   (Forecast YTD Inc)YTD for Chart        $6,000,000.00   $1,500,000.00
 5/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,500,000.00
 6/1/2012   (Forecast YTD Inc)YTD for Chart        $7,500,000.00   $1,700,000.00
 6/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,700,000.00
 7/1/2012   (Forecast YTD Inc)YTD for Chart        $8,500,000.00   $1,300,000.00
 7/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,300,000.00
 8/1/2012   (Forecast YTD Inc)YTD for Chart       $10,000,000.00   $1,400,000.00
 8/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,400,000.00
 9/1/2012   (Forecast YTD Inc)YTD for Chart       $11,000,000.00    $900,000.00
 9/1/2012   (Forecast YTD Inc)YTD for Chart                         $900,000.00
10/1/2012   (Forecast YTD Inc)YTD for Chart       $13,000,000.00   $1,300,000.00
10/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,300,000.00
11/1/2012   (Forecast YTD Inc)YTD for Chart       $14,000,000.00   $1,500,000.00
11/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,500,000.00
12/1/2012   (Forecast YTD Inc)YTD for Chart       $15,500,000.00   $1,700,000.00
12/1/2012   (Forecast YTD Inc)YTD for Chart                        $1,700,000.00
 1/1/2012   (Net Margin)/Net Income/Net Revenue             0.12
2/1/2012   (Net Margin)/Net Income/Net Revenue   0.085
3/1/2012   (Net Margin)/Net Income/Net Revenue    0.13
4/1/2012   (Net Margin)/Net Income/Net Revenue    0.11
5/1/2012   (Net Margin)/Net Income/Net Revenue    0.12
6/1/2012   (Net Margin)/Net Income/Net Revenue    0.18
7/1/2012   (Net Margin)/Net Income/Net Revenue    0.17
8/1/2012   (Net Margin)/Net Income/Net Revenue    0.15
Plotting Value     Point OrderSegment
             $0.00          0 (Actual Net Inc)Net Income 40909
      $700,000.00           1 (Actual Net Inc)Net Income 40909
             $0.00          0 (Actual Net Inc)Net Income 40940
    $1,000,000.00           1 (Actual Net Inc)Net Income 40940
             $0.00          0 (Actual Net Inc)Net Income 40969
    $1,500,000.00           1 (Actual Net Inc)Net Income 40969
             $0.00          0 (Actual Net Inc)Net Income 41000
    $1,300,000.00           1 (Actual Net Inc)Net Income 41000
             $0.00          0 (Actual Net Inc)Net Income 41030
    $1,100,000.00           1 (Actual Net Inc)Net Income 41030
             $0.00          0 (Actual Net Inc)Net Income 41061
    $1,500,000.00           1 (Actual Net Inc)Net Income 41061
             $0.00          0 (Actual Net Inc)Net Income 41091
    $1,400,000.00           1 (Actual Net Inc)Net Income 41091
             $0.00          0 (Actual Net Inc)Net Income 41122
    $1,100,000.00           1 (Actual Net Inc)Net Income 41122
      $700,000.00           1 (Actual YTD NI)YTD for Chart 40909
      $700,000.00           0 (Actual YTD NI)YTD for Chart 40909
    $2,300,000.00           1 (Actual YTD NI)YTD for Chart 40940
    $1,000,000.00           0 (Actual YTD NI)YTD for Chart 40940
    $3,500,000.00           1 (Actual YTD NI)YTD for Chart 40969
    $1,500,000.00           0 (Actual YTD NI)YTD for Chart 40969
    $4,800,000.00           1 (Actual YTD NI)YTD for Chart 41000
    $1,300,000.00           0 (Actual YTD NI)YTD for Chart 41000
    $5,600,000.00           1 (Actual YTD NI)YTD for Chart 41030
    $1,100,000.00           0 (Actual YTD NI)YTD for Chart 41030
    $7,500,000.00           1 (Actual YTD NI)YTD for Chart 41061
    $1,500,000.00           0 (Actual YTD NI)YTD for Chart 41061
    $8,400,000.00           1 (Actual YTD NI)YTD for Chart 41091
    $1,400,000.00           0 (Actual YTD NI)YTD for Chart 41091
    $9,600,000.00           1 (Actual YTD NI)YTD for Chart 41122
    $1,100,000.00           0 (Actual YTD NI)YTD for Chart 41122
    $1,000,000.00           1 (Budget Net Inc)YTD
    $2,500,000.00           2 (Budget Net Inc)YTD
    $3,000,000.00           3 (Budget Net Inc)YTD
    $5,000,000.00           4 (Budget Net Inc)YTD
    $7,000,000.00           5 (Budget Net Inc)YTD
    $8,000,000.00           6 (Budget Net Inc)YTD
   $10,000,000.00           7 (Budget Net Inc)YTD
   $12,000,000.00           8 (Budget Net Inc)YTD
   $13,000,000.00           9 (Budget Net Inc)YTD
   $15,000,000.00         10 (Budget Net Inc)YTD
   $16,000,000.00         11 (Budget Net Inc)YTD
   $18,000,000.00         12 (Budget Net Inc)YTD
    $1,000,000.00           1 (Forecast Net Inc)Net Income 40909
             $0.00          0 (Forecast Net Inc)Net Income 40909
 $1,500,000.00   1   (Forecast Net Inc)Net Income 40940
         $0.00   0   (Forecast Net Inc)Net Income 40940
 $1,700,000.00   1   (Forecast Net Inc)Net Income 40969
         $0.00   0   (Forecast Net Inc)Net Income 40969
 $1,400,000.00   1   (Forecast Net Inc)Net Income 41000
         $0.00   0   (Forecast Net Inc)Net Income 41000
 $1,500,000.00   1   (Forecast Net Inc)Net Income 41030
         $0.00   0   (Forecast Net Inc)Net Income 41030
 $1,700,000.00   1   (Forecast Net Inc)Net Income 41061
         $0.00   0   (Forecast Net Inc)Net Income 41061
 $1,300,000.00   1   (Forecast Net Inc)Net Income 41091
         $0.00   0   (Forecast Net Inc)Net Income 41091
 $1,400,000.00   1   (Forecast Net Inc)Net Income 41122
         $0.00   0   (Forecast Net Inc)Net Income 41122
  $900,000.00    1   (Forecast Net Inc)Net Income 41153
         $0.00   0   (Forecast Net Inc)Net Income 41153
 $1,300,000.00   1   (Forecast Net Inc)Net Income 41183
         $0.00   0   (Forecast Net Inc)Net Income 41183
 $1,500,000.00   1   (Forecast Net Inc)Net Income 41214
         $0.00   0   (Forecast Net Inc)Net Income 41214
 $1,700,000.00   1   (Forecast Net Inc)Net Income 41244
         $0.00   0   (Forecast Net Inc)Net Income 41244
 $1,000,000.00   1   (Forecast YTD Inc)YTD for Chart 40909
 $1,000,000.00   0   (Forecast YTD Inc)YTD for Chart 40909
 $3,000,000.00   1   (Forecast YTD Inc)YTD for Chart 40940
 $1,500,000.00   0   (Forecast YTD Inc)YTD for Chart 40940
 $4,700,000.00   1   (Forecast YTD Inc)YTD for Chart 40969
 $1,700,000.00   0   (Forecast YTD Inc)YTD for Chart 40969
 $5,400,000.00   1   (Forecast YTD Inc)YTD for Chart 41000
 $1,400,000.00   0   (Forecast YTD Inc)YTD for Chart 41000
 $7,500,000.00   1   (Forecast YTD Inc)YTD for Chart 41030
 $1,500,000.00   0   (Forecast YTD Inc)YTD for Chart 41030
 $9,200,000.00   1   (Forecast YTD Inc)YTD for Chart 41061
 $1,700,000.00   0   (Forecast YTD Inc)YTD for Chart 41061
 $9,800,000.00   1   (Forecast YTD Inc)YTD for Chart 41091
 $1,300,000.00   0   (Forecast YTD Inc)YTD for Chart 41091
$11,400,000.00   1   (Forecast YTD Inc)YTD for Chart 41122
 $1,400,000.00   0   (Forecast YTD Inc)YTD for Chart 41122
$11,900,000.00   1   (Forecast YTD Inc)YTD for Chart 41153
  $900,000.00    0   (Forecast YTD Inc)YTD for Chart 41153
$14,300,000.00   1   (Forecast YTD Inc)YTD for Chart 41183
 $1,300,000.00   0   (Forecast YTD Inc)YTD for Chart 41183
$15,500,000.00   1   (Forecast YTD Inc)YTD for Chart 41214
 $1,500,000.00   0   (Forecast YTD Inc)YTD for Chart 41214
$17,200,000.00   1   (Forecast YTD Inc)YTD for Chart 41244
 $1,700,000.00   0   (Forecast YTD Inc)YTD for Chart 41244
         $0.12   1   (Net Margin)/Net Income/Net Revenue
$0.09   2   (Net Margin)/Net Income/Net Revenue
$0.13   3   (Net Margin)/Net Income/Net Revenue
$0.11   4   (Net Margin)/Net Income/Net Revenue
$0.12   5   (Net Margin)/Net Income/Net Revenue
$0.18   6   (Net Margin)/Net Income/Net Revenue
$0.17   7   (Net Margin)/Net Income/Net Revenue
$0.15   8   (Net Margin)/Net Income/Net Revenue
the plan - add 0's for each bar, along with path info
update dates

show separate axes
doesn't work
show lines
http://community.tableausoftware.com/thread/120698

Joe's variation on stacked bar chart
http://community.tableausoftware.com/message/132454#132454

Tableau grouped bar chart
http://kb.tableausoftware.com/articles/knowledgebase/grouped-bar-chart

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/7/2013
language:Unknown
pages:12
gegouzhen12 gegouzhen12
About