Having an issue with some pivotcharts?

J

jpgrimes22

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?
 
D

Debra Dalgleish

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.
 

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

Top