• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charts/Slicers aren't visible until I click/move mouse over them (SOLVED)

C

c4barber

New Member
Hi everyone,

I'm facing a weird situation where the charts + slicers I have for some pivot data are just showing as blank white space until I move the mouse over them or click on them. Below is a picture of the issue.

http://imgur.com/a/4fvGd

The top image is what it should look like but the below is what it sometimes looks like when the data refreshes.

Is this possibly due to the large amount of data in involved? There is about 4mb (30 rows) of unformatted data.

Any help is appreciated.

Thanks,
 
Amount of data should not be a problem, but you should check if the values you are clicking on Slicers actually have any values corresponding to them in your data set.

thanks.
 
Thanks Ajesh, all data is linked though and there were no issues with it putting anything on the screen. It is just a visibility issue.

I just played around with it further and I may have resolved the issue. I was putting the pivots they were linked to on hidden rows below the charts. I moved the pivots on to separate sheets and there is no longer a display issue. Looks like bad form caused this on my end
 
Yes, hidden rows must have been the culprit. Good news that you figured it out.

Cheers Mate!!
 
You must log in or register to reply here.
Back
Top