Page 286 - open office
P. 286
The chart will be displayed in the sheet that can be Cut or Copied and Pasted in other locations.
Sneak Peek
To Make a chart in Microsoft Excel:
1. Select the data for which the chart is to be created.
2. Click on the Insert tab.
3. Click on any of the chart categories in the Charts group. A drop-down list of options of
different chart formats under that category will open.
4. Click on a chart format.
Recap Zone
Formatting a cell includes changing the contents of a cell with respect to appearance, i.e., Changing
text, Styles, Alignment, Font, Font style, Font size, Border, Patterns, etc.
The data present in the cell can be customized or formatted using the ‘Format Cells’ option.
Auto Fill is an additional feature in spreadsheet package like ‘Calc’ in which a certain kind of
pre-defined series of data such as name of months of a year, serial numbers, etc. are automatically
generated once the user feeds the initial data.
‘Calc’ also provides a feature to create a custom list where some series of names or text can be
pre-defined and then displayed when the initial data is entered and AutoFill is applied.
A chart is a visual graphical representation of data from a worksheet that is very useful for instant
analysis of data and decision-making.
286 Touchpad Information Technology-IX

