I want to create a time series graph. Column A contains dates (in date format, confirmed by control-F8, blue color), column B some values. If I use a standard chart and choose XY scatter plot I get what I need, an x-axis which corrects for irregular date intervals in the data. However, the same data from a pivot table result in incorrect x-axis spacing. Moreover, the date units do not display correctly, as noticed here: Date units not displaying correctly on chart axis
How to create a properly working graph from a pivot table using date as x-axis?
Here is a sample document:
time chart in pivot table problem.ods (27.6 KB)