Hi Andy, so if I create my own chart, when I slice the pivot by quarter or category, it breaks my chart cos the numbers it's looking at have disappeared. This is not good.
But if I use a pivot chart, it's got all the categories and dates and everything all in one place. And if I remove them from the chart, it removes them from the pivot.

:-(