Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Date formatting on a Pivot Chart's Data Table
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |