Forum Discussion
Scott Cox
Jul 28, 2017Brass Contributor
Hide columns, still use data in charts
I want to hide columns but still have charts on the same sheet reflect the data that are in these columns. How do I do this?
- Nov 24, 2022
Hello Gurdev Singh
as member you can't manage access, but you can share files and folders, but it's depend on your site setting.
See for more informations here: https://support.microsoft.com/en-us/office/set-up-and-manage-access-requests-94b26e0b-2822-49d4-929a-8455698654b3
When a member can share files and folders, you can use manage access and the + to add more people, but you can't use Advanced settings to view the direct folder permissions. That's the reason, you can't revoke the permission. Only owners can manage the real permissions 😉
A tip: don't break SharePoint folder permissions on a Teams connected site, so you have 2 permission concepts, the one from Teams (only owner, member and visitor [in public teams]) and the other from SharePoint with fully individual permissions...it can become confusing...
Hope this helps for understanding.
Best, Dave
SergeiBaklan
Jul 28, 2017MVP
Hi Scott,
Right click on chart -> Select Data -> Hidden and Empty Cells (a button at bottom left) -> Check Show data in hidden rows and columns
- DeletedJan 21, 2018
Is there a short cut to do this for all the graphs in a sheet as there are around 100s of graphs in my sheet and it will be tedious to do this for all the graphs!
Thanks & Regards
Ujjwal Agarwal