Does anyone know how to may this pivot table in to a pivot chart. the numbers 1 and 2 are Jan and Feb..there are 12 months and lots of cost centers.
Sheet4
<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 186px"><COL style="WIDTH: 281px"><COL style="WIDTH: 79px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"></COLGROUP><TBODY>
</TBODY>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Sheet4
* | A | B | C | D | E |
3 | * | * | * | Date | * |
4 | Cost Center | Account/Description | Values | 1 | 2 |
5 | 21141 | 520001 TRAVEL EXPENSE - TRANSPORT AIR | Total CC | * * * 4,549 | * * * 2,216 |
6 | * | * | Exp pp | * * * * *190 | * * * * * *92 |
7 | * | * | Sales Per PP | * *340,802 | * *481,356 |
8 | * | 520002 TRAVEL EXPENSE - TRNSPORT LAND | Total CC | * * * * * *61 | * * * * *195 |
9 | * | * | Exp pp | * * * * * * 3 | * * * * * * 8 |
10 | * | * | Sales Per PP | * | * |
11 | * | 520003 TRAVEL EXPENSE - ACCOMMODATION | Total CC | * * * * *277 | * * * * *810 |
12 | * | * | Exp pp | * * * * * *12 | * * * * * *34 |
13 | * | * | Sales Per PP | * | * |
14 | * | 520004 TRAVEL EXPENSE - MEALS | Total CC | * * * * *148 | * * * * *336 |
15 | * | * | Exp pp | * * * * * * 6 | * * * * * *14 |
16 | * | * | Sales Per PP | * | * |
17 | * | 521002 AUTO EXPENSE - LEASE | Total CC | * * * * *289 | * * * * *449 |
18 | * | * | Exp pp | * * * * * *12 | * * * * * *19 |
19 | * | * | Sales Per PP | * | * |
20 | * | 521004 AUTO EXPENSE - MILEAGE | Total CC | * | * * * * *102 |
21 | * | * | Exp pp | * * * * * *- * | * * * * * * 4 |
22 | * | * | Sales Per PP | * | * |
23 | 21141 Total CC | * | * | * * *5,322 | * * *4,107 |
24 | 21141 Exp pp | * | * | * * * * * 44 | * * * * * 29 |
25 | 21141 Sales Per PP | * | * | *340,802 | *481,356 |
<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 186px"><COL style="WIDTH: 281px"><COL style="WIDTH: 79px"><COL style="WIDTH: 71px"><COL style="WIDTH: 71px"></COLGROUP><TBODY>
</TBODY>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4