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

  • Thread starter Thread starter Stephen Eastmead
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
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.
 
Back
Top