Design And Create Charts And Graphs Worksheets printable pdf download

Computer Applications I

Objective 6.04 Design and CreateCharts and Graphs

Charts and Graphs

__________________ representations of the numerical data found in

a______________________________.

The chart’s illustration makes the _______________ from the spreadsheet easier to

understand.

Basic Elements of a Chart

The __________________ axis on a column or line chart is the_________________ ; it

contains the ___________________l data.

The _________________ axis on a column or line chart is_________________; it

contains the ____________________ information.

The data _________________ is the point representing the _________________ from

the spreadsheet.

To identify a specific value in a column chart, use a_____________ ______________.

The bar, column, point or area that represents the values (numbers) in a spreadsheet

graph is called the data ____________________

o Businesses often use column, bar, or line charts to illustrate the __________ in

yearly production or income over a period of______________________.

Types of Charts/Graphs Defined

Column – shows comparison of amounts by varying the heights of the______________

__________ ; one of the most popular charts with businesses. Example: Use a column

chart to compare sales figures of Ford trucks to Chevrolet trucks during the past five

years.

Bar – shows comparison of amounts by the length of the ____________

_________________ bar shapes; slightly different presentation of comparison data from

the column.

Line – a graph that uses a line to connect____________ __________________;

frequently used to show trends or changes over time. Example: Use a line chart to show

increases in domestic auto sales over the past ten years.

Pie – circular graph divided into __________________ where the slices represent

portions of a_______________. Example: Use a pie chart to show the percentage of

sales of different makes and models for the Chrysler Group.

Scatter – XY shows the __________________ between the numeric values in

__________________ chart data. Example: Use an XY scatter chart to plot sales of

multiple models of vehicles from Ford, General Motors, and Chrysler Group

Corporations.

Area – A _____________ graph that has the area ____________________ the plotted

line shaded or colored. Example: Use an area chart to show trends in sales of domestic

automobiles by the three domestic auto makers

Design And Create Charts And Graphs Worksheets