Chapter 8
Baking Pie and Bar Charts
Section 1
Queries Optimized for Pie Charts and Bar Charts
Pie chart queries need to return labels, counts, and percentages. The percentages in the pie chart queries need to add up to 100 percent. Bar chart queries need to return a label and a numeric value. - Write a query that will utilize group by and order by clauses to take advantage of the database server's processing power - In the Report Wizard, paste the query into the Query text box and display the results in a table - Preview the report to make sure the data shown in the table is correct before proceeding to insert the chart