How can I get the quarters that have no sales to appear on my graph axis?

[TOMWHITING]

First time using a forum of any sort so apologies if this is in the wrong place.

I am creating graphs so I can visually represent sales over time so have decided to use pivot tables. When i graph my data the quarters that have sales are evenly spaced so a quick glance would make it seem like there are sales every quarter. This isn't true so I would like to show every quarter on the x axis, giving gaps between columns where there were no sales.

Is this a simple 'select this option' case or is it complicated to change?

Chart for forum.PNG

Unsure if that attachment has worked...

Thanks

[skywriter]

Click on the go advanced tab and then the paperclip icon that shows in the go advanced tool set and this will help you attach an actual worksheet.