Is there a way to format multiple charts (in different worksheets, same
workbook) that are exactly the same (or I wish them to be so) to each other
except for the source data location? In particular, I am looking to change
column colors, the dark/light variation shading and changing the format of
the y axis to currency with commas.

Any help greatly appreciated