Pokrewne
- Strona Główna
- McGraw.Hill,.Digital.Animation.Bible.Creating.Professional.Animation.with.3ds.Max.Lightwave.and.Maya.(2004).LiB
- Famous Flyers Rachel A. Koestler Grack Eddie Rickenbacker (2003)
- Harvard Business School Press Working Identity 2003
- Mark W. Harris Historical Dictionary of Unitarian Universalism (2003)
- Ellen Meiksins Wood Empire of Capital (2003)
- Science Fiction (28) lipiec 2003
- Science Fiction (25) kwiecien 2003
- Jedwabne Geszefty
- King Stephen Czarny dom 2
- Sience fiction kwiecien 2001 (3)
- zanotowane.pl
- doc.pisz.pl
- pdf.pisz.pl
- euro2008.keep.pl
[ Pobierz całość w formacie PDF ]
.But as you probablyHow Excel handlesknow already, Excel is no slouch when it comes to presentingchartsdata visually in the form of a chart.This chapter presents anintroductory overview of the Excel program s charting ability.Embedded chartsversus chart sheetsThe parts of a chartWhat Is a Chart?Using the ChartI start with the basics.A chart is a visual representation ofWizard to createnumeric values.Charts (also known as graphs) have been anchartsintegral part of spreadsheets since the early days of Lotus 1-2-3.Charts generated by early spreadsheet products were quitecrude but have improved significantly over the years.You ll Printing chartsfind that Excel provides you with the tools to create a widevariety of highly customizable charts.&' &' &' &'Although Excel can produce some great charts, it certainlyNote doesn t generate the best-looking charts possible.Andyou ll eventually encounter some limitations with the Excelprogram s charting features.Not surprisingly, other soft-ware products that are devoted exclusively to charting cangenerate higher-quality charts and provide a great dealmore flexibility.Refer to Appendix B for a list of other chart-ing software that s available.Displaying data in a well-conceived chart can make your num-bers more understandable.Because a chart presents a picture,charts are particularly useful for summarizing a series of num-bers and their interrelationships.Making a chart can often helpyou spot trends and patterns that may otherwise go unnoticed.Figure 16-1 shows a worksheet that contains a simple columnchart that depicts a company s sales volume by month. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 340Part III &' Creating Charts and Graphics340Viewing the chart makes it very apparent that sales were off in the summer months(June through August), but they increased steadily during the final four months ofthe year.You could, of course, arrive at this same conclusion simply by studyingthe numbers.But viewing the chart makes the point much more quickly.Figure 16-1: A simple column chart depicts themonthly sales volume.A column chart is just one of many different types of charts that you can createwith Excel.How Excel Handles ChartsBefore you can create a chart, you must have some numbers sometimes knownas data.The data, of course, is stored in the cells in a worksheet.Normally, the datathat a chart uses resides in a single worksheet, but that s not a strict requirement.As you ll see, a chart can use data that s stored in any number of worksheets, andthe worksheets can even be in different workbooks.A chart is essentially an object that Excel creates upon request.This object consistsof one or more data series, displayed graphically.The appearance of the data seriesdepends on the selected chart type.For example, if you create a line chart that usestwo data series, the chart contains two lines, each representing one data series.The data for each series is stored in a separate row or column.Each point on theline is determined by the value in a single cell and is represented by a marker.Youcan distinguish each of the lines by its thickness, line style, color, or data markers(squares, circles, and so on).Figure 16-2 shows a line chart that plots two data series across a 12-year period.I used different data markers (squares versus circles) to identify the two series,as shown in the legend at the bottom of the chart. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 341Chapter 16 &' Getting Started Making Charts341Figure 16-2: This line chart displays two data series.A key point to keep in mind is that charts are dynamic.In other words, a chartseries is linked to the data in your worksheet.If the data changes, the chart isupdated automatically to reflect those changes.After you ve created a chart, you can always change its type, change the formatting,add new data series to it, or change an existing data series so that it uses data in adifferent range.Before you create a chart, you need to determine whether you want it to be anembedded chart or one that resides on a chart sheet.However, you can changeyour mind later on.It s very easy to convert an embedded chart to a chart sheet(and vice versa).Embedded chartsAn embedded chart basically floats on top of a worksheet, on the worksheet s draw-ing layer.The charts shown previously in this chapter are both embedded charts.As with other drawing objects (such as a text box or a shape), you can move anembedded chart, resize it, change its proportions, adjust its borders, and performother operations.Using embedded charts enables you to print the chart next to thedata that it uses.To make any changes to the actual chart in an embedded chart object, you mustclick it to activate the chart.When a chart is activated, Excel s menu changes:The Chart menu replaces the Data menu, and some of the other menus are alsochanged. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 342Part III &' Creating Charts and Graphics342Chart sheetsWhen you create a chart on a chart sheet, the chart occupies the entire sheet.If you plan to print a chart on a page by itself, using a chart sheet is often yourbetter choice.If you have many charts to create, you may want to create each oneon a separate chart sheet to avoid cluttering your worksheet [ Pobierz całość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl agnieszka90.opx.pl
.But as you probablyHow Excel handlesknow already, Excel is no slouch when it comes to presentingchartsdata visually in the form of a chart.This chapter presents anintroductory overview of the Excel program s charting ability.Embedded chartsversus chart sheetsThe parts of a chartWhat Is a Chart?Using the ChartI start with the basics.A chart is a visual representation ofWizard to createnumeric values.Charts (also known as graphs) have been anchartsintegral part of spreadsheets since the early days of Lotus 1-2-3.Charts generated by early spreadsheet products were quitecrude but have improved significantly over the years.You ll Printing chartsfind that Excel provides you with the tools to create a widevariety of highly customizable charts.&' &' &' &'Although Excel can produce some great charts, it certainlyNote doesn t generate the best-looking charts possible.Andyou ll eventually encounter some limitations with the Excelprogram s charting features.Not surprisingly, other soft-ware products that are devoted exclusively to charting cangenerate higher-quality charts and provide a great dealmore flexibility.Refer to Appendix B for a list of other chart-ing software that s available.Displaying data in a well-conceived chart can make your num-bers more understandable.Because a chart presents a picture,charts are particularly useful for summarizing a series of num-bers and their interrelationships.Making a chart can often helpyou spot trends and patterns that may otherwise go unnoticed.Figure 16-1 shows a worksheet that contains a simple columnchart that depicts a company s sales volume by month. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 340Part III &' Creating Charts and Graphics340Viewing the chart makes it very apparent that sales were off in the summer months(June through August), but they increased steadily during the final four months ofthe year.You could, of course, arrive at this same conclusion simply by studyingthe numbers.But viewing the chart makes the point much more quickly.Figure 16-1: A simple column chart depicts themonthly sales volume.A column chart is just one of many different types of charts that you can createwith Excel.How Excel Handles ChartsBefore you can create a chart, you must have some numbers sometimes knownas data.The data, of course, is stored in the cells in a worksheet.Normally, the datathat a chart uses resides in a single worksheet, but that s not a strict requirement.As you ll see, a chart can use data that s stored in any number of worksheets, andthe worksheets can even be in different workbooks.A chart is essentially an object that Excel creates upon request.This object consistsof one or more data series, displayed graphically.The appearance of the data seriesdepends on the selected chart type.For example, if you create a line chart that usestwo data series, the chart contains two lines, each representing one data series.The data for each series is stored in a separate row or column.Each point on theline is determined by the value in a single cell and is represented by a marker.Youcan distinguish each of the lines by its thickness, line style, color, or data markers(squares, circles, and so on).Figure 16-2 shows a line chart that plots two data series across a 12-year period.I used different data markers (squares versus circles) to identify the two series,as shown in the legend at the bottom of the chart. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 341Chapter 16 &' Getting Started Making Charts341Figure 16-2: This line chart displays two data series.A key point to keep in mind is that charts are dynamic.In other words, a chartseries is linked to the data in your worksheet.If the data changes, the chart isupdated automatically to reflect those changes.After you ve created a chart, you can always change its type, change the formatting,add new data series to it, or change an existing data series so that it uses data in adifferent range.Before you create a chart, you need to determine whether you want it to be anembedded chart or one that resides on a chart sheet.However, you can changeyour mind later on.It s very easy to convert an embedded chart to a chart sheet(and vice versa).Embedded chartsAn embedded chart basically floats on top of a worksheet, on the worksheet s draw-ing layer.The charts shown previously in this chapter are both embedded charts.As with other drawing objects (such as a text box or a shape), you can move anembedded chart, resize it, change its proportions, adjust its borders, and performother operations.Using embedded charts enables you to print the chart next to thedata that it uses.To make any changes to the actual chart in an embedded chart object, you mustclick it to activate the chart.When a chart is activated, Excel s menu changes:The Chart menu replaces the Data menu, and some of the other menus are alsochanged. 20 539671 ch16.qxd 8/28/03 10:04 AM Page 342Part III &' Creating Charts and Graphics342Chart sheetsWhen you create a chart on a chart sheet, the chart occupies the entire sheet.If you plan to print a chart on a page by itself, using a chart sheet is often yourbetter choice.If you have many charts to create, you may want to create each oneon a separate chart sheet to avoid cluttering your worksheet [ Pobierz całość w formacie PDF ]