I am using Microsoft Excel 2010 to create a macro in VBA ,which plots xy coordinates and it's related efficiency in a pivot table, then creates two graphs based on that pivot table. So far I have been able to create the pivot table, plot the data , and create two charts; the problem that I am having is that the two charts that are created must be placed their own sheets, right now they are placed on the same sheet as the pivot table. I can add new sheets, but I cant get the charts on them. The new sheets are called "3-D Map" and "2-D Map". How do I get the charts on different sheets?
Bookmarks