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?
View best response
Right click on chart -> Select Data -> Hidden and Empty Cells (a button at bottom left) -> Check Show data in hidden rows and columns
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