Hi,

This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Arlen wrote:
When I'm using a pivot chart graph to track stuff, any time I update the
spreadsheet and refresh the Pivot Graph, all the labels go back to default.
I like them Above the data point, and Aligned at 45 degrees, for maximum
readability. How do I keep it this way even when I hit that Refresh button?

Also, how do you use Pivot Table fields that are not contiguous? In other
words, I have Dates in Column A, which I want to use with data in Column C,
D, H and so forth, without copying Column A and putting it next to each of
these other columns.

Thanks, everybody.

Arlen

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info