Page 228 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 11: Operations of MS Excel

11.3.3 Modifying Your Chart Notes

You can quickly create a basic chart, and you can make numerous enhancements and
formatting changes. After you activate Microsoft Graph to create a chart, it’s easiest to
proceed in this order:
1. If you don’t want a 3D column chart, change the chart type.
2. Type the text and numbers for your chart in the datasheet.
3. Type a title for the chart slide.
4. Modify and format chart objects as needed.

(i) Before creating an actual chart, design a paper sketch of the chart
you want to create. This can help you understand which chart type
is right for your specific chart.
(ii) For help in using Microsoft Graph, choose Help, Microsoft Graph
Help. This opens the help file specific to this application.

11.3.4 Selecting a Chart Type

PowerPoint offers plenty of chart types and sub-types for almost every kind of graphic
representation you could want to create. Sub-types are variations on a basic chart type, such
as 3D options. PowerPoint includes these basic chart types:
Column: Creates vertical columns to compare the values of categories of data. Column,
bar, and line charts work well if you want to compare values over time periods such
as months or quarters. Figure 11.7 illustrates a sample column chart.

Figure 11.7: A Column Chart Makes it Easy to Compare Series of Data

Bar: Creates horizontal bars to compare the values of categories of data.
Line: Creates a line with markers for each data value.

LOVELY PROFESSIONAL UNIVERSITY 221