How to satop chart filling in dates

  • Thread starter Thread starter smurfdrl
  • Start date Start date
S

smurfdrl

I have a simple chart in which I want following dates along the x-axis
04-Nov 05-Nov 06-Nov 07-Nov 10-Nov 11-Nov 12-Nov 13-Nov 14-Nov

You will notice I do not want the 8th or 9th to appear, however when I
create the chart, the 8/9 automatically appear even though they are not in
the data table.

Any ideas on how I can get rid of pesky little creatures?

Thanks in advance.
 
Hi,

You need to force the axis to be category rather than Time series.
Right click chart and pick Chart Options. Axes tab set Category axis.

Cheers
Andy
 
Thanks Andy - have a star.

Andy Pope said:
Hi,

You need to force the axis to be category rather than Time series.
Right click chart and pick Chart Options. Axes tab set Category axis.

Cheers
Andy
Click to expand...
 

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

Combine 2 Charts 2007 Excel 1
Count the highest number of days without “errors” 2
Bar Chart 2007 Excel 1
2 dimensional date sort 1
How do I create a chart that shows different periods of time. 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Windows XP, Home Edition, Ver 2002, SP 3, GetUserDefaultLC 5
How to use 2 conditions in conditional formatting 1

Back
Top