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

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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?
 
This nuisance is unacceptable!!

teylyn said:
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

.
Click to expand...
 
Back
Top