Delete chart columns Excel 2013

[Sigh]

I have data for Friday 12th, Monday 15th and Tuesday 16th in a table, when I create a bar chart the missing Saturday 13th and Sunday 14th are also included on it, with zero values, despite not being in the data table - how do i delete these columns in the chart please?

 

[thisoldman]

Try this.

Select the date axis in the chart. Bring up the formatting pane. You should see the "Axis Options" are currently set to automatic or to date. You want to switch the axis to a text axis.

 

[Sigh]

Brilliant, thank you!