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 :

Activesheet.ChartObjects.Visible=False
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 !!