Formatting Data and Charts
In Excel, there are several aspects of formatting, number formatting, data and time formatting and text formatting. Numbers are formatted to change their appearance. Formatting does not affect actual cell value. Only the appearance changes, the number behind appearance remains as it is. Date and time are formatted to change their appearance. Formatting does not affect the actual date or time, only the appearance date and time changes. Text is formatted to change its appearance. Formatting does not affect the actual text, only the appearance changes.
In Excel, chart is an effective way to display the data in a pictorial form. Charts help to draw comparisons and analysis of Information. The various components of a chart are Chart title, Y-axis title, Y-axis, X-axis title, X-axis, Chart Area, Plot Area, Legends, Data Series and Gridlines. To create a chart in Excel, arrange the data in the worksheet. Select the cells which contain data. On the Insert tab, from the menu list, choose the chart in Chart type category. The chart is created and displayed on the worksheet. Some of the most commonly used charts in Excel are Column Chart, Bar Chart, Line chart and Pie chart. Legend is a key that is used to identify the colour, patterns or symbols assigned to data series. Data Series are the bars or slices that show data values.