Help with Pie Chart Macro

[OneTime1]

Hello, I am working on a macro that creates a pie chart based on some data and then changes the 3d rotation of the pie chart. The problem is when I run the macro it will not work because part of the code refers to the chart as Chart 1 but every time the the macro makes a new chart it gets a new number added on the end such as Chart 1, Chart 2 etc. Is there some way that each chart created will have the same name? I tried re recording the macro and naming the chart in Excel but that still did not work. Here is my code:

Please Login or Register  to view this content.

Any suggestions to fix this problem are welcome. Thanks.

[playaller]

Near the top of your code try changing this:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

which is what the rest of your code is referring to.

[playaller]

Sorry. Try renaming the active chart

Please Login or Register  to view this content.

[OneTime1]

Sorry. Try renaming the active chart

Hi, sorry for the long reply. I tried what you suggested and when I run the macro I get the run-time error that says the specified value is out of range. Here is a screenshot of the debug screen.vba error.jpg

[OneTime1]

Just updating my previous post, I have managed to get the chart to insert correctly with no errors and have it look the way I want as well. I changed my code to this using the above help from playaller;

Please Login or Register  to view this content.

Thank you for posting that code change for me playaller.