I have a Pivot Chart that has a text field for series, a date field for
category and a number field for data items.

In the charting options, I've hidden the legend and shown the data
table.

When the data table appears in the chart, it shows the dates in the
format:
"M-d-yyyy hh:mm"

I'd like it to show in the format:
"MMM-yy"

I can't find any options inside the Pivot Chart context menus or
toolbar for applying date formatting on the Data Table.

I've tried formatting cells in the Pivot Table and it applies them
there, but still shows in the format listed above when I go to the
chart.

Can anyone explain how to format the Dates showing on the Data Table
portion of the Chart?

Any help will be much appreciated. Thanks in advance,
Jeff