Page 394 - Excel 2007 Bible

25_044039 ch19.qxp 11/21/06 11:10 AM Page 351
Getting Started Making
Charts
hen most people think of Excel, they think of crunching rows and
columns of numbers. But as you probably know already, Excel is no IN THIS CHAPTER
Wslouch when it comes to presenting data visually in the form of a Charting overview
chart. In fact, it’s a safe bet that Excel is the most commonly used software for
creating charts. How Excel handles charts
This chapter presents an introductory overview of the Excel program’s charting Embedded charts versus chart
ability.
sheets
The parts of a chart
What Is a Chart?
Examples of each chart type
A chart is a visual representation of numeric values. Charts (also known as
graphs) have been an integral part of spreadsheets since the early days of Lotus
1-2-3. Charts generated by early spreadsheet products were quite crude but have
improved significantly over the years. Excel provides you with the tools to create
a wide variety of highly customizable charts.
Excel 2007 charting is a good news/bad news situation. The
NEW FEATURE good news is that Excel 2007 charts have a great new look. The
NEW FEATURE
bad news is that Microsoft did not provide any new chart types or any significant
new features.
Displaying data in a well-conceived chart can make your numbers more under-
standable. Because a chart presents a picture, charts are particularly useful for
summarizing a series of numbers and their interrelationships. Making a chart can
often help you spot trends and patterns that may otherwise go unnoticed.
Figure 19.1 shows a worksheet that contains a simple column chart that depicts
a company’s sales volume by month. Viewing the chart makes it very apparent
that sales were down in the summer months (June through August), but they
increased steadily during the final four months of the year. You could, of course,

351