Charts, Types of Chart, Column Charts, Line Charts, Pie Charts, Bar Charts, Moving the Chart

Doorsteptutor material for IMO-Level-2 Class-7 is prepared by world's top subject experts: fully solved questions with step-by-step explanation- practice your way to success.

Download PDF of This Page (Size: 168K)

Charts

Charts allow you to present data entered into the worksheet in a visual format using a variety of graph types. Before you can make a chart, you must first enter data into a worksheet. This section explains how you can create simple charts from the data

Types of Chart

  • Microsoft Office Excel 2007 provides various types of charts to help you to display data in different ways as per the need of the viewers.

  • You can create a new chart or can change the existing chart, from the wide range of chart subtypes available for each type of available chart types as given below

Column Charts

This type of chart is used to compare values across categories. They give very effective results to analyze the data of the same category on a defined scale.

Line Charts

  • Data represented in columns or rows in a worksheet can be plotted with the help of line chart.

  • Line charts can be used to display continuous data over time with respect to a common scale.

  • Thus, Line Charts are best suitable for viewing data trends at equal intervals of time.

  • The horizontal axis is used to represent the category data and all the value data is distributed uniformly along the vertical axis.

Pie Charts

Pie charts

Pie Charts

  • In a situation where one has to show the relative proportions or contributions to a whole, a pie chart is very useful. In case of pie chart only one data series is used. Small number of data points adds more to the effectiveness of pie charts.

  • Generally, there should be maximum five or six data points or slices in a pie chart. If the points are more in number, then it becomes very difficult to interpret the chart.

Bar Charts

Bar charts are used to show comparisons between individual items. To make a bar chart the data should be arranged in the form of rows and columns on a worksheet.

Area Charts

The data which is arranged in the form of rows or columns on a worksheet can be plotted in an area chart.

XY (Scatter) Charts

XY charts are also known by other names like scatter grams or scatter plots. The point of difference between XY charts and other types of charts is that in XY charts both axes display values i.e. they have no category axis. Such type of charts is generally used to show the relationship among two variables.

Stock Charts

  • Stock chart can be used to plot data arranged in columns or rows in a particular order on a worksheet.

  • As the name is self-explanatory, this chart is used to demonstrate the fluctuations with respect to stock market prices.

  • Even scientific data can be plotted by stock chart, e.g., the fluctuation of daily or periodic temperature. The data must be arranged in a correct order to generate stock charts.

Surface Charts

Such type of chart is used in situations where both categories and data series are numeric values. This type of chart is useful in situations where the optimum combinations are found among the two sets of data.

Doughnut Charts

The conditions to draw doughnut charts are that the data has to be in the form of rows or columns. As in the case of a pie chart, the doughnut chart illustrates the relationship of parts to a whole, but it is able to get more than one data series.

Bubble Charts

A bubble chart can be used to plot the data values which are arranged in the columns of a worksheet so that x values are listed in the first column and matching y values and bubble size values are listed in adjacent columns.

Radar Charts

The radar charts compare the aggregate values of a number of data series. Radar chart can be plotted with the data which is arranged in columns or rows on a worksheet.

Components of a Chart

  • Chart Title - A title given to the whole chart.

  • X-Axis Title - A title given to the X-axis data range.

  • Y-Axis Title - A title given to the Y-axis data range.

  • X-Axis Category - These are the categories of the data which have been plotted. These are taken from the first column or first row of your data range.

  • Y-Axis Value - This is the data range marked to plot the data series.

  • Data Labels - The values of the data series plotted.

  • Legends - Specifies the color, symbol or pattern used to mark data series.

  • Tick Mark - These marks are used to show the scaling of X-axis and Y-axis.

  • Grid Lines - Displays lines at the major intervals on the category X-axis and/or Y-axis

How to Draw a Chart in Excel 2007

  • In Microsoft Excel 2007 chart wizard is removed and also not brought back in Excel 2010 also. Instead the ribbon is provided as a new place to get your chart related needs full filled. The buttons on the Insert tab of the ribbon are just the starting point to make a chart. After we get the ribbon it becomes very simple to start making a chart. Whenever we click on some component of chart, we observe that the Chart Tools are displayed to the ribbon. Three additional tabs which provide a variety of chart design, layout and formatting options, will also be added.

  • First, the Layout tab is used to add all sorts of elements related to chart or change the way they are shown in the chart. Second, the format tab is used to apply special effects which were not available in the earlier versions of the Excel, such as the bevel effect etc. It may be little difficult to be acquainted with this new type of chart interface, but once you start working, you’ll be proud to show off your professional looking results.

  • It is worth mentioning that you can right click on an element of the chart for quick access to specific features with respect to that particular element e.g. if you right click on any chart axis, you will get Format Axis dialog box.

Following steps are given to draw a Chart

  • Enter data in the work sheet:

  • Now select data range: By using the mouse high light the range of data you want to take.

  • Click Insert Tab and select a chart type from the chart group

  • Select the sub type of chart

  • Select the Title of the chart

    • To give a title to a chart, click on the chart. Now you can see layout tab available. Click on Layout tab.

    • Choose(click) on chart title option available in the Label group

    • Click on the chart title and write a title.

  • Give a name to X-Axis

  • Click on Layout tab. Then select Axis Titles from Labels Group. Select Primary Horizontal Axis Title, as shown below.

  • Now, click on the Axis Title and write an X-axis title.

  • Follow the same steps to give a title to Y-axis.

Editing of a Chart

How to Change the Legend Position

  • Click on Layout tab. Then click on Legend option available in Labels Group.

  • Now choose a position to show legend.

How to Change the Position of the Data Labels

  • Click on Layout tab. Then click on Data Label option available in Labels Group.

  • Now choose a format to display data labels

How to Show Data Tables Along with Chart, with or Without Legend Keys

  • Click on Layout tab. Then click on Data Table option available in Labels Group.

  • Now choose a style to display data table. Above diagram show the data table with legend option.

How to Hide/Unhide Grid Lines (Horizontal and Vertical)

  • Click on Layout tab. In the Axis Group, click on Gridlines option then choose Primary Horizontal Grid Lines. Now select appropriate style from the available options (None, Major Gridlines, Minor Gridline, Major and Minor Gridlines)

  • No Horizontal Major

  • Follow the same steps for Vertical Grid Lines also, as shown below.

  • Click on Layout tab. In the Axis Group, click on Gridlines option then choose Primary Vertical Grid Lines

  • Now select appropriate style from the available options (None, Major Gridlines, Minor Gridline, Major and Minor Gridlines)

  • Vertical Grid lines for Major Units are added

Resizing the Chart

To resize the chart, click on its border and drag any of the eight black handles to change the size. Handles on the corners will resize the chart proportionally while handles along the lines will stretch the chart.

Moving the Chart

Select the border of the chart, hold down the left mouse button, and drag the chart to a new location. Elements within the chart such as the title and labels may also be moved within the chart. Click on the element to activate it, and use the mouse to drag the element to move it.

Copying the Chart to Microsoft Word

A finished chart can be copied into a Microsoft Word document or power point slide. Select the chart and click Copy. Open the destination document in Word or a slide in power point and click Paste.

Developed by: