Figure 5-32. The Candy chart is properly formatted and inserted below the Beverages chart.
Summary
In this chapter, we??™ve been exploring charting in Excel. We began by recording a macro while
manually creating a bar chart. We examined the AddChart method, which adds a new chart to
a worksheet, and we saw the SetSourceData method, which assigns a range of data to the
chart. We saw in Table 5-2 the many types of charts Excel makes available to us. We also
looked at the PlotBy property, which allows us to switch a chart??™s data orientation from row
to column and vice versa.
We then looked at pie charts, and as we did, we also learned a bit about sorting data in
Excel. Next, we learned how to use some of the AddChart method??™s arguments to place a chart
at a given location on a worksheet. And finally, we expanded on that idea to create dynamic
code that lets the user select a data range to chart, and we built routines to create a chart from
that data, placing it below the last chart on the worksheet.
Charts are a great way to make large sets of data more understandable for analysis by
compressing the data into a visual image. In the next chapter, we??™ll look at another one of
Excel??™s excellent analysis tools: PivotTables.
CHAPTER 5 n CHARTING IN EXCEL 2007 221
PivotTables
PivotTables are a neat feature of Excel 2007 that allows users to summarize and analyze data.
By adding or removing data elements from an onscreen selection tool, your users can easily
reshape their data for analysis or reporting.
Pages:
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219