Pivot chart Refresh wrecks HAVOC!
 

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

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

You should only need each field once, in most pivot tables. What are you
trying to do with the Dates and data, that is causing problems for you?

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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html