Spreadsheet Charts

The Rough Riders stacked bar chart above was created to represent the total sales of each employee over a four month period. Which feature will make the plot easier to read?

• Axis title
• Chart title 
• Data series 
• Gridlines

The figure above is a chart that represents the effect of irrigation on plant height. Which feature should be added to the chart that will explain the chart's purpose?

• Axis title
• Chart title
• Data label
• Legend

When creating a chart to analyse the effect of oil prices on the cost of stocks, which data will appear on the y-axis?

• Months
• Oil prices
•  Stock names
• Stock prices

When creating a chart to analyze the effects of oil prices on the cost of stocks , which data will appear on the x-axis?

• Months
• Oil prices
• Stock Names
• Stock Prices

A chart is created that compares the number of units of Product A sold against the number of units of Product B sold for a three month period. Which data appears on the y-axis?

• Months
• Products
• Sales
• Units Sold

A chart is created that compares the number of units of Product A sold against the number of units of Product B sold for a three month period. Which data appears on the x-axis?

• Months
• Products 
• Sales
• Units Sold

Which chart will BEST represents the decline of sales for a music company over the past five years? 

• Column 
• Line
• Pie
• XY scatter

Which chart will Best represent a comparison of the average family income in three states with emphasis on the states?

• Column
• Line
• Pie
• XY scatter

Which will BEST represent each spouse's contribution to the to total household budget over a period of six months?

• Exploded pie
• Pie
• Stacked bar
• XY scatter

Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget? 

• Line 
• Pie
• Stacked bar
• XY scatter