Hi,

Right click the chart and pick Chart Options. On the Axes tab set the
axis to be Category rather than automatic.

Cheers
Andy

Rich wrote:
I have a bar chart set up as just dates and values. The dates run in 4 week
periods. I have values added for 5/2/08 and 5/30/08. The 5/30 data overlays
the same bar as the 5/2 data. It appears to overlay if the dates are in the
same month as I can get the same results for later months that have 2 data
points in them. I do i solve this and have these points plot seperately?
Thank You

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info