Chapter 9. Creating Advanced Spreadsheets

IN THIS CHAPTER:

67 Add a Chart to a Spreadsheet

68 Insert Graphics into a Spreadsheet

69 Protect Spreadsheet Data

70 Combine Multiple Cells into One

71 Ensure Valid Data Entry

72 Import and Export Sheet Data

73 About Advanced Spreadsheet Printing

A picture is worth a thousand words—and worth even more numbers! Your spreadsheet data might contain a ton of numbers, but many times you can present data better with a chart or graphic. The actual raw data supplied by a worksheet is accurate and vital information for analysis, but for trends and overall patterns, charts demonstrate the data's nature quickly and effectively. After you create and format your worksheets, use Calc to quickly create a chart that depicts your data graphically. After Calc generates the chart, you then can customize the chart to look exactly the way you want.