Hidden Data in Charts Excel

[QSM]

Goodmorning,

I am working with Excel and for protectional reasons I hide some columns. This gives a problem with charts as the hidden data is not reflected in the charts.

Question: Is there a way to show hidden data in charts? I am using embedded charts in Excel XP.

Kind regards,
Yuri

 

[SkipVought]

Hi,

Tools/Options - Chart Tab: Uncheck Plot visible cells only

Skip,

_[red][/red]

 

[QSM]

Thanks. As always the solution is simple after you know it.