I am working on a pivot chart for a presentation next week. the problem that I am having is that I cannot find the place to change the legend captions.
On most charts the caption is not necessary, but on a few I would like to add them. The legend will show the actual calculation and the name of the field ie: "Sum of Late" whereas I want to label that data series as "Late Shipments".
I know how to change this value on a normal chart, but cannot find the place to do it on a PivotChart.