Mohsin Web
Assalam-o-Alikum!
You are Unregistered, please Login Or Register to gain Full access.
Note: If You Want To Visit Us As Guest Then Click On Do Not Display Again

Join the forum, it's quick and easy

Mohsin Web
Assalam-o-Alikum!
You are Unregistered, please Login Or Register to gain Full access.
Note: If You Want To Visit Us As Guest Then Click On Do Not Display Again
Mohsin Web
Would you like to react to this message? Create an account in a few clicks or log in to continue.

-----Charts-----

Go down

-----Charts----- Empty -----Charts-----

Post by Admin Sat Jun 20, 2009 11:05 am

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 page explains
how you can create simple charts from the data.

Chart Wizard -----Charts----- Chartwizard
The Chart Wizard brings you through the process of creating a
chart by displaying a series of dialog boxes.

  1. Enter the data into the worksheet and highlight all the cells
    that will be included in the chart including headers.
    -----Charts----- Chartwizard1
  2. Click the Chart Wizard button on the standard toolbar to view
    the first Chart Wizard dialog box.
  3. Chart Type - Choose the Chart type and the Chart
    subtype
    if necessary. Click Next.
    -----Charts----- Chartwizard2
  4. Chart Source Data - Select the data range (if different
    from the area highlighted in step 1) and click Next.
    -----Charts----- Chartwizard3
  5. Chart Options - 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. Press Next to move to the next set of options.
    -----Charts----- Chartwizard4
  6. Chart Location - Click As new sheet if the chart
    should be placed on a new, blank 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.
    -----Charts----- Chartwizard5
  7. Click Finish to create the chart.
    -----Charts----- Chartwizard6


Resizing the Chart
To resize the chart, click on its border and drag any of the nine
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.

Chart Formatting Toolbar

-----Charts----- Charttoolbar

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 Toggle - Show or hide the chart legend by clicking
this toggle button.
Data Table view - Display the data table instead of the
chart by clicking the Data Table toggle 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.
-----Charts----- Chartangle


Copying the Chart to Microsoft Word

A finished chart can be copied into a Microsoft Word
document. Select the chart and click Copy. Open the destination
document in Word and click Paste.
Admin
Admin
Administrator
Administrator

Posts : 136
Age : 29
Location : http://mohsin.pagespk.com/

http://mohsin.pagespk.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum