Need x-Axis Pivot Chart Help

[tcdzomba]

Hi.

I have a Pivot table with date in 1 column, time in another, and values in a
3rd. I want to set up a Pivot chart displaying the values as a function of
both the date and time. Unfortunately, the chart displays all the times, but
will only display the first date of the series. Can anyone tell me how to
display all the dates as well as the times?

Thanks.

Thomas

 

[tcdzomba]

I should clarify that I am using Excel 2007. Thanks.

 

[Herbert Seidenberg]

Clarify with sample data.

 

[tcdzomba]

Here is an example:

date time value
09/22 0:00 4
09/22 1:00 3
..
..
..
09/22 23:00 4
09/23 0:00 5
09/23 1:00 6
..
..
..
09/30 23:00 4

The pivot chart would show the value as a function of both the date and the
time.


v
a
l
u
e

0:00 1:00 .......0:00.........0:00...........................23:00
09/22 09/23 09/24 ......................09/30

What's happening is that I only get 09/22 to show up for date, and nothing
else.

I never had this problem with excel 2003.

Thanks for any help.

Thomas

 

[Herbert Seidenberg]

Excel 2007 PivotChart
This will happen for certain x-axis format combinations.
Try:
Axis Option > Multi-level Category Labels > checked
Axis Option > Specify interval units = 1
Alignment > Text direction > Rotate 90 (or 270)

 

[tcdzomba]

Herbert,

Tried that, but it did not make a difference.