Then, go to Chart Options, Axes Tab

Change X Axis to Category


"SwampYankee" wrote:

Hi,
I'm trying to creat a simple bar chart that shows open tickets and
closed tickets week by week. I have 3 weeks of data and the bars
themselves are ok (20 open 6 closed). However, when using the date as
the horizontal axis, Excel inserts the 6 days of the week between each
miles stone. So, if I want to see the number of tickets each Monday,
Excel creates the chart with all the other days of the week, which have
no data. I'm left with 3 bars standing apart. How can I get each
Monday to stand next to each other and hide the intevening days?
P.S. The cells the chart is based on do not contain the intevening
days.
thanks