Hide columns, still use data in charts

[Scott Cox]

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 · Accepted solution]

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

[#3]

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