BAR CHART OVERLAYINGDATA POINTS

R

Rich

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
 
A

Andy Pope

Hi,

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

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charting based on a specific month in a column 1
Floating Bar with Quartile Ranks 2
Overlaying 2 Data Series with Different Time (X) Axis 3
Stacked columns width too thin - how can I alter? 1
Problem with line Chart 2
Trying to add resource allocation data to a gantt chart built in E 0
Charting a line and a bar on the same chart 1
Pivot Chart- 2 unrelated series on 1 chart 4

Top