my error seems to center around the name of the pivot chart, each time it creates a new chart it adds 1 to the number following the name. I tried to circumvent this by naming the pivot chart but when opening the chart it initially gives it the other name before the macro changes it. Is the any way around this or a wildcard character I could use?