pivot chart

[Kim B]

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

*	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