View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default How do I keep formatting when creating a chart from a pivot?

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?