MS Access Chart only shows Sample Data

[pckong]

Hello

I have created a chart report, but for some reasons, it only shows Sample data (East, West, North, 1st Qtr, 2nd Qtr, 3th Qtr, 4th Qtr etc). It is in Design View. If I do Print Preview, it looks fine.
Can anyone help me to have the Chart properly displayed in Design View?

Thanks
Pete

 

[apr pillai]

You must copy and paste the Data from Table/Query to the Chart Data Grid. Check the following link for guidance:

Ms-Access Graph Chart2

 

[pckong]

Thanks for the reply. Yeah, I checked it. It works

 

[pckong]

But wait a second, I am doing another chart, and it does not have the table data to copy from. It is automatic generated, where do I copy the data from to the Chart Data Grid?

For example, Chart I generated based on Raw Source
"SELECT [Field1], COUNT (*) As [COUNT] FROM [TABLE1] GROUP BY [FIELD1]; "
In this case, the Table1 data don't have the count field and I dont want to generate an additional field to mess up with the data.
What should I do?

 

[pckong]

I have found the answer!
Basically, you can go to Design View for the Chart, click on Property and select Row Source, it will direct you to a Query Builder, and then you can build your Query. After finished building your Query, go to Datasheet View of the Query you have just built, and you can copy the data from there, and copy them to the Chart Data Grid, that should solve the problems.
Cheers