Monday, 26 May 2014

Charts in Microsoft Excel 2007

 Microsoft Excel 2007 provides an easy and systematic way to represent text or numeric data in a tabular format. Microsoft Excel 2007 provides you another powerful and easy to tool, which present the data in the pictorial form called Charts. Charts help to compare and data in a more interesting, attractive and efficient manner as it is rightly said that “a picture is worth a thousand words”.
CHART TYPES
·       Column Chart
·       Bar Chart
·       Line Chart
·        Area Chart
·       Pie Chart
·       XY (Scatter) Chart
·       Doughnut Chart
·       Radar Chart
CHART COMPONENTS
·       Chart Title
·       X-axis or Categories Axis

·       Y-axis or Value Axis
·       Data Series
·       Legends
·       Grid lines
·       Plot Area
·       Chart Area
·       Data Labels
·       Axis Titles
CHANGING THE CHART LOCATION
Ø Select the chart whose location is to be changed.
Ø Click on design tab under the chart tools.
Ø Click OK button to move the chart.
·       X-axis or Categories Axis

·       Y-axis or Value Axis

No comments:

Post a Comment