How do I keep formatting when creating a chart from a pivot?

[Kevin]

I have a data source that I use to create various pivots and the I use thos
pivots to create graphs. I replace the detail for the pivots each month and
refreash each pivot which updates the graphs. The problem is the column and
data values lose their formatting when I refreash the pivots. Is there a way
to make the formatting of the graph stay?

 

[teylyn]

Hi, this is a well-known nuisance. One workaround is to record a macr
while you do the formatting and then run the macro after you refresh th
pivot data.

regards, teylyn


I have a data source that I use to create various pivots and the I us
thos

 

[JimHawkins]

This nuisance is unacceptable!!

Hi, this is a well-known nuisance. One workaround is to record a macro
while you do the formatting and then run the macro after you refresh the
pivot data.

regards, teylyn



I have a data source that I use to create various pivots and the I use
thos


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=188416

http://www.thecodecage.com/forumz/chat.php

.