Forum Discussion

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

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
    MVP
    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