Hi Mynda
I followed your lesson in chapter 6 in the Excel Dashboards on using macro button to enable moving charts
The macro is working but I cannot get the chart bar to synchro with macro, therefore, chart does not appear to be moving and the entire chart only shows up at the end of macro.
Please help me in finding how i can do to make it move. please see the tab "Interactive Controls" in red tab.
Hi Junko,
Looks like your file didn't get uploaded. Please click the yellow 'start upload' button after selecting your file.
Mynda
Hi Mynda
I have uploaded my file this time.
Hi Junko,
The chart might not be refreshing for some reason, add this code above Sleep(1000) line:
DoEvents
ActiveSheet.ChartObjects("Chart 2").Activate
Cells(1).Select
This should force chart to update. Not elegant though.
