In the pivot table, group the times by Hours and minutes. Then, in the
pivot chart, select the hours that you want to show on the chart.

jpgrimes22 wrote:
I have a pivotchart with a drop down box "Time" with all 1440 minutes in a
day on the x-axis. I would like to be able to select 60 minutes on the drop
down box at a time for each hour in the day without having to select each
minute at a time. Is there any way to solve this issue?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html