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

"tcdzomba" wrote:

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