Forum Discussion

Scott Cox's avatar
Scott Cox
Brass Contributor
Jul 28, 2017
Solved

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?
Charting
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 28, 2017

    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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 28, 2017

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

  • Deleted's avatar
    Deleted
    Jan 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

Resources