Charts Fundamentals

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Charts Fundamentals

Introduction

A chart is a technique of displaying data using pictures and graphical representations instead of numbers or simple words. It works by drawing figures that would represent numbers, adding colors and shapes to the information presented.

Good created and formatted charts can help people and businesses make decisions based on the impact that the images provide. Data analysis on charts is done using graphics that present pictures. In addition to the pictures, you can add words, also called labels to indicate what the pictures represent.

Because a chart is used to present data in a graphical format, before creating a chart, you should plan it. That is, you should prepare it. There are two pieces of information you should have before starting: The numbers that you want to represent and the type of chart you want to use.

Creating a Chart

The information used to create a chart usually come from two or more cells of a worksheet. Before creating a chart, you should prepare it so it can be easily recognizable. Data used on a chart can be made of natural numbers or percentage values. You can also present a series of repeating words and let the chart engine count the occurrences of such words before using them as numbers.

To start a chart, after selecting the cells, on the Ribbon, click Insert. In the Chart section, click one of the buttons to display the available types of charts, then select one of them. After making your selection, a chart would be created for you.

To present its information more efficiently, a chart is made of different sections. The main area allows users to view the graphical display of data. A legend explains the meaning of various colors on the chart. A title indicates what the chart is used for.

Practical Learning: Creating a Chart

  1. Open the Altair Realtors1.xlsx workbook
  2. Click the Sales by Types tab and select Cells B5:E6
  3. On the Ribbon, click Insert
  4. In the Chart section, click the Column button. In the menu that appears, click the very first option on the top-left side: Clustered Column
     
    Chart
  5. Save the workbook