Page 126 - FUNDAMENTALS OF COMPUTER

NPP

126 Fundamentals of Computers NPP

Data Series: The group of the data points S>mQ>m grarO: erQ> S>mQ>m go CËnÝZ S>mQ>m nm°B§Q²>g Ho$
generated from the sheet data is called a data g_yh H$mo S>mQ>m grarO `m Ho$db grarO H$hVo h¢& CXmhaU
series or simply Series. For example, there are
two series in fig-2.51; California and United Ho$ {cE, {MÌ-2.51 _| Xmo grarO; H¡${c\$mo{Z©`m Ed§ `yZmBQ>oS>
States. ñQ>oQ²>g h¢&
Gridlines: These are the horizontal and {J«S>cmBÝg: MmQ>© _| {d{^ÝZ nm°B§Q²>g Ho$ ~rM B§Q>a
vertical lines in the plot area to indicate the H$ZoŠeZ Xem©Zo hoVw ßcm°Q> E[a`m _| hmo[aOm|Q>c Ed§ d{Q>©H$c
interconnection between different points in the cmBÝg h¢&
chart.
Category Axis (X): This axis is normally H¡$Q>oJar EpŠgg (X): `h EpŠgg Zm°_©cr hmoarOm|Q>c
horizontal and used to categorize data on the hmoVr h¡ Omo Q>mB_, _mh Am{X _mZH$ AmYma na S>mQ>m dJuH$aU
basis of some parameter like time, month etc. Ho$ Cn`moJ _| AmVr h¡& {MÌ-2.51 ‘| H¡$Q>oJar Ep³gg H$m
In fig-2.51, the category axis uses 'year' for
categorization. Cn¶moJ 'df©' dJuH¥$V H$aZo ‘| hþAm h¡&

Value Axis (Y): This axis is normally d¡ë`y EpŠgg (dm`): `h EpŠgg Zm°_©cr d{Q>©H$c
vertical and used to shows values. Ed§ d¡ë`y àXe©Z _| Cn`moJr hmoVr h¡&
Data Labels: Data labels show the values S>mQ>m co~ëg: S>mQ>m co~ëg MmQ>© _| nm°B§Q²>g `m H$m°cåg
of the points or columns in the chart.
H$s d¡ë`y àX{e©V H$aVo h¢&
Legend: It is a color-coded key correspon- crO¢S>: `h grarO `m H¡$Q>oJar Ho$ gmnoj H$ba H$moS>oS>
ding to a Series or Category. Hw§$Or hmoVr h¡&
Title: The text describing the chart is the Q>mBQ>c: eãXm| H$m {ddaU MmQ>© H$m Q>mBQ>c hmoVm h¡&
title. By default it is displayed at centre but can {S>\$m°ëQ> go `h g|Q>a _| {XIVm h¡, na§Vw Bgo AÝ` ñWmZm|
be placed at other places also.
na ^r aIm Om gH$Vm h¡&
Plot area: The area enclosed by axes which ßcm°Q> E[a`m: EpŠgg go g§c½Z E[a`m {Og_| S>mQ>m
contains the data series.
grarO em{_c hmoVr h¡&
Chart Area: It is larger than the plot area MmQ>© E[a`m: `h ßcm°Q> E[a`m go A{YH$ hmoVm h¡,
which contains all the elements of a chart. {Og_| MmQ>© Ho$ g^r Ad¶d hmoVo h¢&
Data Source: The selected cells of the excel S>mQ>m gmog©: EŠgoc erQ> Ho$ {gcoŠQ>oS> goëg {Og_|
sheet which contains the data for the chart is gmog© S>mQ>m MmQ>© hoVw em{_c ahVm h¡&
the data source.

Chart Tools MmQ>© Qy>ëg
When we insert a chart in a sheet, a 'Chart O~ h_ erQ> _| MmQ>© B§gQ>© H$a|Jo VrZ Q>¡ãg H$m
Tools' which is combination of three tabs; H$m°på~ZoeZ 'MmQ>© Qy>ëg'; [a~Z Ho$ D$na àX{e©V hmoVm h¡&
Design, Layout, and Format, appears above the
ribbon. Whenever we remove the chart from ¶o Q>o~ {S>OmBZ, coAmCQ> VWm \$m°_}Q> h¢& O~ h_ erQ> go
the sheet, Chart Tools disappear. The 'Chart MmQ>© [a_yd H$a|Jo, MmQ>© Qy>ëg ^r AÑí` hmo OmE§Jo& MmQ>©
Tools' is depicted in fig-2.52. Qy>ëg H$mo {MÌ-2.52 _| {XIm`m J`m h¡&