the difference between print preview and design view

[Guest]

I have a report containing a bar chart. The main report and bar chart are
linked with patient ID.
That is, datasheet for bar chart has patient ID column.
Thus, I exclude the patient ID column by using data> exclude row/col.
in the datasheet the column changed to gray and in design view everything is
correct.

But, when I try print preview the chart contains patient ID column.
I tried following codes (ACG soft recomended)

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
'This will update the data sheet
objGraph.Application.Update
DoEvents
Set objGraph = Nothing

But it does not work. I do not understand what I did wrong...
Please help me. Thank you so much.

 

[Guest]

Of course, I changed TheNameOf YourGroup into my chart name...