Charts - formatting dates in a data table

IanGUK1 · #1 12-04-2014, 01:44 AM

I have a pivot table that contains a data and two data values. the date has been formatted as 'ddd dd-mmm'

Date | Value 1 | Value 2
Wed 26-Nov | 23 | 85

Thu 27-Nov | 17 | 85
Fri 28-Nov | 17 | 80
Mon 01-Dec | 12 | 80
Tue 02-Dec | 18 | 100
Wed 03-Dec | 30 | 120

When I create a Chart the data table shows the date in the original format, e.g. 26-11-2014 (UK date format).

Is there a way to change the format of the date in the data table so it is Wed 26-Nov?

Have it as a text field?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
merging data sets in excel 2013	nwiabrad	Excel	9	07-24-2014 12:07 AM
Formatting imported data into a table with variable record sets	ash6540	Excel	6	03-27-2014 04:13 AM
Grouping Dates in Excel Pivot Table	mskennedy	Excel	2	02-27-2013 11:09 AM
Edit Data Source- Linking template charts to new data	lbf	PowerPoint	0	10-28-2011 12:19 PM
VISIO - Formatting Shape Data Details TABLE	Lora	Visio	0	07-19-2010 12:15 PM