how to "refreash" charts in report design view to show live data?

S

sburnham3

What method, process or function modified or updates the design view of a
chart in a report so that the actual data shows up with the datasets from my
query. It is a mystery to me when or why it stops showing the North, South,
East generic data.
I am having great trouble formating the charts and hiding data sets to get
the reports I want.
 
D

Duane Hookom

I just view the datasheet of the Row Source of the control and copy the
records to the clipboard. Then go into the design of the Chart Object and
view the datasheet there (North, South,...). Delete the NSEW records and
paste the Row Source data.
 
S

sburnham3

Duane thanks for the tip ... I'm going to try that, but sometimes it just
happens. I'd hope to learn why and how to force it to happen. I can
understand not doing in by default, the update every time, especially in a
huge report could be painful.
Thanks again for the workaround.
 
Top