Flickering charts

Question

Hello,

I have a few workbooks which i use to run data through periodically to output some charts. they are all very similar workbooks just slightly adjusted to suit the format of the data inputted.

as the data size is always different i manually adjust the chart plotting size by dragging the blue box to the end of the data. this works ok on 8 out of the 11 workbooks, but on 3 of them it doesn't work. as soon as i click the chart to show the blue box ready to adjust, they flicker (the coloured boxes and the filter icons to the right) this only happens on 3 of the workbooks so i am sure it is not an issue with the software itself, more a settings or hidden confliction i cannot find in those workbooks

Where is the best place i can start to look?

Thanks

Aron

Answer 1

Dear ABur_1,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

Don't worry. To better understand your situation and troubleshoot, please provide the information below:

1. Can you please upload the screenshot of what you are trying to do for us to clearly understand the situation.
2. Also, If you copy the data from those 3 problematic Workbook to new workbooks, does the problem happen?
3. What is special with these problematic Workbooks? Is it size difference?
4. from your statement "just slightly adjusted to suit the format of the data inputted.", what format of data is included in these 3 worksheets?

We apologize for the inconvenience. Thank you for your cooperation. We look forward to your reply.

Sincerely, 

Edwine | Microsoft Community Moderator