|
|
#1
12-04-2014, 01:44 AM
|
|||
|
|||
Charts - formatting dates in a data table - Excel 2013
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? 
|
|
| Tags |
| charts, data table |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2013
Linear Mode
