I want to format a chart in a new tab based on some existing data from a worksheet. I can record the pattern using "Save As Template", but I want to create a macro that creates the same format every time. However, I have some problem with referring to the chart. Here's my code.I want to format a chart in a new tab based on