ajchriston
New Member
- Joined
- Jun 3, 2013
- Messages
- 2
Hey guys, I am having some trouble figuring out the best way to approach this problem. I need to create 1-6 tables on one sheet from 1-6 data sets on the same sheet. to create the charts, I use a button that runs a macro to make the chart. I also have a "reset button" which deletes the chart of the appropriate data set and lets you change some values and recreate it. My issue is when you delete them out of order, the indexes of the charts get messed up. Is there anyway to refer to the chart in a different way that isn't automatically changed when one is created or deleted (like a name). Or can I somehow use an array to keep track of the different charts?
Anything helps!!
Anything helps!!