4.17.2 Charts (चार्ट)

A chart is a graphical representation of data in both columns and rows. Charts are usually used to analyse trends and patterns in data sets. एक चार्ट कॉलम और रो दोनों में डेटा का एक ग्राफिकल रिप्रेजेंटेशन होता है। चार्ट का उपयोग आमतौर पर डेटा सेट में रुझानों और पैटर्न का विश्लेषण करने के लिए किया जाता है।

Choosing the Right Chart (सही चार्ट का चयन)

Once results are determined that the chart is to display, choose the chart that best suits this purpose. The most popular charts are column, line, pie, and bar charts.

Column

Column charts are used to compare different values vertically side-by-side. Each value is represented in the chart by a vertical bar. If there are several series, each…

Chart Type	Description
Line	Line charts are used to illustrate trends over time. Each value is plotted as a point on the chart and is connected to other values by a line. Multiple items are plotted using different lines.
Pie	Pie charts are useful for showing values as a percentage of a whole. The values for each item are represented by different colors. Limit pie charts to eight sections.
Bar	Bar charts are just like column charts, except they display information in horizontal bars rather than in vertical columns.
Area	Area charts are the same as line charts, except the area beneath the lines is filled with color.
XY (Scatter)	Scatter charts are used to plot clusters of values using single points. Multiple items can be plotted by using different colored points or different point symbols.
Stock	Stock charts are effective for reporting the fluctuation of stock prices, such as the high, low, and closing points for a certain day.
Surface	A surface chart is useful for finding optimum combinations between two sets of data. Colors and patterns indicate values that are in the same range.
Radar	Radar charts compare the aggregate values of a number of data series.
Combination	Combination charts show a grouping of a clustered column and line (secondary) to compare values.

To insert chart in MS Excel sheet, do as follows… वर्कशीट में चार्ट इंसर्ट करने की निम्नलिखित विधि है—

1. Select the cells you want to make a chart, including the column titles and row labels. These cells will be the source data for the chart. In our example, we’ll select cells A1:F6.
2. From the Insert tab, click the desired Chart command.

Insert Column Chart

• Use this chart type to visually compare values across a few categories.
• Click the arrow to see the different types of column charts available and pause the pointer on the icons to see a preview in your document.

3. Choose the desired chart type from the chart group.
4. The selected chart will be inserted in the worksheet.

To change the chart type (चार्ट के प्रकार में बदलाव)

If you find that your data isn’t well suited to a certain chart, it’s easy to switch to a new chart type.
For example, we’ll change our chart from a Column chart to a Line chart.
From the Design tab, click the Change Chart Type command.