Pivot Chart Time Format

**Steven87** · 05-01-2012, 01:40 PM

I am relatively new at Excel, and having problems with formatting a Pivot Chart.
I'm trying to display call volume throughout a 24 hour period with the number of calls on the Y axis, and half hour intervals on the X axis.

The pivot chart only displays the times of when calls occured and I'd like it to display every half hour interval throughout a 24 hour day (48 total time intervals) even if there were zero calls for any given interval.

pivottable.jpg

This is what I'm working with.

Thanks a ton!

**tuph** · 05-03-2012, 02:58 AM

Right click on the chart and click Select Data, Hidden and Empty Cells.
Click the option for Show Empty Cells As Zero. You may also want to tick the box to display hidden cells.

**Steven87** · 05-03-2012, 01:44 PM

Thanks for the response!

I clicked on the option to "Show empty cells as Zero", but unfortunately my graph did not change. Also, what do you mean by "tick the box"?

**zxchan** · 05-06-2012, 10:40 AM

Hi,

This might help. http://www.howtoexcelatexcel.com/exc...a-pivot-table/
If it doesn't then I think it might be due to your raw data. Attach some sample data if you need further help

**iherndon** · 07-06-2012, 09:11 PM

I see this thread stopped being responded to but I'm actually looking to do the exact same thing.

I'm working with military time in the hh:mm format. Below would be an example of volume after midnight:

00:00
00:02
00:02
00:03
00:03
00:03
00:03
00:04
00:04
00:04
00:06
00:06
00:06
00:07
00:08

Right now I actually already have a separate tab for each day of the week, Mon-Sun. I'd essentially like to determine frequency of volume by half hour. So with that in mind, if the above times were all that occurred between 00:00 and 00:30 then I'd be looking for some way to output the value of 15. Any thoughts for doing this with a much larger segment of data for the whole 24hr period?

**Cutter** · 07-06-2012, 10:02 PM

Hello iherndon. And welcome to the forum. Unfortunately you've inadvertently broken one of the forum rules. Please read the following rule:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.