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

Creating a Chart on form from selected data in query. 0
Average bar charts with individual data points 2
Doughnut Chart linked with the slicer in the pivot table 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Gantt chart duration not showing 0
Problem with line Chart 2
Bar Chart with Data Elements 1
Overlaying 2 Data Series with Different Time (X) Axis 3

Top