Time scale in pivot chart

  • Thread starter Thread starter inews
  • Start date Start date
I

inews

I have done a pivot chart where the X axis shows time values in
HH:MM:SS format. Or it SHOULD, but instead displays in date log
format.

So, instead of 7:53:21, it will show 0.331 or something.

How can I change the format of the axis display?
 
Mmm, think I found it. The help file mentions that time formats for
pivot chart axes are taken from regional settings - whatever is
selected on that PC for Short Time, Medium Time etc.

I'm using a custom time format. Seems that nobody up in the MS clouds
coded for this type of contingency - date format in table does not
match one of those in the regional settings, so, she go foof! Boring.

Has anyone found a workaround or have different thoughts on the problem?
 
Thinking a little more, the reason I use a custom format is so I can
use it to display periods of time. It shows how long a task took,
separate to when it started or stopped. The best solution I've found
is to use a time field, with no AM/PM displayed.

Are there better ways/data formats to deal with variables/fields that
store periods of time, not clock times.
 

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

Multi Axis Pivot Chart 12
Remove the weekends from a pivot chart x axis 0
Access 2007 pivot chart, set y-axis number format to integer 1
Pivot charts - how do you change the axis titles? 1
Pivot Chart axes 1
Chart or Pivot Chart? Advise needed 5
Formatting pivot chart axis labels for dates 10
Goup by minutes in a pivot chart 1

Back
Top