Making Charts in Appleworks

This How To ... will lead you through the process of inserting a chart into your AppleWorks document. The steps you will need to take are:

• Create a word processing document
• Create a spreadsheet inside the word processing document
• Create a chart from your spreadsheet data

Create a Word Processing Document

Open AppleWorks

Create a new document of the type Word Processing

Type in any text you want

Create a Spreadsheet

Inside your word processing document, create a table using a spreadsheet frame
The easiest way to create and edit a table in a word processing document is by using a spreadsheet frame. In a spreadsheet frame, you can use spreadsheet commands to move table entries around, sort entries alphabetically, add blank rows or columns to insert new entries, and format the table.
When you finish your table, you can paste it into an empty line in a word processing document or text frame so that it moves like other text when you add or delete text ahead of it. You can still resize, delete, or edit the text in the pasted table.

Tip Use the Make Table Assistant to have AppleWorks step you through the process of making a table. Unfortunately it only makes an address book spreadsheet.

.
To create a table using a spreadsheet frame:
1. If you don't see the tool panel, choose Show Tools from the Window menu.
2. Select the spreadsheet tool [it looks like the Red Cross symbol] and drag the pointer to create a frame.
3. Click a cell in the spreadsheet and type your table entries. Press Tab or Return to go to the next cell.
4. Format your table.

• To change the appearance of the text: Select the text and choose attributes from the Font, Size, Style, Text Color, and Alignment submenus in the Format menu.
• To add a color and pattern to cells : Select the cells and choose a color from the fill color palette and a pattern from the fill pattern palette.
• To add a border to cells: Select the cells, choose Borders from the Format menu, and select the border options you want. To change the border color, select the bordered cells and choose a color from the pen color palette.
• To change the size of columns or rows: Select a column and choose Column Width from the Format menu, or select a row and choose Row Height from the Format menu.
• To wrap text in cells: Select the text, choose Alignment from the Format menu, and then choose Wrap. If necessary, resize the row.
• To hide column or row headings, hide the spreadsheet grid, or display solid gridlines: Select the frame, choose Frame Info from the Edit menu, and select the options you want.
  

Create a chart

You can create a chart from all the data in your spreadsheet or from a selected range of cells.
To create a chart:
1. Select the data you want to include in the chart.
2. Choose Make Chart from the Options menu.
3. In the Chart Options dialog box, click the type of chart you want to create.
4. Set other chart options.
Click the buttons in the Modify area to display other groups of chart options.

Click on

• Gallery Change chart types and options, such as color and shadow
• Axes Enter labels for the X axis and Y axis, set the scale and format of tick marks, and determine if gridlines appear on the chart
• Series Determine how the chart displays and labels data series
• Labels Enter a chart title and control the way the title and legend appears
• General Determine how ClarisWorks constructs the chart from the spreadsheet, including the cell range, whether the data series come from rows or columns, and whether the first row and column contain numbers as labels

If you're not sure what you want your chart to look like, you can skip this step and ClarisWorks will automatically select the options it considers best based on your selected data. You can modify the chart later if you want to.
5. Click OK.
ClarisWorks creates the chart.

Basic chart types
When you create or modify a chart, you can select from a variety of chart types. The chart you select depends on the type of data you're presenting and the message you want to convey. For example, opening and closing stock quotes are almost always best suited to a hi-low chart. But sales figures might be best presented in several ways. If you want to show which regions produced the most sales, a bar chart is best. If you want to emphasize what percentage of total sales each region contributed, a series of pie charts or a stacked bar or stacked area chart may be best.

Chart type characteristics

• Bar charts Each value in a data series is represented by a bar. Each bar in the series is the same color or pattern. You can also create stacked bar charts.
• Line charts Each value in a data series is plotted as a point, and the points are connected by a line. You can also create X-Y line charts.
• Area charts Each data series is plotted as a line, and the area below the line is shaded. You can also create stacked area charts.
• Scatter charts, X-Y scatter charts Each value in a data series is plotted as a single point. Each point in the series is the same color.
• Pie charts Each value in a data series is shown as a percentage of a whole (a single slice in the pie). If you plot more than one division of data, ClarisWorks creates a separate pie for each division.
• Stacked area charts, Stacked bar charts, Stacked pictogram charts Each data series in a division is plotted as a cumulative total. For example, if there are three data series whose values for the first division are 10, 25, and 5, the first data point in the division is plotted as 10, the second as 35 (the sum of the first two values), and the third as 40 (the sum of all three values).
• X-Y line charts Each data point is plotted using a pair of values from adjacent columns or rows in the spreadsheet. You can also create X-Y scatter charts.
• Hi-low charts A pair of values from adjacent columns or rows are plotted as separate points, and a line connects the two points.
• Pictogram charts A pictogram is a bar chart with pictures in the bars. You can also create stacked pictogram charts.
  

Using the same data I changed the axis (Chart Options, General, series in rows)

Tip You can double-click the chart to open the Chart Options dialog box.

The chart option dialog box lets you change axes, axis labels, titles, etc.

Add a 3-dimensional effect
You can add a 3-dimensional effect to bar, stacked bar, pictogram, and stacked pictogram charts.

1. Select the chart and choose Chart Info from the Edit menu.
2. In the Gallery area of the Chart Options dialog box, select 3-Dimensional.
3. Click OK.
You can change the lines around the bars by selecting a series box in the legend and using the pen palettes.

Paste a table into text

If you have created the spreadsheet in a separate document you can paste it into a word processing document.

1. Select the spreadsheet frame and choose Cut or Copy from the Edit menu.
2. Click the spot in your text where you want to put the table.
It's best to paste the table on a blank line. Press Return to create a new line.
3. Choose Paste from the Edit menu.
The large insertion point blinking next to the pasted table indicates that the table is part of the paragraph.
4. Use the alignment controls and the indent markers on the text ruler to position the table.
Tip You can open a spreadsheet frame to see and work with all the cells in the frame.

This How To... is based almost entirely on the on the Help section in AppleWorks.

MVRHS 12/13/1999