Excel pivot chart not showing date
By default, Excel sorts by the first field in a pivot table. 4) Under the Design menu, select Report Layout / Show in Tabular Form. 3) Re-arrange your fields so that the Date field is listed FIRST in the ROWS section. Tip: The ‘Show items with no data’ can be applied to any row label, not just dates. 1) Un-group the date field in the pivot table. I have a table containing dates of calls with timestamps for individual cases with unique ID's. Right-click one of the date row labels in the PivotTable > select Group > Days and Months: Next right-click one of the date row labels in the PivotTable > select Field Settings > Layout & Print tab > check the ‘Show items with no data’ box. Right-click the query, choose properties to see the settings we need. In the data connections pane, you’ll see a query. Right-click the axis that contains the dates. You should note that the chart includes the undesired phantom dates (weekends). Follow these steps if you are using Excel 2007 or Excel 2010: Create your chart as you normally would. When the Query Editor opens, just Close and Load it. If you dont want to modify your original data, you can simply tell Excel to ignore the date parsing. i have have tried to set the formatting and also used the text to coloum approach to convert these data in to dates. The exact menu item maybe different depending on your version of Excel. i have verified this by applying filters. The problem start as the pivot do not see them as date while the Data sheet treat them as Date.