Jun 28 2020 07:33 PM
Hi:
My excel version is Office 365 Proplus, 1902 version.
I use some macros in these charts but the total file size is about 800k.
I encounter 2 issues and it seriously affect the working efficiency.
1. The chart shows gray bar every time when opening the excel file.
Like the pictures I show below.
2. Every time when I scroll the windows the as long as it touch the chart then lags 3-5s and the chart will appear gradually. Please refer to the following gif.
Both symptoms just appear in the version after office 2016, because I can't reproduce them in Office 2013. I think it must some new features affect in the new version after Office 2016.
Is there any approach to resolve these 2 symptoms?
Thank you so much.
Zac
Jun 29 2020 05:56 AM
SolutionHi @Zac_Chen2020;
Point 01
You need to debug you code and see what is making this mess & slight alter the code accordingly. What I can understand it is not finding the range of the data source.. It will be difficult to comment until not debug and see the code.
Point 02
You need to adjust the chart settings by selecting the chart & right click you see the format chart area > select "Don't move or size with cells"
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jun 29 2020 05:56 AM
SolutionHi @Zac_Chen2020;
Point 01
You need to debug you code and see what is making this mess & slight alter the code accordingly. What I can understand it is not finding the range of the data source.. It will be difficult to comment until not debug and see the code.
Point 02
You need to adjust the chart settings by selecting the chart & right click you see the format chart area > select "Don't move or size with cells"
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more