Plotting negative [h]:mm:ss on a PivotChart

D

Devo Clubber

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Negative Time Values on Y-Axis 0
Displaying negative [h]:mm:ss 2
negative [h]:mm:ss does not show on the x axis of a chart 0
Negative hours [h]:mm:ss 5
Graphing Negative Time 1
negative [h]:mm:ss does not show on the x axis of a chart 0
Plotting against Date (collating months) 2
Plotting Line Graphs to Specific Bar Graphs 0

Top