1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski 5*b1cdbd2cSJim Jagielski<!--*********************************************************** 6*b1cdbd2cSJim Jagielski * 7*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 8*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 9*b1cdbd2cSJim Jagielski * distributed with this work for additional information 10*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 11*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 12*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 13*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 14*b1cdbd2cSJim Jagielski * 15*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 16*b1cdbd2cSJim Jagielski * 17*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 18*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 19*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 21*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 22*b1cdbd2cSJim Jagielski * under the License. 23*b1cdbd2cSJim Jagielski * 24*b1cdbd2cSJim Jagielski ***********************************************************--> 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski <helpdocument version="1.0"> 30*b1cdbd2cSJim Jagielski<meta> 31*b1cdbd2cSJim Jagielski<topic id="textschart0103010000xml" indexer="include" status="PUBLISH"> 32*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Data Table</title> 33*b1cdbd2cSJim Jagielski<filename>/text/schart/01/03010000.xhp</filename> 34*b1cdbd2cSJim Jagielski</topic> 35*b1cdbd2cSJim Jagielski</meta> 36*b1cdbd2cSJim Jagielski<body> 37*b1cdbd2cSJim Jagielski<section id="diagrammdaten"> 38*b1cdbd2cSJim Jagielski<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> 39*b1cdbd2cSJim Jagielski<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> 40*b1cdbd2cSJim Jagielski</section> 41*b1cdbd2cSJim Jagielski<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> 42*b1cdbd2cSJim Jagielski<switch select="appl"> 43*b1cdbd2cSJim Jagielski<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> 44*b1cdbd2cSJim Jagielski</case> 45*b1cdbd2cSJim Jagielski</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> 46*b1cdbd2cSJim Jagielski<section id="howtoget"> 47*b1cdbd2cSJim Jagielski <embed href="text/schart/00/00000004.xhp#astdgd"/> 48*b1cdbd2cSJim Jagielski</section> 49*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000001.xhp#ShiftF1"/> 50*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id6129947" xml-lang="en-US" level="2" l10n="NEW">To change chart data</paragraph> 51*b1cdbd2cSJim Jagielski<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> 52*b1cdbd2cSJim Jagielski<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> 53*b1cdbd2cSJim Jagielski<list type="ordered"> 54*b1cdbd2cSJim Jagielski<listitem> 55*b1cdbd2cSJim Jagielski<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> 56*b1cdbd2cSJim Jagielski</listitem> 57*b1cdbd2cSJim Jagielski<listitem> 58*b1cdbd2cSJim Jagielski<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> 59*b1cdbd2cSJim Jagielski<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> 60*b1cdbd2cSJim Jagielski</listitem> 61*b1cdbd2cSJim Jagielski<listitem> 62*b1cdbd2cSJim Jagielski<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> 63*b1cdbd2cSJim Jagielski</listitem> 64*b1cdbd2cSJim Jagielski<listitem> 65*b1cdbd2cSJim Jagielski<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> 66*b1cdbd2cSJim Jagielski</listitem> 67*b1cdbd2cSJim Jagielski<listitem> 68*b1cdbd2cSJim Jagielski<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> 69*b1cdbd2cSJim Jagielski</listitem> 70*b1cdbd2cSJim Jagielski<listitem> 71*b1cdbd2cSJim Jagielski<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> 72*b1cdbd2cSJim Jagielski</listitem> 73*b1cdbd2cSJim Jagielski<listitem> 74*b1cdbd2cSJim Jagielski<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> 75*b1cdbd2cSJim Jagielski</listitem> 76*b1cdbd2cSJim Jagielski</list> 77*b1cdbd2cSJim Jagielski<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> 78*b1cdbd2cSJim Jagielski<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> 79*b1cdbd2cSJim Jagielski<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> 80*b1cdbd2cSJim Jagielski<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> 81*b1cdbd2cSJim Jagielski<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> 82*b1cdbd2cSJim Jagielski<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> 83*b1cdbd2cSJim Jagielski<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> 84*b1cdbd2cSJim Jagielski<!-- 85*b1cdbd2cSJim Jagielski<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> 86*b1cdbd2cSJim Jagielski --> 87*b1cdbd2cSJim Jagielski<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> 88*b1cdbd2cSJim Jagielski</body> 89*b1cdbd2cSJim Jagielski</helpdocument> 90