

When the data is in one place, the Chart Wizard can guess the range and create an initial chart even if all of the data is not selected. In this example, it may be best to select the cell range A2:D8, which will intentionally omit the overall title “Equipment Rentals” from the chart. The selection can be a single block, individual cells, or groups of cells (columns or rows). Here is an overview of the basic steps:ġ) Select the cells containing all of the data-including names, categories, and labels-to be included in the chart. To demonstrate the process of using the Chart Wizard to create charts, the data shown in Figure 1 is used in the following sections. Overview of Chart Wizardįigure 1: Example data for creating a chart Each change is immediately seen in the underlying chart. Then use the Chart Wizard options to change the type of chart, adjust data ranges, and edit some chart elements. Use the Chart Wizard to create an initial chart using data in a spreadsheet. Tufte ’s The Visual Display of Quantitative Information, 2nd edition, Graphics Press (2001). Cleveland’s The Elements of Graphing Data, 2nd edition, Hobart Press (1994) and Edward R. They can be customized to a considerable extent, enabling information to be shown in the clearest manner.įor readers interested in effective ways to present information graphically, two excellent introductions to the topic are William S. For a more detailed list, see the application Help and Appendix A (Keyboard Shortcuts) to this guide.Ĭontrol+click and/or right-click depending on computer setupĬharts and graphs can be powerful tools for conveying information and Calc offers a variety of ways to present data. The table below gives some common substitutions for the instructions in this book. Some keystrokes and menu items are different on macOS from those used in Windows and Linux.

Other versions of LibreOffice may differ in appearance and functionality. Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: you send to a mailing list, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. You may distribute it and/or modify it under the terms of either the GNU General Public License ( ), version 3 or later, or the Creative Commons Attribution License ( ), version 4.0 or later.Īll trademarks within this guide belong to their legitimate owners. This document is Copyright © 2021 by the LibreOffice Documentation Team.
