data table labels for x axis

[Christy]

When putting excel data table on a chart, the label on the tables is
appearing as number versus date format. I have two charts one shows the date
format as it should be and the other chart pulling from the same data source
is showing numbers. Any help would be appreciated.

 

[John Mansfield]

It appears that the data table initially takes the format of the data source.
As a result, you might check that the chart data source is in a date format.
The formatting for the data table can be manually changed after that.