Behavior Chart Excel by raq19807


More Info
									                         How to make a basic graph using Excel

After opening Excel, you will see the workbook, which has letters on the top and numbers
along the left side.

Fill in numbers horizontally in each cell. (Data can be displayed vertically but try to do it the
same way because as you display more data-variables, all data must be on the correct axis in
order to be correctly displayed in a graph). Example row 5 and number from letter D through G
representing 5 days or week’s data. This may represent the number of times a child calls-out
during math.

Click on the picture of a multi-colored bar graph on the top toolbar. In this example choose a
line graph from the left side of the dialog box (bar graphs are also typically used to graph this
kind of data, especially the clustered one for 2 variables).

Typically you do not need to highlight the data for the graph when doing an initial graph using
the chart wizard, but if no data shows when you preview, go back and highlight data.

Step 1 Chart Type

Click on the 4th graph example, which should read line with marker displayed at each data value.
(If you want the program to automatically calculate a trendline after you have finished your
graph, any graph you choose must NOT be stacked.

Click on press and hold to view sample. This will let you preview how this type of graph will
display your data. If satisfied, click next or go back and choose another chart or adjust data on

Step 2- Chart Source Data

Click Series, in space for name, type in what the data represents (i.e. “callouts”) and series 1 will
change to that name, repeat for each series. OR in name type in name and click add on the left
side. One could also place the name of the data series on the workbook and include it in the
chart that way.

Repeat when you have more series of data and add. Click on anything you would like to delete
and click remove.

Step 4 – Chart Options

Tabs on top Title “ Bob’s Behavior Chart”, X-axis if weeks and Y is frequency.
Axes, usually don’t need to change. Gridlines changes if you want more of horizontal or vertical
lines. Legend is the placement of the legend. Data Label, click shows values if you want values
to show on chart on data points. Data Table will display all you data at bottom of graph if you
select show table. Click Next.

Last Step

Click on in as new sheet if you want graph on a new sheet and not in the workbook. The default
is as object in and the graph will appear in the workbook.

Click finish and your graph is done.

To have trend line calculated, right click on a line and a popup menu will include trend line.
Click trend line and it will automatically pop up. To change color, shape or width of any line or
data point, left click on whatever you want to change. The format data point or plot area. (To
change anything right click whatever you would like to change, gridline, background color, etc.,
this rule applies to all MS programs) To change name from linear to trend line, right click on
trend line, click options and custom and type trend line or desired name.

When the graph is viewed in the as new sheet screen, the tabs at the bottom of the workbook will
then show Chart 1 (where the chart in a new-separate sheet and not in the workbook. The
remaining tabs will be labeled sheet 1, sheet 2, etc. You can change the name of the chart or
sheet by double clicking on it and typing your preferred name/title.

Use the DRAWING items to add lines to represent goal and aim lines. Also text boxes can be
used to insert names and label items on your chart. WordArt and inserting clip art also adds
uniqueness to charts. If you do not have the drawing toolbars on your screen, go to VIEW on
your menu above your toolbar and click toolbars, click on drawing and check box. The drawing
toolbars should then be at the bottom of your screen. You will see Auto shapes, lines, arrows,
text boxes, clip art, fill color-color formatting items, shadows, 3-D, etc.

                                                                                Use your

     Go slow, and click Edit and undo to undo your last entry, especially when
      experimenting. Try to add 1-2 things to your skills each time you work.
   Right click on items to change, correct and find additional information on an


To top