
The effects achieved in the figure above are explained below. When you do this you might need to enlarge the chart area again to regain the original size of the pieces. If your aim is to accentuate one piece of the pie, you can separate out one piece by carefully highlighting it after you have finished with the Chart Wizard, and dragging it out of the group. You can choose in the Chart Wizard to explode the pie chart, but this is an all or nothing option. If your aim is to accentuate one piece of the pie, you can separate out one piece by carefully highlighting it after you have finished with the Chart Wizard, and dragging it out of the pie plate. Just don’t clutter it so much that your message is lost, and be careful that tilting does not distort the relative size of the segments. It can then be tilted, given shadows, and generally turned into a work of art. You can do some interesting things with a pie chart, especially if you make it into a 3D chart.
#Openoffice calc graph series#
They work best with smaller numbers of values, about half a dozen more than this and the visual impact begins to fade.Īs the Chart Wizard guesses the series that you wish to include in your pie chart, you might need to adjust this initially on the Wizard’s Data Ranges page if you know you want a pie chart, or by using the Format > Data Ranges > Data Series dialog. For example, comparisons of departmental spending: what the department spent on different items or what different departments spent. Pie charts are excellent when you need to compare proportions. We also changed the colors to a hatch pattern.


Select the desired portion of the spreadsheet and copy.

A better method is to use NeoOffice Draw in a manner similar to exporting charts above. One disadvantage of the screenshot and Grab methods is that they leave all the grid lines, etc., visible.

#Openoffice calc graph pdf#
Grab (located in /Applications/Utilities) performs much the same way as the the keyboard method of taking a screenshot, except you can choose additional options and select options from menus instead of memorizing shortcuts.Īnother option is to print your spreadsheet to PDF and then crop the PDF in Preview and export the result in the desired image format. Cmd-Shift-4 activates the screenshot-with-selection function simply click and drag over the desired area and then release the mouse button.
#Openoffice calc graph mac os#
The simplest way is to use Mac OS X's built-in screenshot function and select the desired portion of the spreadsheet. Microsoft Excel has a "camera" function to facilitate this, but while NeoOffice does not have this function, it is still fairly easy to achieve similar results. Users often want to export a portion of their spreadsheet to an image for inclusion in other non-NeoOffice documents. Exporting spreadsheets (or portions thereof) Ensure that the "Selection" box is checked.Ensure the chart is still selected in your Draw document.To export a chart or graph as an image, follow these steps. 2 Exporting spreadsheets (or portions thereof).
