BAR CHART OVERLAYINGDATA POINTS

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

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