MS Excel - Charts

for more contents: http://tests.guru/

1. Session 07 Charts [email protected]

2. Charts Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. [email protected]

3. Example of a combination charts [email protected]

4. Getting to know the elements of a chart [email protected]

5. Charts Elements Chart Area Plot Area Data points Axis Legend Title Data Label [email protected]

6. 1. Chart area The entire chart and all its elements. [email protected]

7. 2. Plot area In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles. [email protected]

8. 3. Data points The data points  of the data series that are plotted in the chart. Individual values plotted in a chart are called data markers. Data markers of the same color constitute a data series. Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series [email protected]

9. 4. Axis The horizontal (category) and vertical (value) axis along which the data is plotted in the chart. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories. [email protected]

10. 5. Legend A box that identifies the patterns or colors that are assigned to the data series or categories in a charts. [email protected]

11. 7. Data label A label that provides additional information about a data marker, which represents a single data point or value that originates from a datasheet cell. [email protected]

12. 6. Titles in charts  Descriptive text that is automatically aligned to an axis or centered at the top of a chart. [email protected]

13. Types of Charts Column Line Pie Bar Area Scatter Stock Surface Doughnut Bubble Radar [email protected]

14. Create a basic chart On the worksheet, arrange the data that you want to plot in a chart. Select the cells that contain the data that you want to use for the chart. On the Insert tab, in the Charts group Click the chart type , and then click a chart subtype that you want to use. By default, the chart is placed on the worksheet as an embedded chart. [email protected]

15. Pie Chart …. A pie chart shows only a single data series. Pie charts are very useful charts to show percentage distribution. [email protected]

16. Pie Chart A 1 B 2 C 3 A B C 1 2 3 OR [email protected]

17. Line chart [email protected]

18. Column chart [email protected]

19. Bar chart [email protected]

20. Surface chart [email protected]

21. Scatter [email protected]

22. Printing document [email protected]

23. Print Area …. One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed. [email protected]

24. Set a print area On the worksheet, select the cells that you want to define as the print area. On the Page Layout tab, in the Page Setup group, click Print Area , and then click Set Print Area . Note:    The print area that you set is saved when you save the workbook. [email protected]

25. Add cells to an existing print area On the worksheet, select the cells that you want to add to the existing print area. On the Page Layout tab, in the Page Setup group, click Print Area , and then click Add to Print Area . [email protected]

26. Clear a print area Click anywhere on the worksheet for which you want to clear the print area. On the Page Layout tab, in the Page Setup group, click Clear Print Area . [email protected]

27. Print Titles If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled. [email protected]

28. Repeat Heading Rows Page 1 Page 2 [email protected]

29. Repeat specific rows or columns on every printed page Select the worksheet that you want to print. On the Page Layout tab, in the Page Setup group, click Print Titles . On the Sheet tab, under Print titles , do one or both of the following: In the Rows to repeat at top box, type the reference of the rows that contain the column labels. In the Columns to repeat at left box, type the reference of the columns that contain the row labels. [email protected]

30. Print Preview Before printing a worksheet you can see how the sheet will look when you print it Print Preview allows you to adjust the columns and margins easily Preview window has buttons to get different views of the pages go to the Print and Page Set up dialog boxes view all the pages of the worksheet in preview [email protected]

31. Preview worksheet pages before printing Click the worksheet or select the worksheets that you want to preview. Click the Microsoft Office Button , click the arrow next to Print , and then click Print Preview . Keyboard shortcut   You can also press CTRL+F2. To preview the next and previous pages, on the Print Preview tab, in the Preview group, click Next Page and Previous Page . To view page margins, on the Print Preview tab, in the Preview group, select the Show Margins check box. [email protected]

32. Make a worksheet fit the printed page On the status bar, click the Page Layout button to switch from Normal to Page Layout view. In the Scale to Fit group, in the Width box, select 1 page , and in the Height box, select 1 page . Columns will now appear on one page, but the rows may extend to more than one page. [email protected]

33. THANKS [email protected]