Hi,

I am using excel 2003 and have hit a problem.

I want to display negative [h]:mm:ss on a pivot chart , but when i try the
chart displays the bars but no values in the datatable or on the axis. The
pivottable it is based on does display the -[h]:mm:ss correclty. I have set
my calcluation tab to use the "1904 Date System", as this then allows the use
of negative times.

If I plot a normal excel graph onto the pivottable it displays the negative
time correctly. However, i really need the filtering power of the
pivotcharts, so this is not really an option.

Has anyone any ideas?

Cheers

Devo