I have an excel chart which is derived from a pivot table. The pivot table
is updated on a weekly basis and I then print the chart. The values in the
Y-axis stay constant as well as the serie names.
The problem I'm having is that even if I change the legend color to be to my
liking, when-ever I update the pivot table the chart automatically re-applies
it's own color codes to the legend.
Is there any way around this?