Upgraded to 2016: Graphs are no longer animated running VBA

JetEscamilla

Board Regular
Joined
Apr 17, 2006
Messages
87
Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before:

Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen. Those numbers create some graphs that used to update. This was handy because we could see at what step (approximately) something ruptured. Now when I run the same macro only the numbers are updating, the charts stay frozen until the end of the run.

I've tried inserting some chart updating directly into my code, but that's not working either.

"ActiveSheet.ChartObjects("Chart 1").Chart.Refresh"

I've ensured that screedupdating was "true".

Like I said, the numbers update but the graphs are not. I'd honestly rather have that flipped, graphs only and I don't care for the numbers to update.

I appreciate any help.

Thanks!
 

John_w

MrExcel MVP
Joined
Oct 15, 2007
Messages
5,945
Try activating the chart object:
Code:
ActiveSheet.ChartObjects("Chart 1").Activate
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,699
It would be helpful if you shared some actual code, that used to work but no longer does.

Also, what version of Excel were you using when the code worked?
 

Forum statistics

Threads
1,077,822
Messages
5,336,564
Members
399,088
Latest member
Swindlestikz

Some videos you may like

This Week's Hot Topics

Top