These results ranged from Month, as shown in Figure 5-11, to Category, to a blank value. Your results
may vary.
CHAPTER 5 n CHARTING IN EXCEL 2007 203
3. Choose Category from the ???Sort by??? list under the Column listing, as shown in
Figure 5-12.
Figure 5-12. Choosing Category as the first sort field
4. Choose A-Z from the Order drop-down list, as shown in Figure 5-13.
Figure 5-13. Choosing the sort order for Category
5. Click the Add Level button on the Sort dialog box to add a new blank sort item to the
sort list, as shown in Figure 5-14.
CHAPTER 5 n CHARTING IN EXCEL 2007 204
Figure 5-14. New item added to the sort list
6. In the ???Then by??? drop-down list, select Month, as shown is Figure 5-15.
Figure 5-15. Adding Month to the sort list
7. Select Custom List from the Order drop-down, as in Figure 5-16. If we choose either
alpha sort option, the months will sort alphabetically by name rather than ascending
or descending order by month.
Figure 5-16. Choosing Custom List
CHAPTER 5 n CHARTING IN EXCEL 2007 205
8. The Custom Lists dialog box will appear. Choose the item labeled Jan, Feb, Mar, and so
on, as shown in Figure 5-17.
Figure 5-17. Custom Lists dialog box
9. Click OK to return to the Sort dialog box.
10. Click OK to close the Sort dialog box and sort the data.
The data should now look like that in Figure 5-9.
Creating the Pie Chart
In this example, we are going to create a pie chart based on the data for one product category.
The chart will show the monthly sales for the category.
Pages:
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205