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
|