Preparing Spreadsheets for Charts
Actually, creating and inserting a chart onto a Calc sheet is a fairly straightforward process. Most of the chart's creation is actually handled by the AutoFormat Chart Wizard. You should, however, try to design your spreadsheet itself so that the chart creation and placement process can proceed without a hitch. Here are some points to keep in mind as you create a spreadsheet that will include a chart:
Arrange the data in a consistent manner, either horizontally in rows or vertically in columns. Also avoid empty cells, rows, or columns within the data areas. You want a consistent block of data that includes the descriptive text related to the data itself.
Use row or column headings that are descriptive but short. ...
Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
