View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wunder boy wunder boy is offline
external usenet poster
 
Posts: 8
Default chart formating disappears when i refresh pivot table data

hi,
i have lots of pivot tables and charts based on those table.
1. i apply formatting to a particular chart like colors,shadow etc
2 then later when new data is added to pivot table i refresh the pivot table
3. after the above the chart refreshes but the formatting dissapears

how should i correct the problem?

thx
tols