BAR CHART OVERLAYINGDATA POINTS

  • Thread starter Thread starter Rich
  • Start date Start date
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
 
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
Overlaying 2 Data Series with Different Time (X) Axis 3
Floating Bar with Quartile Ranks 2
Stacked columns width too thin - how can I alter? 1
Problem with line Chart 2
Line and Bar on same chart 2
Charting a line and a bar on the same chart 1
Combine 2 Charts 2007 Excel 1

Back
Top