Chart is a graphical representation of data stored in excel sheet. It is always easy for us to read, understand and analyse the data when the data is presented in graphical manner than text and numbers. This is true since our minds fond of colors and symbols rather than text and numbers.
Excel 2007 allows us to create various types of charts based on the data selected. The creation, modification of charts is very easy in Excel.
The various types of charts available in Excel 2007 are:
- Column chart
- Line chart
- Pie chart
- Bar Chart
- Area Chart
- Scatter Chart
Representing Data as Chart (or) Creating a Chart:
- Select a cell or the range of cells for which chart is to be prepared.
- Insert tab–>Chart group–>Click on your desired Chart Model button
(or)
Alt+F1 (default Chart model i.e. column Chart will appear)
Insert chart in the same sheet: alt+F1
Insert Chart as separate sheet: F11
Once chart is inserted anywhere (either in the same sheet or separate sheet) and selected then three additional contextual tabs will be appear Design, Layout and Format.
Design Tab provides options to change the chart model, chart data and chart layout
Layout Tab provides options to add, modify or remove various chart elements or components
Format Tab provides options to format different Chart Elements.
Chart Elements are:
Chart Title
Chart Area
Plot Area
Axis Title
Legend
Grid Lines