Microsoft Works for Windows Spreadsheet Instructions

How Do I:
Make a chart or graph?
Edit a chart or graph?

How to Make a Chart or Graph

  1. In the spreadsheet, highlight all cells you wish to graph (this includes labels and values).

  1. On the menu click Tools and select Create New Chart.

  1. Choose the Chart type that you wish to make.



  2. Click under the word Title and type a title for your chart.

     
  3. Click Ok.
  4. Look to make sure that the graph represents the data well

To choose another chart type, on the menu, click Format and select Chart Type. If you choose a type that does not show a preview, that type is not available for the selected data and settings. To select the new type, click OK.  To go back, use Edit - Undo or just re-choose the original chart type.

Below is a portion of the graph from the data in step 1 above.  Notice the blank column to the left of Hamburger and notice that the quantity (red) is too small to show.

  1. To eliminate the first blank column, on the menu go to Edit - Series . Since the data in the spreadsheet begins in row 5, change the beginning of the range to C5, D5 and A5 as noted below.  To eliminate the Quantity Label, delete the range in the 1st series.
  1. To edit the chart title or bars, double click on one of the bars or on the title.
  2. To edit the label font, double click on the labels.  The actual words must be changed within the spreadsheet.
  3. To go from the chart to the spreadsheet and back, on the menu, go to View - Chart or Spreadsheet 
  4. To view in grayscale, on the menu, go to View - Display As Printed.  This is useful if you will be printing on a non-color printer and need to preview it.

Below is an edited version of the chart above.

<< Previous  

Table of Contents 

Next >>

Last edited 6/4/01