X axis unevenly divided

[Thomaswu6]

Hello there!

I'm having issue with my pivot chart.
What I'm trying to do is to make the date spread out equally. As you can see from the screenshot, 12:03AM->11:57:37AM takes up roughly 1/5 of the space, while I would like it to take up around half the space. Also, would it be possible to change it to 12:00AM and end at 11:59PM or 12:00AM (next day?)
Capture.PNG

I have uploaded the excel file I'm working on onto TinyUpload.com as the file is too big (~2Mb) for upload on this forum.
http://s000.tinyupload.com/?file_id=...75121616268138

Thank you!

[Andy Pope]

Two problems. Pivot charts don't do Time series axes. And if they did time series axes only go down as far as days.

Have a read of this article.
http://office.microsoft.com/en-gb/ex...005198418.aspx

[MrShorty]

I am not at all familiar with Pivot Tables and Pivot Charts. From what I can gather, this is one of the limitations of Pivot Charts in Excel -- they cannot do certain chart types, XY scatter in particular (which would make short work of your problem here).

Jon Peltier discusses the issue, and explains how to make a "regular chart" (not a pivot chart) from your Pivot data, which will hopefully allow you to format your chart as an XY scatter chart and get the effect you desire. http://peltiertech.com/WordPress/reg...-pivot-tables/