Hi friends,

When I create a PivotChart plotted along a date axis, the PivotChart treats the dates as a category axis, and doesn't let me change the display.

It's particularly problematic because my data are not recorded at regular intervals. There may be one day between records, but there may be as many as five or ten, and I need the difference to be plotted accordingly.

In the attached workbook (Problems with PivotCharts.xlsx), I show an example of what I mean. When I copy the pivottable to a normal table, it plots just fine. But in the actual situation I'd be using this technique, copying and pasting is not an acceptable solution.

Thoughts from the crowd?