Change spacing between dates in a pivot table

[alih42]

I have a pivot table with dates along the x-axis. The data is spread out over 5 years and the spacing between sampling events is not even, therefore, the spacing of my x-axis dates is not even. I want the x-axis to look similar to a normal graph where there is equal space between each month, even if I don't have data for each month. I do not want to group the data to accomplish this. If I click the "show items with no data" it only shows one extra day, not all days or even all months. I have excel 2010.

 

[Jerry Sullivan]

Hi and Welcome to the Board,

It sounds like you have your chart set up with the X-axis as a Category Axis instead of a Value Axis or Time-Scale Axis.

This article by Jon Peltier explains the differences.
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html

 

[alih42]

Thanks for the help. This actually led me to create a blank xy scatter, then copy the pivot table, and paste the pivot table into blank xy scatter. You can't normally create a xy scatter pivot chart. But my axis are now correct!