Home Know Me Snaps Feedback
 
::Online Microsoft Office,Web ,Graphic and many more Tutorials
Creating Chart : :

A chart is a graphical representation of worksheet data. It helps to analyze data and compare different worksheet values. A chart can be created in a separate chart sheet or embedded graphic object in a worksheet. Both embedded and chart sheets are linked to worksheet data. They are updated when the worksheet data changes. Before you can make a chart you must first enter data into a worksheet.

  • Enter the data into the worksheet and highlight all the cells
  • Go to Insert menu and click Chart, Or click ChartWizard button on Stander toolbar .
  • Choose the the appropriate chart type Form chart type box
  • Choose the the appropriate Sub chart- type Form sub chart- type box if necessary.
    (To preview your information in any chart before you create it,click Press and Hold to View Sample)
  • Click Next button
  • Chart Source Data dialog box appears, Select the data range (if different from the area highlighted in step 1) and click Next.
  • Chart Options dialog box appears, Enter the name of the chart and titles for the X- and Y-axes. Other options for the axes, grid lines, legend, data labels, and data table can be changed by clicking on the tabs.
  • Click Next button
  • Chart Location dialgo box appears, Click As new sheet if the chart should be placed on a new worksheet or select As object in if the chart should be embedded in an existing sheet and select the worksheet from the drop-down menu.
  • At last Click Finished

    Chart Formatting Toolbar
    ( Click the chart object, if the chart toolbar not show then Go to VIew Menu>>click toolbar>>Chart
    Chart Objects List -

    To select an object on the chart to format, click the object on the chart or select the object from the Chart Objects List and click the Format button. A window containing the properties of that object will then appear to make formatting changes.

Chart Type - Click the arrowhead on the chart type button to select a different type of chart.

Legend -
A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.Show or hide the chart legend by clicking this Legend button

Data Table view -
Display the data table instead of the chart by clicking the Data Table button.

Display Data by Column or Row -
Charts the data by columns or rows according to the data sheet.

Angle Text -
Select the category or value axis and click the Angle Downward or Angle Upward button to angle the the selected by +/- 45 degrees.

 
   Table of Content
Formatting Cells
Charts
Formulas and Operater
Function
 
       
   
© 2008, krishnakumar.com.np. All rights reserved
.