Whole document tree Chapter 17. Graphs17.1. Graphing in GnumericGnumeric can create graphs with data in a worksheet. To do this, you need a modern version of Guppi (>= 0.40.0 ) installed that has Gnumeric support built in. With Guppi support, you should see a new icon that looks like a graph, next to the Sort Down button in the toolbar. That is the Graph button. Gnumeric can make the following graph types:
17.1.1. Creating a Basic GraphCreating a basic graph is a relativly straight forward process.
17.1.2. Advanced GraphingIn no way does graphing in Gnumeric stop with a simple graph. In the graphs you make, you can customize it. For example, you can say which cells define the ranges or labels. If a label for a field is in paraenthesis, it means that field is optional. 17.1.2.1. Selecting Data RangesIn the second step of the graphing assistant, you'll find you can customize the ranges which are taken into account for drawing the graph. At the top of the window is a preview of the graph. Below that are your settings. When you change a setting, the sample graph will change automatically to reflect your customizations. 17.1.2.1.1. PlotA graph is made up of plots. Currently, Gnumeric can only generate one graph from a spreadsheet. However, you can import an Excel spreadsheet to use multiple plots. You can customize the data ranges of each plot. 17.1.2.1.2. SeriesA Section 17.1.2.1.1 is made up of a group of series. A series is each item that is to be graphed. You can customize the ranges for every series included in your graph.17.1.2.1.3. Name Data RangeThe Name field defines what the name of each series is. This is reflected in the legend. Per the Example 17-1, the name for the first series would be in. The Name field takes a simple reference. The reference field needs what sheet and cell the information is stored on. For more information on references, please consult Section 6.3. 17.1.2.1.4. Values Data RangeThe Values field defines which data should be included in the graph. The Values field takes two arguements. The reference requires the sheet name and cell range the information is located on. For more information on references, please consult Section 6.3. 17.1.2.1.5. Category Labels Data RangeThe Category Labels field sets what cells are used to derive the labels on the x-axis. The Category Labels takes a simple reference. The reference needs the sheet name and cell ranges that the information is on. For more information on references, please consult Section 6.3. 17.1.2.2. Customizing Graph LayoutThe graph layout can be customized using the third step of the graphing assistant. At this time, only the legend position can be edited. This is done by selecting the Position radio buttons at the bottom of the window. The demo graph will be updated accordingly. |