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
*	*	*	Date	*
Cost Center	Account/Description	Values
520001 TRAVEL EXPENSE - TRANSPORT AIR	Total CC
*	*	Exp pp
*	*	Sales Per PP
*	520002 TRAVEL EXPENSE - TRNSPORT LAND	Total CC
*	*	Exp pp
*	*	Sales Per PP	*	*
*	520003 TRAVEL EXPENSE - ACCOMMODATION	Total CC
*	*	Exp pp
*	*	Sales Per PP	*	*
*	520004 TRAVEL EXPENSE - MEALS	Total CC
*	*	Exp pp
*	*	Sales Per PP	*	*
*	521002 AUTO EXPENSE - LEASE	Total CC
*	*	Exp pp
*	*	Sales Per PP	*	*
*	521004 AUTO EXPENSE - MILEAGE	Total CC	*
*	*	Exp pp
*	*	Sales Per PP	*	*
21141 Total CC	*	*
21141 Exp pp	*	*
21141 Sales Per PP	*	*

<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>
[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]21141[/TD]

[TD="align: right"]* * * 4,549 [/TD]
[TD="align: right"]* * * 2,216 [/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]* * * * *190 [/TD]
[TD="align: right"]* * * * * *92 [/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]* *340,802 [/TD]
[TD="align: right"]* *481,356 [/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="align: right"]* * * * * *61 [/TD]
[TD="align: right"]* * * * *195 [/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="align: right"]* * * * * * 3 [/TD]
[TD="align: right"]* * * * * * 8 [/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

[TD="align: right"]* * * * *277 [/TD]
[TD="align: right"]* * * * *810 [/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]

[TD="align: right"]* * * * * *12 [/TD]
[TD="align: right"]* * * * * *34 [/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]

[TD="align: right"]* * * * *148 [/TD]
[TD="align: right"]* * * * *336 [/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="align: right"]* * * * * * 6 [/TD]
[TD="align: right"]* * * * * *14 [/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]

[TD="align: right"]* * * * *289 [/TD]
[TD="align: right"]* * * * *449 [/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]

[TD="align: right"]* * * * * *12 [/TD]
[TD="align: right"]* * * * * *19 [/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]

[TD="align: right"]* * * * *102 [/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]

[TD="align: right"]* * * * * *- * [/TD]
[TD="align: right"]* * * * * * 4 [/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]

[TD="align: right"]* * *5,322 [/TD]
[TD="align: right"]* * *4,107 [/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]

[TD="align: right"]* * * * * 44 [/TD]
[TD="align: right"]* * * * * 29 [/TD]

[TD="bgcolor: #cacaca, align: center"]25[/TD]

[TD="align: right"]*340,802 [/TD]
[TD="align: right"]*481,356 [/TD]

</TBODY>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4