Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Systems Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

On This Page

[Help]

  

Quick Links

Top Level

Related Links

Ask OLC a question

Athena Consulting Homepage

Helpdesk Stock Answers (for Mac/PC questions)


How to specify DATA SETS for graphs

There are two possible methods for specifying the data sets in a graph:

1. Specifying the ranges before setting up the new graph.

    First select (highlight) a range of data to be graphed.  Next, choose
    New Graph from the Graph menu.  Inside the New Graph sub-menu select
    the desired graph type.  A new window named Untitled will be created
    with your graph.  You can then edit the data ranges (as described in
    the second method of creating a graph) or change any of the general
    graph characteristics.

2. Specifying the ranges having set up the new graph.

    After you have initially created a graph using the New option from
    the Graph menu, you can set data sets by selecting Data Sets
    from the Edit menu.  When the Data Sets Options dialog box appears
    you will see the Data Set # specified at the top left hand corner,
    with a drag bar below it.  This drag bar let you move between
    data sets.  To specify a range, click in the appropriate X, Y
    or Z range box and enter the range. You may define up to twenty
    (20) separate data sets for each axis.You can enter the range by
    highlighting the range in the worksheet, or entering the first and
    last cell address separated like: A1..A15. Repeat this for each
    data set. You can further customize how the data is represented in
    the graph by changing the options within the Data Sets Options
    dialog box. The initial values displayed in this dialog box are
    based on the type of graph you selected from the New Graph option
    menu or in the Graph Options dialog box.

    The Data Set Options dialog box lets you alter the following:

                o Graph data ranges
                o Hi/Lo Data
                o Annotation
                o Segment type
                o Histogram option
                o Shading
                o Line style, width, color
                o Marker type
                o Fill style
                o Fill color
                o Legend text, font, size, style, color

    Click OK to accept the changes and dismiss the dialog box; click
    Apply to accept changes and retain the dialog box. (If Defer
    Redraw in the general Graph Options menu is OFF, the effects are
    immediately reflected in the corresponding graph edit window; if
    Defer Redraw is ON, you must explicitly invoke Redraw from the
    File menu to update the graph.)  Click Cancel if you wish to
    dismiss the dialog box.

    For more information on how to specify data sets select the "Data
    Sets Dialog" option from the Help "Index" menu.

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.