Is there a way to hide column but still show data in chart?

[SereneSea]

Just thinking, is there a way or a macro of hiding a column but still have the data show in the chart created? (not a pivot table)?

 

[BSALV]

hide is setting the columnwidth to 0.
So if you don't hide those columns but make their width for example 0.1 (=visual the same), they are still in your chart
With the boolean parameter in ShowColumns, you show or semi-hide certain columns.
You can call this macro in another macro

Sub testColumns()
     ShowColumns True
     MsgBox "not hidden"
     ShowColumns False
     MsgBox "columns visual hidden"
     ShowColumns True
End Sub

Sub ShowColumns(b As Boolean)
     Columns("H:I").ColumnWidth = IIf(b, 10, 0.1)               'swap between columnwidth 10 and .1
End Sub

 

[SereneSea]

Wow so simple, I totally forgot about actually setting a width, I have just been dragging it! Thanks!

 

[BSALV]

you're welcome.
i also added a small macro

 

[SereneSea]

you're welcome.
i also added a small macro

Wow you are amazing, thank you so much !!