4.311 bytes

Service Hints & Tips

Document ID: MCGN-3FQMWD

PS/1-Aptiva - Using charts within Microsoft Works

Applicable to: United States

Question:
Can I define more than eight charts?

Answer:
No. Works allows the creation of up to eight charts for a single spreadsheet. If you attempt to create an additional chart, an error message is generated. You may either delete or redefine an existing chart. If you must create more than eight charts for a spreadsheet, you must copy the spreadsheet to a new spreadsheet.

A workaround follows:

1. Highlight the area of the spreadsheet on which the charts are based.

2. Select "Copy" from the Edit menu.

3. Select "New..." from the File menu, choose Spreadsheet and press [Enter].

4. When the new spreadsheet is opened, press [Enter] and the data from the original spreadsheet will appear in the new spreadsheet.

The original spreadsheet is not altered in any way. The copy is identical to the original except that it does not include any charts. You now have room to create up to eight more charts. If the original spreadsheet changes, recopy the data into the copy. The updated data will replace the data in the copied spreadsheet and the charts will reflect the new data.

Search Keywords

Hint Category

Productivity Software

Date Created

01-04-97

Last Updated

23-03-99

Revision Date

23-03-2000

Brand

IBM Aptiva

Product Family

Aptiva, PS/1

Machine Type

2011, 2121, 2123, 2133, 2155, 2168, 2144

Model

C01; C34; M01; NEA; T35; U35; A62; A82; A94; B82; C42; C92; G42; M82; S92; 081; 087; 131; 137; K37; N31; N81; 11E; 13T; 14C; 16E; 17A; 18A; 18T; 19C; 21C; 23C; 28A; 46M; 51D; D50; G11; G13; G43; G46; G46; G49; G49; G50; G53; M40; M40; M46; M46; P11; P13; P43; P50; P53; R04; R05; R06; R09; R38; R42; R43; R44; R84; R86; R87; RO3; S11; S13; S43; S45; S45; S47; S47; S48; S48; S50; S53; W11; W13; W42; W42; W43; W45; W45; W50; W53; 20E; 22T; 24C; 24M; 28V; 39E; 41T; 43C; 45V; 48E; 50T; 52C; 55V; 72E; 74T; 76C; 78C; 79C; 81A; 82E; 84T; 86C; 87C; CC1; D53; G14; G44; G52; G54; G72; G76; G78; G82; NM1; P14; P44; P57; P71; P74; P76; P78; P84; R14; R15; R16; R17; R18; R51; R52; R57; R58; R62; R63; R67; R71; R89; R93; R96; R97; S14; S44; S50; S54; S70; S75; S76; S78; S80; W14; W44; W48; W54; W67; W76; W77; W78; Z33; 28V; 31E; 33T; 37C; 38C; 51E; 54T; 56C; 57C; 88V; BB1; G57; G87; OR1; OR3; OR4; OR5; P89; R28; R29; R31; R74; R78; R82; R98; S55; S85; SR1; US1; W52; W82; 2R0; P30; 2R3; S15

TypeModel

Retain Tip (if applicable)

Reverse Doclinks
and Admin Purposes