B
bensellars1212
I have many pivotcharts which need to be continually refreshed to represent
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.
To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.
Can anyone help????
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.
To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.
Can anyone help????