Hi,
I have a database where pie charts will show every month - 3 years span
I tried to copy paste it but whenever I do it, the color changes to default and the data has $ in formula so the formula "does not follow" the row.
For examplein column AT7 - I copied it in column AT9:
a. chart color changes to default
b. char data formula is: (is constant)
=Summary_with_Chart!$AQ$5:$AS$5;Summary_with_Chart!AQ8:AS8
Bookmarks