Chart Objects Cont'd

[NatalieEC]

Hello,

I have made three buttons that make histograms which work. I wrote my code so that the plots are each placed in a specific location. However, if I click another button to get a separate chart, it is plotted on top of the other histogram, and both are moved to the location of the newly made histogram.

Here is my code for one of the histograms. The other codes are pretty much the same. I have it so that if I ask to make a new histogram, the old histogram (with the same title) is deleted.

Thank you.

Please Login or Register  to view this content.

[Jon_Peltier]

After

Please Login or Register  to view this content.

you should set a new chart object variable to the newly created chart, and position this chart explicitly:

Please Login or Register  to view this content.

This eliminates the possible (guaranteed?) confusion trying to identify charts based on chart title etc.

[NatalieEC]

Thank you for your suggestion. I have tried implementing this idea, and it is not working yet unfortunately. My plots are still being plotted on top of each other and moving.

[Jon_Peltier]

Are you changing the right side of the equations in the "With ChtNew/End With" block?

[NatalieEC]

Hi Jon,

Sorry for my late reply.

Yes, I did do that, and still no luck. However, on some other code, I was able to keep plots in place by referencing them by their index number.

Thanks for your help!