Pivot chart Refresh wrecks HAVOC!

A

Arlen

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
 
D

Debra Dalgleish

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?
 
Top