Summary charts are graphical representations of summary data tables. These tables have at least one row that combines the numerical data of several previous rows. An example of a summary chart is a pie chart showing one company’s total sales for the last quarter, created from a table of detailed sales data for that quarter. You can use the spreadsheet application Microsoft Excel to create a summary chart, once you summarize the chart’s data table and prepare that table for Excel’s chart wizard. Select “Publisher” in the “Sort by” drop-down list. Select “Values” in the “Sort on” list. Select “A to Z” in the “Order” list. Press “OK” to exit the dialog box and sort the data by publisher. Select “Publisher” for the drop-down list next to the text “At each change in:” Select “Sum” for the “Use function” drop-down list. Check the “Sales” checkbox for the “Add subtotal to” list. “Replace current subtotals” “Summary below data” Press “OK” to create the summary rows for the publisher data. Notice that Excel has inserted boldface rows into the data, to add up the separate sales figures for each publisher. Writer Bio
