hide chart data & chart

Hi,

I have a Chart on my Sheet, which is being displayed on Userform.

Now I want to hide chart data & chart from Sheet, but still let Chart be visible on Userform.

I hide Chart like this :

Please Login or Register  to view this content.

This works, no problem.

But when It comes to chart data, I have problems...

So far I have tried all this :

1. Formating these cells to ";;;", but that messes up chart data - on chart.

2. Hide rows in VBA, but then Chart is not displayed on Userform.

3. Clicked on the chart then went to Tools>Options >Select the Chart tab> unticked the "plot visible cells only" option. Nothing happens here ?!?

Does anybody have other suggestion, with VBA maybe ?

Thanks for help !!

Depending on your data and your real aim you can:

Quick try1:
How about formatting cells with white font colour

That worked just fine, thanks for your help !!!