CP Lab – Experiment 7

EXPERIMENT NO 7

Aim:  Creating charts in excel

Objectives: Analyze spreadsheet data and demonstrate use of different charts  

Hardware requirements: Any CPU with Pentium Processor or similar, 256 MB RAM or more, 1 GB Hard Disk or more.

Software requirements:  Windows 64 bit / Ubuntu 14 Operating System, MS office 2010 or later, Open Office for Ubuntu

Theory:

Creating Charts:

  1. To create a chart, select the data you want to summarize visually and then, on the Insert tab, in the Charts group, click the type of chart you want to create to have Excel display the available chart subtypes.
  2. When you click a chart subtype, Excel creates the chart by using the default layout and color scheme defined in your workbook’s theme.
  3. If Excel doesn’t plot your data the way you want it to, you can change the axis on which Excel plots a data column. The most common reason for incorrect data plotting is that the column to be plotted on the horizontal axis contains numerical data instead of textual data.
  4. You can change which data Excel applies to the vertical axis (also known as the y-axis) and the horizontal axis (also known as the x-axis).
  5. To make that change, select the chart and then, on the Design tab, in the Data group, click Select Data to display the Select Data Source dialog box.
  6. To remove a column from an axis, select the column’s name, and then click Remove. To add the column to the Horizontal (Category) Axis.
  7. In Labels pane, click that pane’s Edit button to display the Axis Labels dialog box.
  8. To resize a chart, select the chart, and then drag one of the handles on the chart’s edges.
  9. To move the chart to a new chart sheet, select the New Sheet option and type the new sheet’s name in the accompanying field.
  10. Selecting the New Sheet option creates a chart sheet that contains only your chart.
  11. To move the chart to an existing worksheet, select the Object In option and then, in the Object In list, click the worksheet to which you want to move the chart.
  12. If you want to change a chart’s appearance, select the chart and then, on the Design tab, click a style in the Chart Styles gallery.
  13. To change the chart element’s format, use the tools and dialog box launchers in the Format tab’s Shape Styles, Word Art Styles, Arrange, and Size groups to change the element’s appearance.

Chart as Chart Template:

  1. To save a chart as a chart template, select the chart you want to use as a template and then, on the Design tab, in the Type group, click Save Template.
  2. Use the controls in the dialog box that appears to name and save your template.
  3. Then, to create a chart based on that template, select the data you want to summarize and then, on the Insert tab, in the Charts group, click any chart type, and then click All Chart Types to display the Create Charts dialog box. Under Choose A Chart Type, click Templates, and then click the template you want to use.

Trendlines:

  1. With the Trendline Options page of the Format Trendline dialog box, you can choose the data distribution that Excel should expect when it makes its projection.
  2. The right choice for most business data is Linear—the other distributions (such as Exponential, Logarithmic, and Polynomial) are used for scientific and operations research applications.
  3. As with other chart elements, you can double-click the trendline to open a formatting dialog box and change the line’s appearance

 Summarizing Your Data by Using Sparklines: You can use sparklines, to create compact, informative charts that provide valuable context for your data. a sparkline occupies a single cell, which makes it ideal for use in summary worksheets. You can create three types of sparklines: line, column, and win/loss. The line and column. Sparklines are compact versions of the standard line and column charts. The win/loss sparkline indicates whether a cell value is positive (a win), negative (a loss), or zero (a tie).

  1. To create a line sparkline, you select the data you want to summarize and then, on the Insert tab, in the Sparklines group, click the Line button.
  2. To create a line sparkline, you select the data you want to summarize and then, on the Insert tab, in the Sparklines group, click the Line button.

Conclusion: In this experiment, we have studied various types of charts and their use in data representation in graphical format.

R.No Name of Student Date of Performance Date of Evaluation Grade Sign of student Sign of Faculty
             

Reference Book:  Microsoft Excel 2010 – Step by Step

Leave a Reply

Your email address will not be published. Required fields are marked *