[AccessD] Order of Data on Access 2007 Chart

Brad Marks BradM at blackforestltd.com
Mon Feb 7 16:37:54 CST 2011


All,

I am just starting to experiment with charts in Access 2007.

I have a really dumb question.

How can I make the order of a chart the same as the order of its
underlying query?

I have set up a small test table, query, and report.

The table only has two fields, Customer_Name and Customer_Amount

The query sorts the data on Customer_Amount.

The report is based on the query and shows the data sorted on
Customer_Amount

I added a chart with the "Insert Chart" button on the Access 2007
ribbon.

I stepped through the chart wizard and picked the underlying query.

I was expecting to see the generated chart to be sorted the same as the
query and the report.

Instead, it is sorted on Customer_Name.

I can't seem to figure out what I am missing here.

Thanks,
Brad




More information about the AccessD mailing list