1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!-- 6 *********************************************************************** 7 * 8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9 * 10 * Copyright 2000, 2011 Oracle and/or its affiliates. 11 * 12 * OpenOffice.org - a multi-platform office productivity suite 13 * 14 * This file is part of OpenOffice.org. 15 * 16 * OpenOffice.org is free software: you can redistribute it and/or modify 17 * it under the terms of the GNU Lesser General Public License version 3 18 * only, as published by the Free Software Foundation. 19 * 20 * OpenOffice.org is distributed in the hope that it will be useful, 21 * but WITHOUT ANY WARRANTY; without even the implied warranty of 22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23 * GNU Lesser General Public License version 3 for more details 24 * (a copy is included in the LICENSE file that accompanied this code). 25 * 26 * You should have received a copy of the GNU Lesser General Public License 27 * version 3 along with OpenOffice.org. If not, see 28 * <http://www.openoffice.org/license.html> 29 * for a copy of the LGPLv3 License. 30 * 31 ************************************************************************ 32 --> 33 34 35 <helpdocument version="1.0"> 36<meta> 37<topic id="textschart0103010000xml" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">Data Table</title> 39<filename>/text/schart/01/03010000.xhp</filename> 40</topic> 41</meta> 42<body> 43<section id="diagrammdaten"> 44<bookmark xml-lang="en-US" branch="hid/.uno:DiagramData" id="bm_id3153771" localize="false"/><paragraph role="heading" id="hd_id3150869" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/schart/01/03010000.xhp" name="Data Table">Data Table</link></paragraph> 45<paragraph role="paragraph" id="par_id3151115" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:DiagramData">Opens the<emph> Data Table </emph>dialog where you can edit the chart data.</ahelp></paragraph> 46</section> 47<paragraph role="paragraph" id="par_id3149667" xml-lang="en-US" l10n="CHG" oldref="51">The<emph> Data Table </emph>dialog is not available if you insert a chart that is based on a Calc sheet or on a Writer table.<comment>UFI: fixes #i31208#</comment></paragraph> 48<switch select="appl"> 49<case select="WRITER"><paragraph role="paragraph" id="par_id6746421" xml-lang="en-US" l10n="NEW"><link href="text/swriter/01/06990000.xhp">To update a chart manually when a Writer table got changed</link></paragraph><comment>i81240</comment> 50</case> 51</switch><paragraph role="note" id="par_id2565996" xml-lang="en-US" l10n="NEW">Some changes will become visible only after you close and reopen the dialog.<comment>UFI: fixes #i22854#</comment><comment>still so?</comment></paragraph> 52<section id="howtoget"> 53 <embed href="text/schart/00/00000004.xhp#astdgd"/> 54</section> 55<embed href="text/shared/00/00000001.xhp#ShiftF1"/> 56<paragraph role="heading" id="hd_id6129947" xml-lang="en-US" level="2" l10n="NEW">To change chart data</paragraph> 57<paragraph role="paragraph" id="par_id8141117" xml-lang="en-US" l10n="NEW">When you create a chart that is based on default data, or when you copy a chart into your document, you can open the Data Table dialog to enter your own data. The chart responds to the data in a live preview.</paragraph> 58<paragraph role="paragraph" id="par_id9487594" xml-lang="en-US" l10n="NEW">Close the Chart Data dialog to apply all changes to the chart. Choose <emph>Edit - Undo</emph> to cancel the changes.</paragraph> 59<list type="ordered"> 60<listitem> 61<paragraph role="paragraph" id="par_id4149906" xml-lang="en-US" l10n="NEW">Insert or select a chart that is not based on existing cell data.</paragraph> 62</listitem> 63<listitem> 64<paragraph role="paragraph" id="par_id6064943" xml-lang="en-US" l10n="NEW">Choose <emph>View - Chart Data Table</emph> to open the Data Table dialog.</paragraph> 65<paragraph role="paragraph" id="par_id3236182" xml-lang="en-US" l10n="CHG">The data series are organized in columns. The role of the left most column is set to categories or data labels respectively. The contents of the left most column are always formatted as text. You can insert more text columns to be used as hierarchical labels.</paragraph> 66</listitem> 67<listitem> 68<paragraph role="paragraph" id="par_id9799798" xml-lang="en-US" l10n="NEW">Click a cell in the dialog and change the contents. Click another cell to see the changed contents in the preview.</paragraph> 69</listitem> 70<listitem> 71<paragraph role="paragraph" id="par_id1251258" xml-lang="en-US" l10n="NEW">Enter the name of the data series in the text box above the column.</paragraph> 72</listitem> 73<listitem> 74<paragraph role="paragraph" id="par_id743430" xml-lang="en-US" l10n="CHG">Use the icons above the table to insert or delete rows and columns. For data series with multiple columns, only whole data series can be inserted or deleted. <comment>Regina: see issue 72901</comment></paragraph> 75</listitem> 76<listitem> 77<paragraph role="paragraph" id="par_id8111819" xml-lang="en-US" l10n="CHG">The order of the data series in the chart is the same as in the data table. Use the <emph>Move Series Right</emph> icon to switch the current column with its neighbor on the right.<comment>changed names, see i79863</comment></paragraph> 78</listitem> 79<listitem> 80<paragraph role="paragraph" id="par_id9116794" xml-lang="en-US" l10n="CHG">The order of the categories or data points in the chart is the same as in the data table. Use the <emph>Move Row Down</emph> icon to switch the current row with its neighbor below.</paragraph> 81</listitem> 82</list> 83<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_INSERT_ROW" id="bm_id3154022" localize="false"/><comment>insert row</comment><paragraph role="paragraph" id="par_id3150297" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="." visibility="hidden">Inserts a new row below the current row.</ahelp></paragraph> 84<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_INSERT_COL" id="bm_id3152988" localize="false"/><comment>insert series</comment><paragraph role="paragraph" id="par_id3145384" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="." visibility="hidden">Inserts a new data series after the current column.</ahelp></paragraph> 85<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_INSERT_TEXT_COL" id="bm_id3156022" localize="false"/><comment>insert text column</comment><paragraph role="paragraph" id="par_id3152297" xml-lang="en-US"><ahelp hid="." visibility="hidden">Inserts a new text column after the current column for hierarchical axes descriptions.</ahelp></paragraph> 86<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_DELETE_ROW" id="bm_id3150215" localize="false"/><comment>delete row</comment><paragraph role="paragraph" id="par_id3159231" xml-lang="en-US" l10n="U" oldref="26"><ahelp hid="." visibility="hidden">Deletes the current row. It is not possible to delete the label row.</ahelp></paragraph> 87<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_DELETE_COL" id="bm_id3153959" localize="false"/><comment>delete series</comment><paragraph role="paragraph" id="par_id3153336" xml-lang="en-US" l10n="U" oldref="29"><ahelp hid="." visibility="hidden">Deletes the current series or text column. It is not possible to delete the first text column.</ahelp></paragraph> 88<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_COL" id="bm_id8501846" localize="false"/><comment>move series right</comment><paragraph role="paragraph" id="par_id4089175" xml-lang="en-US" l10n="CHG"><ahelp hid="." visibility="hidden">Switches the current column with its neighbor at the right.</ahelp></paragraph> 89<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_ROW" id="bm_id4469130" localize="false"/><comment>move row down</comment><paragraph role="paragraph" id="par_id3949095" xml-lang="en-US" l10n="CHG"><ahelp hid="." visibility="hidden">Switches the current row with its neighbor below.</ahelp></paragraph><comment>edit fields, see i72361</comment> 90<!-- 91<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_TOGGLE_DATE_CATEGORIES" id="bm_id990469130" localize="false"/><comment>Categories: Date/Text</comment><paragraph role="paragraph" id="par_id990949095" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">For a category axis that might be a date axis, you can change the formatting of the data from Date to Text.</ahelp></paragraph><comment>see i115840 and 116467</comment> 92 --> 93<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_DATA_SERIES_LABEL" id="bm_id3522446" localize="false"/><paragraph role="paragraph" id="par_id6697286" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter names for the data series.</ahelp></paragraph> 94</body> 95</helpdocument> 96