Question

Which type of charts can Excel produce ?

1. Line graphs and pie charts only
2. Line graphs only
3. Bar charts, line graphs and pie charts
4. Bar charts and line graphs only

Answer 1

Correct Answer - Option 3 : Bar charts, line graphs and pie charts

The correct answer is Bar charts, line graphs, and pie charts.

• A chart is a powerful tool that allows you to visually display data in a variety of different chart formats. MS Excel can produce different chart formats such as Bar, Pie, Line, Column, Area, Scatter, Surface, or Radar charts.
• Excel offers the following major chart types :
  • Column Chart
  • Line Chart
  • Pie Chart
  • Doughnut Chart
  • Bar Chart
  • Area Chart
  • XY (Scatter) Chart
  • Bubble Chart
  • Stock Chart
  • Surface Chart
  • Radar Chart
  • Combo Chart

Therefore correct answer is Option 3