chart formating disappears when i refresh pivot table data


G

Guest

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
 
Ad

Advertisements

R

robert111

replace the pivot table with a sumproduct table, then formatting is
fixed forever.
 
G

Guest

Would it be possible to elaborate a little on this process using the
sumproduct table. I checked out the sumproduct funtion and understand it but
I don't see how I proceed to used this to "replace" the pivot table.
Any additional info would be greatly appreciated.
thanks!
Jugglertwo
 
Ad

Advertisements

R

robert111

To help you further I would need to see a simplifed set of data and what
your pivot table was analysing. I would then suggest how to use the
sumproduct table. To save time you can e-mail the simplified
spreadsheet to (e-mail address removed), as I don't visit the forum
every day.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top