SOLVED
Home

Hide columns, still use data in charts

Highlighted
Scott Cox
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?

2 Replies
Solution

Re: Hide columns, still use data in charts

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

Re: Hide columns, still use data in charts

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

Related Conversations