If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time scale in pivot chart
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot chart issue | James | Charts and Charting | 8 | September 13th, 2005 12:35 PM |
Pivot Chart based on a pivot table changes | dineshnewcomer | Charts and Charting | 1 | April 15th, 2005 03:52 AM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Chart from Pivot table | Adam | General Discussion | 1 | June 23rd, 2004 12:58 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |