What are basic charts in Excel?

What are basic charts in Excel?

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this tutorial, you will learn how to insert charts and modify them so they communicate information effectively.

What is XY chart in Excel?

Scatter (X Y) charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data. A Scatter Chart has two value axes − Horizontal (x) value axis. Vertical (y) value axis.

How do I build a chart in Excel?

Create a chart

  1. Select the data for which you want to create a chart.
  2. Click INSERT > Recommended Charts.
  3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.
  4. When you find the chart you like, click it > OK.

How do I create a chart in Excel 2010?

Creating Chart

  1. Select the data for which you want to create the chart.
  2. Choose Insert Tab » Select the chart or click on the Chart group to see various chart types.
  3. Select the chart of your choice and click OK to generate the chart.

How to create a basic Excel chart?

Get your data ready. Before she dives right in with creating her chart,Lucy should take some time to scroll through her data and fix any errors that she

  • Insert chart and select chart type. With her data cleaned up,Lucy is ready to insert her chart into her spreadsheet.
  • Double-check your chart.
  • Customize your chart.

    • How do make a chart in Excel?

    Using Figure A as a guide,enter and select the counties (B3:B7).

  • Click the Data tab.
  • In the Data Types gallery,click Geography. If it isn’t visible in the Quick gallery,click the gallery’s More button.

    • How to insert chart in Excel?

    Select data for the chart.

  • Select Insert > Recommended Charts.
  • Select a chart on the Recommended Charts tab,to preview the chart.
  • Select a chart.
  • Select OK.

    • What are the different types of Excel charts?

    Excel Chart Types: Pie, Column, Line, Bar, Area, and Scatter. This tutorial discusses the most common chart types, and sub-types, supported by Excel. For related tutorials, see our Chart & Graph Information Center. And if you create a lot of charts, we like Meaningful Graphs: Informative Excel Charts (affiliate link).