Page 1 :
Class notes on charts, , Q. Define chart., , Ans. Chart is a graphics representation of, data in a work sheet. It hemos to provide a, better understanding of large amount of, data., , Q. What is the use of in setting chartina, work sheet?, , Ans. Charts make it easy to draw, comparisons, see growth and relationship, song the values, and trends in data., , TYPES OF CHARTS, , s ¢ ., , *, , 1. BAR CHART - In this type of chart,, categories are represented on vertical axis, and values are represented on horizontal, axis. It illustrates the data comparison

Page 2 :
between individual items., , 2. COLUMN CHART - In this type of chart,, categories are organised horizontally and, values vertically to emphasise the, magnitude of change over time., , 3. STACKED BAR CHART - Each bar in the, chart represents a whole, and segments in, the bar represent different parts or, categories of that whole., , 4. LINE CHART - It is in the form of lines, and used to illustrate trends in data at, equal intervals., , 5. AREA CHART - It emphasises the, magnitude i.e. volume of change over time., , 6. PIE CHART - A diagram consisting of a, circle divided into parts to show the size of

Page 3 :
particular parts in relation to the whole., , 7. DOUGHNUT CHART - A doughnut chart, shows the relationship of parts to a whole,, but a doughnut chart can contain more, than one data series. It displays data as, sections of a circle., , 8. XY CHART - XY (Scatter) charts plot two, groups of numbers as one series of XY, coordinates. XY charts show the, relatedness of two sets of data. XY charts, can have more than one series. It is best, suited for proportional nature of data., , STEPS TO DRAW A CHART, , e Select the data for which we want to, create a chart., , e Click INSERT > goto charts group. Click

Page 4 :
on any chart type and select chart, subtype. Chart appears on the, worksheet.