Insert chart into a report, then design view does not show my data but a MS datasheet

[Stephen Eastmead]

Dear All,

I suspect this is an old problem but can you tell me how I can get my data
carried forward into design view as I cannot configure the graph correctly
ie adding a trendline.
All I get is the MS example data North West East etc

Thanks

Stephen

 

[fredg]

Dear All,

I suspect this is an old problem but can you tell me how I can get my data
carried forward into design view as I cannot configure the graph correctly
ie adding a trendline.
All I get is the MS example data North West East etc

Thanks

Stephen

Create your chart first on a form.
After you get it properly set up, copy and paste it into your report.
It will then show the correct data in design view.

 

[Duane Hookom]

The other method is to view your report in design view and open the
datasheet view of the chart's Row Source. Select and copy the datasheet view
and then close the Row Source.

Open the chart design and view the chart's meager datasheet. Paste the
chart's Row Source records over (replace) the chart's datasheet.