Chart - labeling

[Ian Betteridge]

Morning All,
I've created a chart which shows the dates on the x axis (total 20). I only want the chart though to display certain ones. i.e. 1st,2nd,6th,10th & 18th
Is this possible?
Regards Ian

 

[wigi]

Yes. Format the dates you don't want to see in a custom way as:

;;;

 

[Ian Betteridge]

Thanks wigi for your reply but can you explain how I do this.

 

[wigi]

Right mouse click on the cell, choose Format cells... > Number > Custom > Type:

;;;

OK

 

[Ian Betteridge]

Got it, thanks again.