1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 352ac0773SAndrew Rist<!--*********************************************************** 41452e63cSmseidel * 552ac0773SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 652ac0773SAndrew Rist * or more contributor license agreements. See the NOTICE file 752ac0773SAndrew Rist * distributed with this work for additional information 852ac0773SAndrew Rist * regarding copyright ownership. The ASF licenses this file 952ac0773SAndrew Rist * to you under the Apache License, Version 2.0 (the 1052ac0773SAndrew Rist * "License"); you may not use this file except in compliance 1152ac0773SAndrew Rist * with the License. You may obtain a copy of the License at 121452e63cSmseidel * 1352ac0773SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 141452e63cSmseidel * 1552ac0773SAndrew Rist * Unless required by applicable law or agreed to in writing, 1652ac0773SAndrew Rist * software distributed under the License is distributed on an 1752ac0773SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1852ac0773SAndrew Rist * KIND, either express or implied. See the License for the 1952ac0773SAndrew Rist * specific language governing permissions and limitations 2052ac0773SAndrew Rist * under the License. 211452e63cSmseidel * 2252ac0773SAndrew Rist ***********************************************************--> 2352ac0773SAndrew Rist 241452e63cSmseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textschart0103010000xml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Data Table</title> 28cdf0e10cSrcweir<filename>/text/schart/01/03010000.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<section id="diagrammdaten"> 339b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/.uno:DiagramData" id="bm_id3153771" localize="false"/> 34*085b14ffSmseidel<paragraph role="heading" id="hd_id3150869" xml-lang="en-US" level="1" l10n="CHG"><link href="text/schart/01/03010000.xhp" name="Data Table">Data Table</link></paragraph> 35*085b14ffSmseidel<paragraph role="paragraph" id="par_id3151115" xml-lang="en-US" l10n="CHG"><ahelp hid=".uno:DiagramData">Opens the <emph>Data Table</emph> dialog where you can edit the chart data.</ahelp></paragraph> 36cdf0e10cSrcweir</section> 37*085b14ffSmseidel<paragraph role="paragraph" id="par_id3149667" xml-lang="en-US" l10n="CHG">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> 38cdf0e10cSrcweir<switch select="appl"> 399b5c5849Smseidel<case select="WRITER"> 409b5c5849Smseidel<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> 41cdf0e10cSrcweir</case> 429b5c5849Smseidel</switch> 439b5c5849Smseidel<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> 44cdf0e10cSrcweir<section id="howtoget"> 451452e63cSmseidel<embed href="text/schart/00/00000004.xhp#astdgd"/> 46cdf0e10cSrcweir</section> 47cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#ShiftF1"/> 48cdf0e10cSrcweir<paragraph role="heading" id="hd_id6129947" xml-lang="en-US" level="2" l10n="NEW">To change chart data</paragraph> 49cdf0e10cSrcweir<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> 50cdf0e10cSrcweir<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> 51cdf0e10cSrcweir<list type="ordered"> 52cdf0e10cSrcweir<listitem> 53cdf0e10cSrcweir<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> 54cdf0e10cSrcweir</listitem> 55cdf0e10cSrcweir<listitem> 56cdf0e10cSrcweir<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> 57cdf0e10cSrcweir<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> 58cdf0e10cSrcweir</listitem> 59cdf0e10cSrcweir<listitem> 60cdf0e10cSrcweir<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> 61cdf0e10cSrcweir</listitem> 62cdf0e10cSrcweir<listitem> 63cdf0e10cSrcweir<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> 64cdf0e10cSrcweir</listitem> 65cdf0e10cSrcweir<listitem> 66cdf0e10cSrcweir<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> 67cdf0e10cSrcweir</listitem> 68cdf0e10cSrcweir<listitem> 69cdf0e10cSrcweir<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> 70cdf0e10cSrcweir</listitem> 71cdf0e10cSrcweir<listitem> 72cdf0e10cSrcweir<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> 73cdf0e10cSrcweir</listitem> 74cdf0e10cSrcweir</list> 759b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_INSERT_ROW" id="bm_id3154022" localize="false"/><comment>insert row</comment> 76*085b14ffSmseidel<paragraph role="paragraph" id="par_id3150297" xml-lang="en-US" l10n="U"><ahelp hid="." visibility="hidden">Inserts a new row below the current row.</ahelp></paragraph> 779b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_INSERT_COL" id="bm_id3152988" localize="false"/><comment>insert series</comment> 78*085b14ffSmseidel<paragraph role="paragraph" id="par_id3145384" xml-lang="en-US" l10n="U"><ahelp hid="." visibility="hidden">Inserts a new data series after the current column.</ahelp></paragraph> 799b5c5849Smseidel<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> 809b5c5849Smseidel<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> 819b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_DELETE_ROW" id="bm_id3150215" localize="false"/><comment>delete row</comment> 82*085b14ffSmseidel<paragraph role="paragraph" id="par_id3159231" xml-lang="en-US" l10n="U"><ahelp hid="." visibility="hidden">Deletes the current row. It is not possible to delete the label row.</ahelp></paragraph> 839b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_DELETE_COL" id="bm_id3153959" localize="false"/><comment>delete series</comment> 84*085b14ffSmseidel<paragraph role="paragraph" id="par_id3153336" xml-lang="en-US" l10n="U"><ahelp hid="." visibility="hidden">Deletes the current series or text column. It is not possible to delete the first text column.</ahelp></paragraph> 859b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_COL" id="bm_id8501846" localize="false"/><comment>move series right</comment> 869b5c5849Smseidel<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> 879b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_ROW" id="bm_id4469130" localize="false"/><comment>move row down</comment> 889b5c5849Smseidel<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> 89cdf0e10cSrcweir<!-- 909b5c5849Smseidel<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> 919b5c5849Smseidel<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> 92cdf0e10cSrcweir --> 939b5c5849Smseidel<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_DATA_SERIES_LABEL" id="bm_id3522446" localize="false"/> 949b5c5849Smseidel<paragraph role="paragraph" id="par_id6697286" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter names for the data series.</ahelp></paragraph> 95cdf0e10cSrcweir</body> 96cdf0e10cSrcweir</helpdocument> 97