File: //lib64/libreoffice/help/en-US/schart.jar
PK
w�X text/schart/PK
w�X text/schart/02/PK
w�XG>�� � text/schart/02/01190000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data in Rows</title><filename>/text/schart/02/01190000.xhp</filename></topic></meta><body><section id="dateninreihen"><bookmark branch="hid/.uno:DataInRows" id="bm_id3147436"/><paragraph role="heading" level="1"><link href="text/schart/02/01190000.xhp">Data in Rows</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DataInRows">Changes the arrangement of the chart data.</ahelp></paragraph></section><section id="syreihe"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_datainrows.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data in Rows</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
w�X�Jft. . text/schart/02/02020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Current Chart Type</title><filename>/text/schart/02/02020000.xhp</filename></topic></meta><body><section id="diagrammtyp"><bookmark branch="hid/.uno:ContextType" id="bm_id3150770"/><paragraph role="heading" level="1"><link href="text/schart/02/02020000.xhp">Current Chart Type</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ContextType" visibility="visible">Displays the name of the current chart type.</ahelp></paragraph></section></body></helpdocument>
PK
w�XE��? ? text/schart/02/01210000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Scale Text</title><filename>/text/schart/02/01210000.xhp</filename></topic></meta><body><section id="textskalierung"><bookmark branch="index" id="bm_id3152996"/><bookmark branch="hid/.uno:ScaleText" id="bm_id3156326"/><paragraph role="heading" level="1"><link href="text/schart/02/01210000.xhp">Scale Text</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:ScaleText">Rescales the text in the chart when you change the size of the chart.</ahelp></paragraph></section><section id="sytextskal"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_scaletext.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Scale Text</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
w�X�63 text/schart/02/01200000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data in Columns</title><filename>/text/schart/02/01200000.xhp</filename></topic></meta><body><section id="dateninspalten"><bookmark branch="hid/.uno:DataInColumns" id="bm_id3150439"/><paragraph role="heading" level="1"><link href="text/schart/02/01200000.xhp">Data in Columns</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DataInColumns">Changes the arrangement of the chart data.</ahelp></paragraph></section><section id="syspalte"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_dataincolumns.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Data in Columns</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
w�X�7(�� � text/schart/02/01220000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Automatic Layout</title><filename>/text/schart/02/01220000.xhp</filename></topic></meta><body><section id="neuanordnen"><bookmark branch="index" id="bm_id3150400"/><bookmark branch="hid/.uno:NewArrangement" id="bm_id3150767"/><paragraph role="heading" level="1"><link href="text/schart/02/01220000.xhp">Automatic Layout</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:NewArrangement">Moves all chart elements to their default positions inside the current chart. This function does not alter the chart type or any other attributes other than the position of elements.</ahelp></paragraph></section><section id="syneuanordnen"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_newarrangement.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Automatic Layout</paragraph></tablecell></tablerow></table></section></body></helpdocument>
PK
w�X text/schart/00/PK
w�XA��< < text/schart/00/00000004.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>To access this function...</title><filename>/text/schart/00/00000004.xhp</filename></topic></meta><body><paragraph role="heading" level="1"><variable id="wie">To access this function...
</variable></paragraph><section id="astdgd"><paragraph role="paragraph">Choose <emph>View - Chart Data Table</emph> (Charts)</paragraph><paragraph role="paragraph">On Formatting bar, click</paragraph><section id="sydiadaten"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_grid.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Chart Data</paragraph></tablecell></tablerow></table></section></section><paragraph role="paragraph"><variable id="efgttl">Choose <emph>Insert - Title </emph>(Charts)
</variable></paragraph><section id="efglgd"><paragraph role="paragraph">Choose <emph>Insert - Legend </emph>(Charts)</paragraph><paragraph role="paragraph">Choose <emph>Format - Legend - Position</emph> tab (Charts)</paragraph></section><section id="efgdbs"><paragraph role="paragraph">Choose <emph>Insert - Data Labels </emph>(Charts)</paragraph><paragraph role="paragraph">Choose <emph>Format - Format Selection - Data Point/Data Series - Data Labels</emph> tab (for data series and data point) (Charts)</paragraph></section><paragraph role="paragraph"><variable id="efgaug">Choose <emph>Insert - Axes </emph>(Charts)
</variable></paragraph><section id="efgaugg"><paragraph role="paragraph">Choose <emph>Insert - Grids </emph>(Charts)</paragraph><paragraph role="paragraph">On Formatting bar, click</paragraph><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_togglegridhorizontal.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Horizontal Grids</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_togglegridvertical.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Vertical Grids</paragraph></tablecell></tablerow></table></section><paragraph role="paragraph"><variable id="efgsta">Choose <emph>Insert - X Error Bars </emph> or <emph>Insert - Y Error Bars </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="trendlines">Choose Insert - Trend Lines (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="sonderz">Choose <emph>Insert - Special Character </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtoes">Choose <emph>Format - Format Selection </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtodd">Choose <emph>Format - Format Selection - Data Point</emph> dialog (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtodr">Choose <emph>Format - Format Selection - Data Series</emph> dialog (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="optionen">Choose <emph>Format - Format Selection - Data Series - Options</emph> tab (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtttl">Choose <emph>Format - Title </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtoe">Choose <emph>Format - Format Selection - Title</emph> dialog (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtegt">Choose <emph>Format - Format Selection - Title</emph> dialog (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frttya">Choose <emph>Format - Title </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frttyab">Choose <emph>Format - Axis </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtlgd">Choose <emph>Format - Legend, or Format - Format Selection</emph> - <emph>Legend </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtaa">Choose <emph>Format - Axis - X Axis/Secondary X Axis/Z Axis/All Axes </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtyas">Choose <emph>Format - Axis - Y Axis/Secondary Y Axis </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtysk">Choose <emph>Format - Axis - Y Axis - Scale</emph> tab (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="positioning">Choose <emph>Format - Axis - X Axis - Positioning</emph> tab (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="positioningy">Choose <emph>Format - Axis - Y Axis - Positioning</emph> tab (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtgt">Choose <emph>Format - Grid </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtgtr">Choose <emph>Format - Grid - X, Y, Z Axis Major Grid/ X, Y, Z Minor Grid/ All Axis Grids </emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtdgw">Choose <emph>Format - Chart Wall - Chart</emph> dialog (Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtdgb">Choose <emph>Format - Chart Floor</emph>(Charts)
</variable></paragraph><paragraph role="paragraph"><variable id="frtdgf">Choose <emph>Format - Chart Area</emph>(Charts)
</variable></paragraph><section id="frtdgty"><paragraph role="paragraph">Choose <emph>Format - Chart Type </emph>(Charts)</paragraph><paragraph role="paragraph">On Formatting bar, click</paragraph><section id="sydiatyp"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_diagramtype.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Edit Chart Type</paragraph></tablecell></tablerow></table></section></section><paragraph role="paragraph"><variable id="frtdda">Choose <emph>Format - 3D View</emph>(Charts)
</variable></paragraph><section id="anordnung"><paragraph role="paragraph">Choose <emph>Format - Arrangement </emph>(Charts)</paragraph><paragraph role="paragraph">Open context menu - choose <emph>Arrangement </emph>(Charts)</paragraph><section id="titelanaus"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_toggletitle.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Title On/Off</paragraph></tablecell></tablerow></table></section></section><section id="achseeinaus"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_toggleaxistitle.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Axis Titles On/Off</paragraph></tablecell></tablerow></table></section><section id="gitterx"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_togglegridhorizontal.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Horizontal Grids</paragraph></tablecell></tablerow></table></section><section id="achsenalle"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_toggleaxisdescr.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Show/Hide Axis Descriptions</paragraph></tablecell></tablerow></table></section><section id="gittery"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_togglegridvertical.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Vertical Grids</paragraph></tablecell></tablerow></table></section><section id="wiz"><paragraph role="paragraph">Choose Insert - <switchinline select="appl"><caseinline select="WRITER"> Object -
</caseinline></switchinline> Chart </paragraph></section><section id="wiz_ranges"><paragraph role="paragraph">Choose Insert - <switchinline select="appl"><caseinline select="WRITER"> Object -
</caseinline></switchinline> Chart </paragraph><paragraph role="paragraph">Double-click a chart, then choose Format - Data Ranges</paragraph></section><paragraph role="paragraph"><variable id="smlp">In the Chart Type dialog of a Line chart or XY chart that displays lines, choose Smooth in the Lines type dropdown, then click the Properties button.
</variable></paragraph><paragraph role="paragraph"><variable id="stlp">In the Chart Type dialog of a Line chart or XY chart that displays lines, choose Stepped in the Lines type dropdown, then click the Properties button.
</variable></paragraph></body></helpdocument>
PK
w�X text/schart/01/PK
w�X���� text/schart/01/type_xy.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type XY</title><filename>/text/schart/01/type_xy.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id84231"/><paragraph role="heading" level="1"><variable id="type_xy"><link href="text/schart/01/type_xy.xhp">Chart Type XY (Scatter)</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">XY (Scatter)</paragraph><paragraph role="paragraph">An XY chart in its basic form is based on one data series consisting of a name, a list of x‑values, and a list of y‑values. Each value pair (x|y) is shown as a point in a coordinate system. The name of the data series is associated with the y‑values and shown in the legend.</paragraph><paragraph role="paragraph">Choose an XY chart for the following example tasks:</paragraph><list type="ordered"><listitem><paragraph role="paragraph">scale the x‑axis</paragraph></listitem><listitem><paragraph role="paragraph">generate a parameter curve, for example a spiral</paragraph></listitem><listitem><paragraph role="paragraph">draw the graph of a function</paragraph></listitem><listitem><paragraph role="paragraph">explore the statistical association of quantitative variables</paragraph></listitem></list><paragraph role="paragraph">Your XY chart may have more than one data series.</paragraph><paragraph role="heading" level="2">XY Chart Variants</paragraph><paragraph role="paragraph">You can choose an XY chart variant on the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link>, or by choosing <item type="menuitem">Format - Chart Type </item>for a chart in edit mode.</paragraph><paragraph role="paragraph">The chart is created with default settings. After the chart is finished, you can edit its properties to change the appearance. Line styles and icons can be changed on the <emph>Line</emph>tab page of the data series properties dialog.</paragraph><paragraph role="paragraph">Double-click any data point to open the <item type="menuitem">Data Series</item> dialog. In this dialog, you can change many properties of the data series.</paragraph><paragraph role="paragraph">For 2D charts, you can choose <item type="menuitem">Insert - Y Error Bars</item> to enable the display of error bars.</paragraph><paragraph role="paragraph">You can enable the display of mean value lines and trend lines using commands on the Insert menu.</paragraph><paragraph role="heading" level="3">Points only</paragraph><paragraph role="paragraph">Each data point is shown by an icon. %PRODUCTNAME uses default icons with different forms and colors for each data series. The default colors are set in <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - Charts - Default Colors</item>. </paragraph><paragraph role="heading" level="3">Lines Only</paragraph><paragraph role="paragraph">This variant draws straight lines from one data point to the next. The data points are not shown by icons. </paragraph><paragraph role="paragraph">The drawing order is the same as the order in the data series. Mark <emph>Sort by X Values</emph> to draw the lines in the order of the x values. This sorting applies only to the chart, not to the data in the table.</paragraph><paragraph role="heading" level="3">Points and Lines</paragraph><paragraph role="paragraph">This variant shows points and lines at the same time.</paragraph><paragraph role="heading" level="3">3D Lines</paragraph><paragraph role="paragraph">The lines are shown like tapes. The data points are not shown by icons. In the finished chart choose <link href="text/schart/01/three_d_view.xhp">3D View</link> to set properties like illumination and angle of view.</paragraph><paragraph role="heading" level="3">Smooth Lines</paragraph><paragraph role="paragraph">Choose <emph>Smooth</emph> from the <emph>Line type</emph> dropdown to draw curves instead of straight line segments.</paragraph><paragraph role="paragraph">Click <emph>Properties</emph> to set details for the curves.</paragraph><paragraph role="paragraph"><emph>Cubic Spline</emph> interpolates your data points with polynomials of degree 3. The transitions between the polynomial pieces are smooth, having the same slope and curvature. </paragraph><paragraph role="paragraph">The <emph>Resolution</emph> determines how many line segments are calculated to draw a piece of polynomial between two data points. You can see the intermediate points if you click any data point.</paragraph><paragraph role="paragraph"><emph>B-Spline</emph> uses a parametric, interpolating B-spline curve. Those curves are built piecewise from polynomials. The <emph>Degree of polynomials</emph> sets the degree of these polynomials.</paragraph><paragraph role="heading" level="3">Stepped Lines</paragraph><paragraph role="paragraph">Choose <emph>Stepped</emph> from the <emph>Line type</emph> dropdown to draw lines which step from point to point instead of straight line segments.</paragraph><paragraph role="paragraph">Click <emph>Properties</emph> to set details for the curves.</paragraph><paragraph role="paragraph">There are 4 different step types:</paragraph><list type="unordered"><listitem><paragraph role="paragraph"><image src="chart2/res/step_start_30.png"/></paragraph><paragraph role="paragraph">Start with horizontal line and step up vertically at the end.</paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_end_30.png"/></paragraph><paragraph role="paragraph">Start to step up vertically and end with horizontal line.</paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_center_x_30.png"/></paragraph><paragraph role="paragraph">Start with horizontal line, step up vertically in the middle of the X values and end with horizontal line.</paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_center_y_30.png"/></paragraph><paragraph role="paragraph">Start to step up vertically to the middle of the Y values, draw a horizontal line and finish by stepping vertically to the end.</paragraph></listitem></list><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�XP��| | text/schart/01/04060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Options</title><filename>/text/schart/01/04060000.xhp</filename></topic></meta><body><section id="optionen"><bookmark branch="index" id="bm_id3149400"/><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/TP_OPTIONS" id="bm_id8064517"/><paragraph role="heading" level="1"><link href="text/schart/01/04060000.xhp">Options</link></paragraph><paragraph role="paragraph">Use this dialog to define some options that are available for specific chart types. The contents of the Options dialog vary with the chart type.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#optionen"/></section><paragraph role="heading" level="2">Align data series to:</paragraph><paragraph role="paragraph">In this area you can choose between two Y axis scaling modes. The axes can only be scaled and given properties separately.</paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/RBT_OPT_AXIS_1" id="bm_id8064516"/><paragraph role="heading" level="2">Primary Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_SeriesToAxis/RBT_OPT_AXIS_1">This option is active as default. All data series are aligned to the primary Y axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/RBT_OPT_AXIS_2" id="bm_id9959715"/><paragraph role="heading" level="2">Secondary Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_SeriesToAxis/RBT_OPT_AXIS_2">Changes the scaling of the Y axis. This axis is only visible when at least one data series is assigned to it and the axis view is active.</ahelp></paragraph><paragraph role="heading" level="2">Settings</paragraph><paragraph role="paragraph">Define the settings for a bar chart in this area. Any changes apply to all data series of the chart, not to the selected data only.</paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/MT_GAP" id="bm_id6286812"/><paragraph role="heading" level="2">Spacing</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_SeriesToAxis/MT_GAP">Defines the spacing between the columns in percent.</ahelp> The maximal spacing is 600%.</paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/MT_OVERLAP" id="bm_id119022"/><paragraph role="heading" level="2">Overlap</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_SeriesToAxis/MT_OVERLAP">Defines the necessary settings for overlapping data series.</ahelp> You can choose between -100 and +100%.</paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/CB_CONNECTOR" id="bm_id5567491"/><paragraph role="heading" level="2">Connection Lines</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_SeriesToAxis/CB_CONNECTOR">For "stacked" and "percent" column (vertical bar) charts, mark this check box to connect the column layers that belong together with lines.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/CB_BARS_SIDE_BY_SIDE" id="bm_id8464003"/><paragraph role="heading" level="2">Show bars side by side</paragraph><paragraph role="paragraph">If two axes are shown in a bar chart, and some data series are attached to the first axis, while some other data series are attached to the second axis, then both sets of data series are shown independently, overlapping each other.</paragraph><paragraph role="paragraph">As a result, bars attached to the first y-axis are partly or completely hidden by bars attached to the second y-axis. To avoid this, enable the option to display bars side by side. <ahelp hid=".">The bars from different data series are shown as if they were attached only to one axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_PolarOptions/CB_CLOCKWISE" id="bm_id7622913"/><paragraph role="heading" level="2">Clockwise direction</paragraph><paragraph role="paragraph">Available for pie and donut charts. <ahelp hid=".">The default direction in which the pieces of a pie chart are ordered is counterclockwise. Enable the <emph>Clockwise direction</emph> checkbox to draw the pieces in opposite direction.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_PolarOptions/CT_ANGLE_DIAL" id="bm_id2421643"/><paragraph role="heading" level="2">Starting angle</paragraph><paragraph role="paragraph"><ahelp hid=".">Drag the small dot along the circle or click any position on the circle to set the starting angle of a pie or donut chart. The starting angle is the mathematical angle position where the first piece is drawn. The value of 90 degrees draws the first piece at the 12 o'clock position. A value of 0 degrees starts at the 3 o'clock position.</ahelp></paragraph><paragraph role="note">In 3D pie and donut charts that were created with older versions of the software, the starting angle is 0 degrees instead of 90 degrees. For old and new 2D charts the default starting angle is 90 degrees.</paragraph><paragraph role="note">When you change the starting angle or the direction, only current versions of the software show the changed values. Older versions of the software display the same document using the default values: Always counterclockwise direction and a starting value of 90 degrees (2D pie charts) or 0 degrees (3D pie charts).</paragraph><bookmark branch="hid/modules/schart/ui/tp_PolarOptions/NF_STARTING_ANGLE" id="bm_id5705740"/><paragraph role="heading" level="2">Degrees</paragraph><paragraph role="paragraph"><ahelp hid=".">Enter the starting angle between 0 and 359 degrees. You can also click the arrows to change the displayed value.</ahelp></paragraph><paragraph role="heading" level="2">Plot missing values</paragraph><paragraph role="paragraph">Sometimes values are missing in a data series that is shown in a chart. You can select from different options how to plot the missing values. The options are available for some chart types only.</paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/RB_DONT_PAINT" id="bm_id0305200910520854"/><paragraph role="heading" level="2">Leave gap</paragraph><paragraph role="paragraph"><ahelp hid=".">For a missing value, no data will be shown. This is the default for chart types Column, Bar, Line, Net.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/RB_ASSUME_ZERO" id="bm_id0305200910522325"/><paragraph role="heading" level="2">Assume zero</paragraph><paragraph role="paragraph"><ahelp hid=".">For a missing value, the y-value will be shown as zero. This is the default for chart type Area.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/RB_CONTINUE_LINE" id="bm_id0305200910523975"/><paragraph role="heading" level="2">Continue line</paragraph><paragraph role="paragraph"><ahelp hid=".">For a missing value, the interpolation from the neighbor values will be shown. This is the default for chart type XY.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_SeriesToAxis/CB_INCLUDE_HIDDEN_CELLS" id="bm_id0825200904350621"/><paragraph role="heading" level="2">Include values from hidden cells</paragraph><paragraph role="paragraph"><ahelp hid=".">Check to also show values of currently hidden cells within the source cell range.</ahelp></paragraph></body></helpdocument>
PK
w�X�&ӎ� � # text/schart/01/type_column_line.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Column and Line </title><filename>/text/schart/01/type_column_line.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id5976744"/><paragraph role="heading" level="1"><variable id="type_column_line"><link href="text/schart/01/type_column_line.xhp">Chart Type Column and Line</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Column and Line</paragraph><paragraph role="paragraph">A Column and Line chart is a combination of a <link href="text/schart/01/type_column_bar.xhp">Column chart</link> with a <link href="text/schart/01/type_line.xhp">Line chart</link>.</paragraph><paragraph role="paragraph">Select one of the variants</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Columns and Lines. The rectangles of the column data series are drawn side by side so that you can easily compare their values.</paragraph></listitem><listitem><paragraph role="paragraph">Stacked Columns and Lines. The rectangles of the column data series are drawn stacked above each other, so that the height of a column visualizes the sum of the data values.</paragraph></listitem></list><paragraph role="paragraph">You can insert a second y-axis with <link href="text/schart/01/04040000.xhp">Insert - Axes</link> after you finish the wizard.</paragraph><paragraph role="heading" level="2">To specify a data range</paragraph><paragraph role="paragraph">The leftmost columns (or the top rows) of the selected data range provide the data that are shown as Columns objects. The other columns or rows of the data range provide the data for the Lines objects. You can change this assignment in the <emph>Data Series</emph> dialog.</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Select the data range.</paragraph></listitem><listitem><paragraph role="paragraph">Click one of the options for data series in rows or in columns.</paragraph></listitem><listitem><paragraph role="paragraph">Check whether the data range has labels in the first row or in the first column or both.</paragraph></listitem></list><paragraph role="heading" level="2">Organizing data series</paragraph><paragraph role="paragraph">In the Data Series list box you see a list of all data series in the current chart.</paragraph><paragraph role="paragraph">The column data series are positioned at the top of the list, the line data series at the bottom of the list.</paragraph><list type="unordered"><listitem><paragraph role="paragraph">To organize the data series, select an entry in the list.</paragraph></listitem><listitem><paragraph role="paragraph">Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.</paragraph></listitem><listitem><paragraph role="paragraph">Click Remove to remove the selected entry from the Data Series list.</paragraph></listitem><listitem><paragraph role="paragraph">Use the Up and Down arrow buttons to move the selected entry in the list up or down. This way you can convert a Column data series to a List data series and back. This does not change the order in the data source table, but changes only the arrangement in the chart.</paragraph></listitem></list><paragraph role="heading" level="2">Editing data series</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Click an entry in the list to view and edit the properties for that entry.</paragraph><paragraph role="paragraph">In the Data Ranges list box you see the role names and cell ranges of the data series components. </paragraph></listitem><listitem><paragraph role="paragraph">Click an entry, then edit the contents in the text box below. </paragraph><paragraph role="paragraph">The label next to the text box states the currently selected role. </paragraph></listitem><listitem><paragraph role="paragraph">Enter the range or click <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph></listitem></list><paragraph role="paragraph">The range for a data role, like Y-Values, must not include a label cell.</paragraph><paragraph role="heading" level="2">Editing categories or data labels</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Enter or select a cell range that will be used as text for categories or data labels. </paragraph></listitem></list><paragraph role="paragraph">The values in the Categories range will be shown as labels on the x axis.</paragraph><paragraph role="heading" level="2">Inserting chart elements</paragraph><paragraph role="paragraph">Use the Chart Elements page of the Chart Wizard to insert any of the following elements:</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Chart titles</paragraph></listitem><listitem><paragraph role="paragraph">Legend</paragraph></listitem><listitem><paragraph role="paragraph">Visible grid lines</paragraph></listitem></list><paragraph role="paragraph">For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Secondary axes</paragraph></listitem><listitem><paragraph role="paragraph">Minor grids</paragraph></listitem><listitem><paragraph role="paragraph">Data labels</paragraph></listitem><listitem><paragraph role="paragraph">Statistics, for example mean values, y error bars and trend lines</paragraph></listitem></list><paragraph role="paragraph">To set different data labels for each data series, use the properties dialog of the data series.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X�d��o o text/schart/01/05040100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Axes</title><filename>/text/schart/01/05040100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3153768"/><bookmark branch="hid/.uno:DiagramAxisX" id="bm_id3153728"/><bookmark branch="hid/.uno:DiagramAxisZ" id="bm_id3146976"/><bookmark branch="hid/.uno:DiagramAxisAll" id="bm_id3146121"/><paragraph role="heading" level="1">Axes</paragraph><paragraph role="paragraph"><variable id="achsen"><ahelp hid=".uno:DiagramAxisAll">Opens a dialog, where you can edit the properties of the selected axis.</ahelp></variable> The name of the dialog depends on the selected axis.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtaa"/></section><paragraph role="paragraph">The <link href="text/schart/01/05040200.xhp">Y axis</link> has an enhanced dialog. For X-Y charts, the X axis chart is also enhanced by the <link href="text/schart/01/05040201.xhp"><emph>Scaling</emph></link> tab.</paragraph><paragraph role="note">Scaling the X axis is only possible in the X-Y chart type.</paragraph><embed href="text/shared/01/05200100.xhp#linie"/><paragraph role="heading" level="2"><link href="text/shared/01/05020100.xhp">Character</link></paragraph><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/05020201.xhp#ausrichtung"/></body></helpdocument>
PK
w�X�Ģ�� � " text/schart/01/wiz_data_series.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Wizard - Data Series</title><filename>/text/schart/01/wiz_data_series.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id8641621"/><paragraph role="heading" level="1"><variable id="wiz_data_series"><link href="text/schart/01/wiz_data_series.xhp">Chart Wizard - Data Series</link></variable></paragraph><paragraph role="paragraph">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can change the source range of all data series separately, including their labels. You can also change the range of the categories. You can first select the data range on the Data Range page and then remove unnecessary data series or add data series from other cells here.</paragraph><paragraph role="tip">If there seem to be too many options on this page, just define the data range on the Chart Wizard - Data Range page and skip this page.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz_ranges"/></section><paragraph role="paragraph">This dialog is only available for charts based on a Calc or Writer table.</paragraph><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">Organizing data series</paragraph><paragraph role="paragraph">In the Data Series list box you see a list of all data series in the current chart.</paragraph><list type="unordered"><listitem><paragraph role="paragraph">To organize the data series, select an entry in the list.</paragraph></listitem><listitem><paragraph role="paragraph">Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.</paragraph></listitem><listitem><paragraph role="paragraph">Click Remove to remove the selected entry from the Data Series list.</paragraph></listitem><listitem><paragraph role="paragraph">Use the Up and Down arrow buttons to move the selected entry in the list up or down. This does not change the order in the data source table, but changes only the arrangement in the chart.</paragraph></listitem></list><paragraph role="heading" level="2">Editing data series</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Click an entry in the list to view and edit the properties for that entry.</paragraph><paragraph role="paragraph">In the Data Ranges list box you see the role names and cell ranges of the data series components. </paragraph></listitem><listitem><paragraph role="paragraph">Click an entry, then edit the contents in the text box below. </paragraph><paragraph role="paragraph">The label next to the text box states the currently selected role. </paragraph></listitem><listitem><paragraph role="paragraph">Enter the range or click <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph><paragraph role="paragraph">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph></listitem></list><paragraph role="paragraph">The range for a data role, like Y-Values, must not include a label cell.</paragraph><paragraph role="heading" level="2">Editing categories or data labels</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Enter or select a cell range that will be used as text for categories or data labels. </paragraph></listitem></list><bookmark branch="hid/modules/schart/ui/tp_DataSource/tp_DataSource" id="bm_id1830"/><paragraph role="paragraph">Depending on the chart type, the texts are shown on the X axis or as data labels. </paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/LB_SERIES" id="bm_id1831"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows a list of all data series in the chart. Click an entry to view and edit that data series. Click <emph>Add</emph> to insert a new series into the list after the selected entry.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/LB_ROLE" id="bm_id6718649"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows all the data ranges used by the data series that is selected in the Data Series list box. Each data range shows the role name and the source range address.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/EDT_RANGE" id="bm_id1857051"/><bookmark branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_MAIN" id="bm_id8336741"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows the source range address from the second column of the Data Range list box. You can change the range in the text box or by dragging in the document. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/EDT_CATEGORIES" id="bm_id9499496"/><bookmark branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_CAT" id="bm_id4844508"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows the source range address of the categories (the texts you can see on the x-axis of a category chart). For an XY-chart, the text box contains the source range of the data labels which are displayed for the data points. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_ADD" id="bm_id5381328"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Adds a new entry below the current entry in the Data Series list. If an entry is selected, the new data series gets the same chart type.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_REMOVE" id="bm_id2036805"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Removes the selected entry from the Data Series list.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_UP" id="bm_id2141788"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Moves up the selected entry in the Data Series list.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_DOWN" id="bm_id5013885"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Moves down the selected entry in the Data Series list.</ahelp></paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X���� � text/schart/01/type_line.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Line</title><filename>/text/schart/01/type_line.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id2187566"/><paragraph role="heading" level="1"><variable id="type_line"><link href="text/schart/01/type_line.xhp">Chart Type Line</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Line</paragraph><paragraph role="paragraph">A line chart shows values as points on the y axis. The x axis shows categories. The y values of each data series can be connected by a line.</paragraph><paragraph role="paragraph">Points only - this subtype plots only points.</paragraph><paragraph role="paragraph">Points and lines - this subtype plots points and connects points of the same data series by a line.</paragraph><paragraph role="paragraph">Lines only - this subtype plots only lines.</paragraph><paragraph role="paragraph">3D lines - this subtype connects points of the same data series by a 3D line.</paragraph><paragraph role="paragraph">Mark <emph>Stack series</emph> to arrange the points' y values cumulative above each other. The y values no longer represent absolute values, except for the first column which is drawn at the bottom of the stacked points. If you select <emph>Percent</emph>, the y values are scaled as percentage of the category total.</paragraph><paragraph role="paragraph">Choose the <emph>Line type</emph> from the dropdown to select how the points will be connected. You can choose either <emph>Straight</emph> lines, <emph>Smooth</emph> lines to draw curves through the points or <emph>Stepped</emph> lines to draw lines which step from point to point. Click <emph>Properties</emph> to change the properties for the <link href="text/schart/01/smooth_line_properties.xhp">smooth</link> or <link href="text/schart/01/stepped_line_properties.xhp">stepped</link> lines.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X�E 9( ( text/schart/01/03010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data Table</title><filename>/text/schart/01/03010000.xhp</filename></topic></meta><body><section id="diagrammdaten"><bookmark branch="hid/.uno:DiagramData" id="bm_id3153771"/><bookmark branch="hid/modules/schart/ui/chartdatadialog/ChartDataDialog" id="bm_id3153772"/><paragraph role="heading" level="1"><link href="text/schart/01/03010000.xhp">Data Table</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DiagramData">Opens the<emph> Data Table </emph>dialog where you can edit the chart data.</ahelp></paragraph></section><paragraph role="paragraph">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.</paragraph><switch select="appl"><case select="WRITER"><paragraph role="paragraph"><link href="text/swriter/01/06990000.xhp">To update a chart manually when a Writer table got changed</link></paragraph></case></switch><paragraph role="note">Some changes will become visible only after you close and reopen the dialog.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#astdgd"/></section><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">To change chart data</paragraph><paragraph role="paragraph">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><paragraph role="paragraph">Close the Chart Data dialog to apply all changes to the chart. Choose <emph>Edit - Undo</emph> to cancel the changes.</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Insert or select a chart that is not based on existing cell data.</paragraph></listitem><listitem><paragraph role="paragraph">Choose <emph>View - Chart Data Table</emph> to open the Data Table dialog.</paragraph><paragraph role="paragraph">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></listitem><listitem><paragraph role="paragraph">Click a cell in the dialog and change the contents. Click another cell to see the changed contents in the preview.</paragraph></listitem><listitem><paragraph role="paragraph">Enter the name of the data series in the text box above the column.</paragraph></listitem><listitem><paragraph role="paragraph">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. </paragraph></listitem><listitem><paragraph role="paragraph">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.</paragraph></listitem><listitem><paragraph role="paragraph">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></listitem></list><bookmark branch="hid/modules/schart/ui/chartdatadialog/InsertRow" id="bm_id3154022"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a new row below the current row.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/InsertColumn" id="bm_id3152988"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a new data series after the current column.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/InsertTextColumn" id="bm_id3156022"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a new text column after the current column for hierarchical axes descriptions.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/RemoveRow" id="bm_id3150215"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the current row. It is not possible to delete the label row.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/RemoveColumn" id="bm_id3153959"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the current series or text column. It is not possible to delete the first text column.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/SwapColumn" id="bm_id8501846"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Switches the current column with its neighbor at the right.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/chartdatadialog/SwapRow" id="bm_id4469130"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Switches the current row with its neighbor below.</ahelp></paragraph><bookmark branch="hid/CHART2_HID_SCH_DATA_SERIES_LABEL" id="bm_id3522446"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter names for the data series.</ahelp></paragraph></body></helpdocument>
PK
w�Xc@��� � ! text/schart/01/wiz_data_range.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Wizard - Data Range</title><filename>/text/schart/01/wiz_data_range.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id2429578"/><paragraph role="heading" level="1"><variable id="wiz_data_range"><link href="text/schart/01/wiz_data_range.xhp">Chart Wizard - Data Range</link></variable></paragraph><paragraph role="paragraph">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can select one single source of data range. This range may consist of more than one rectangular range of cells.</paragraph><bookmark branch="hid/.uno:DataRanges" id="bm_id7543259"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens the Data Ranges dialog where you can edit Data Range and Data Series.</ahelp></paragraph><paragraph role="tip">Use the Chart Wizard - Data Series page if you need more control over the data ranges.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz_ranges"/></section><paragraph role="paragraph">This dialog is only available for charts based on a Calc or Writer table.</paragraph><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">To specify a data range</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Select the data range. Do one of the following:</paragraph><paragraph role="paragraph">Enter the data range in the text box.</paragraph><paragraph role="paragraph">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph><paragraph role="paragraph">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag over a cell area to select the data range.</paragraph><paragraph role="paragraph">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph></listitem><listitem><paragraph role="paragraph">Click one of the options for data series in rows or in columns.</paragraph></listitem><listitem><paragraph role="paragraph">Check whether the data range has labels in the first row or in the first column or both.</paragraph></listitem></list><paragraph role="paragraph">In the preview you can see how the final chart will look.</paragraph><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/ED_RANGE" id="bm_id2121951"/><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/IB_RANGE" id="bm_id4829554"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the data range that you want to include in your chart. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATAROWS" id="bm_id2901699"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Data series get their data from consecutive rows in the selected range. For scatter charts, the first data series will contain x-values for all series. All other data series are used as y-values, one for each series.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATACOLS" id="bm_id5534226"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Data series get their data from consecutive columns in the selected range. For scatter charts, the first data column will contain x-values for all series. All other data columns are used as y-values, one for each series.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_ROW_ASLABELS" id="bm_id49134"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">For data series in columns: The first row in the range is used as names for data series. For data series in rows: The first row in the range is used as categories. The remaining rows comprise the data series. If this check box is not selected, all rows are data series.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_COLUMN_ASLABELS" id="bm_id8939481"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">For data series in columns: The first column in the range is used as names for data series. For data series in rows: The first column in the range is used as categories. The remaining columns comprise the data columns. If this check box is not selected, all columns are data columns.</ahelp></paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X�3\K K text/schart/01/05020201.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Alignment</title><filename>/text/schart/01/05020201.xhp</filename></topic></meta><body><section id="ausrichtung"><bookmark branch="hid/modules/schart/ui/titlerotationtabpage/TitleRotationTabPage" id="bm_id8467056"/><bookmark branch="hid/modules/schart/ui/tp_axisLabel/AxisLabelTabPage" id="bm_id8467056"/><paragraph role="heading" level="1"><link href="text/schart/01/05020201.xhp">Alignment</link></paragraph><paragraph role="paragraph">Modifies the alignment of axes or title labels.</paragraph></section><paragraph role="paragraph">Some of the options listed here are not available for all labels. For example, there are different options for 2D and 3D object labels.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frttyab"/></section><bookmark branch="hid/modules/schart/ui/tp_axisLabel/showlabelsCB" id="bm_id8467055"/><paragraph role="heading" level="2">Show labels</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/showlabelsCB">Specifies whether to show or hide the axis labels.</ahelp></paragraph><bookmark branch="hid/.uno:ToggleAxisDescr" id="bm_id3150012"/><paragraph role="paragraph"><variable id="sytextbeschr"><ahelp hid=".uno:ToggleAxisDescr">The<emph> AxesTitle On/Off </emph>icon on the <emph>Formatting</emph> bar switches the labeling of all axes on or off.</ahelp></variable></paragraph><embed href="text/schart/00/00000004.xhp#achsenalle"/><section id="schreibr"><paragraph role="heading" level="2">Rotate text</paragraph><paragraph role="paragraph"><ahelp hid=".uno:ToggleAxisDescr">Defines the text direction of cell contents.</ahelp> Click one of the ABCD buttons to assign the required direction.</paragraph><bookmark branch="modules/schart/ui/titlerotationtabpage/dialCtrl" id="bm_id3145642"/><bookmark branch="modules/schart/ui/tp_axisLabel/dialCtrl" id="bm_id3145643"/><paragraph role="heading" level="3">ABCD wheel</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/titlerotationtabpage/dialCtrl">Clicking anywhere on the wheel defines the variable text orientation.</ahelp> The letters "ABCD" on the button correspond to the new setting.</paragraph><bookmark branch="hid/modules/schart/ui/titlerotationtabpage/stackedCB" id="bm_id3149255"/><bookmark branch="hid/modules/schart/ui/tp_axisLabel/stackedCB" id="bm_id3149256"/><paragraph role="heading" level="3">ABCD button</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/titlerotationtabpage/stackedCB">Assigns vertical text orientation for cell contents.</ahelp></paragraph><paragraph role="note">If you define a vertical x-axis label, the text may be cut off by the line of the x-axis.</paragraph><bookmark branch="hid/modules/schart/ui/titlerotationtabpage/OrientDegree" id="bm_id3150371"/><bookmark branch="hid/modules/schart/ui/tp_axisLabel/OrientDegree" id="bm_id3150372"/><paragraph role="heading" level="3">Degrees</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/titlerotationtabpage/OrientDegree">Allows you to manually enter the orientation angle.</ahelp></paragraph></section><paragraph role="heading" level="2">Text flow</paragraph><paragraph role="paragraph">Determines the text flow of the data label.</paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/overlapCB" id="bm_id9935911"/><paragraph role="heading" level="3">Overlap</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/overlapCB">Specifies that the text in cells may overlap other cells.</ahelp> This can be especially useful if there is a lack of space. This option is not available with different title directions.</paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/breakCB" id="bm_id4753868"/><paragraph role="heading" level="3">Break</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/breakCB">Allows a text break.</ahelp></paragraph><paragraph role="heading" level="3">The following options are not available for all chart types:</paragraph><paragraph role="heading" level="2">Order</paragraph><paragraph role="paragraph">The options on this tab are only available for a 2D chart, under <emph>Format - Axis - Y Axis</emph> or <emph>X Axis</emph>. In this area, you can define the alignment of the number labels on the X or Y axis.</paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/tile" id="bm_id4744407"/><paragraph role="heading" level="3">Tile</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/tile">Arranges numbers on the axis side by side.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/odd" id="bm_id6054261"/><paragraph role="heading" level="3">Stagger odd</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/odd">Staggers numbers on the axis, even numbers lower than odd numbers.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/even" id="bm_id2744224"/><paragraph role="heading" level="3">Stagger even</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/even">Stagger numbers on the axes, odd numbers lower than even numbers.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_axisLabel/auto" id="bm_id9631946"/><paragraph role="heading" level="3">Automatic</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_axisLabel/auto">Automatically arranges numbers on the axis.</ahelp></paragraph><paragraph role="note">Problems may arise in displaying labels if the size of your chart is too small. You can avoid this by either enlarging the view or decreasing the font size.</paragraph><bookmark branch="hid/modules/schart/ui/titlerotationtabpage/textdirLB" id="bm_id110620080215497"/><bookmark branch="hid/modules/schart/ui/tp_axisLabel/textdirLB" id="bm_id1110200804243271"/><paragraph role="heading" level="3">Text Direction</paragraph><paragraph role="paragraph"><ahelp hid=".">Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.</ahelp></paragraph></body></helpdocument>
PK
w�X(z��q q text/schart/01/05040200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Y Axis</title><filename>/text/schart/01/05040200.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3145673"/><bookmark branch="hid/.uno:DiagramAxisY" id="bm_id3148491"/><paragraph role="heading" level="1">Y Axis</paragraph><paragraph role="paragraph"><variable id="yachse"><ahelp hid=".uno:DiagramAxisY">Opens the<emph> Y Axis </emph>dialog, to change properties of the Y axis.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtyas"/></section><embed href="text/shared/01/05200100.xhp#linie"/><paragraph role="heading" level="2"><link href="text/shared/01/05020100.xhp">Character</link></paragraph><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/05040201.xhp#skalierung"/><embed href="text/schart/01/05040202.xhp#positioning"/><paragraph role="heading" level="2"><link href="text/shared/01/05020300.xhp">Numbers</link></paragraph><embed href="text/shared/01/05020300.xhp#zahlen"/><embed href="text/schart/01/05020201.xhp#ausrichtung"/></body></helpdocument>
PK
w�X��4b� � text/schart/01/05120000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Arrangement</title><filename>/text/schart/01/05120000.xhp</filename></topic></meta><body><section id="anordnung"><paragraph role="heading" level="1"><link href="text/schart/01/05120000.xhp">Arrangement</link></paragraph><paragraph role="paragraph">Allows you to modify the order of the data series already set in the chart.</paragraph></section><paragraph role="paragraph">The position of the data in the data table remains unchanged. You can only choose the commands after inserting a chart in $[officename] Calc.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#anordnung"/></section><paragraph role="warning">This function is only available if you have data displayed in columns. It is not possible to switch to data display in rows.</paragraph><paragraph role="heading" level="2">Bring Forward</paragraph><paragraph role="paragraph"><ahelp hid=".uno:Forward">Brings the selected data series forward (to the right).</ahelp></paragraph><paragraph role="heading" level="2">Send Backward</paragraph><paragraph role="paragraph"><ahelp hid=".uno:Backward">Sends the selected data series backward (to the left).</ahelp></paragraph></body></helpdocument>
PK
w�X6Yͬ� � text/schart/01/type_pie.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Pie </title><filename>/text/schart/01/type_pie.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id7621997"/><paragraph role="heading" level="1"><variable id="type_pie"><link href="text/schart/01/type_pie.xhp">Chart Type Pie</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Pie</paragraph><paragraph role="paragraph">A pie chart shows values as circular sectors of the total circle. The length of the arc, or the area of each sector, is proportional to its value.</paragraph><paragraph role="paragraph">Pie - this subtype shows sectors as colored areas of the total pie, for one data column only. In the created chart, you can click and drag any sector to separate that sector from the remaining pie or to join it back.</paragraph><paragraph role="paragraph">Exploded pie - this subtype shows the sectors already separated from each other. In the created chart, you can click and drag any sector to move it along a radial from the pie's center.</paragraph><paragraph role="paragraph">Donut - this subtype can show multiple data columns. Each data column is shown as one donut shape with a hole inside, where the next data column can be shown. In the created chart, you can click and drag an outer sector to move it along a radial from the donut's center.</paragraph><paragraph role="paragraph">Exploded donut - this subtype shows the outer sectors already separated from the remaining donut. In the created chart, you can click and drag an outer sector to move it along a radial from the donut's center.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X6h � $ text/schart/01/choose_chart_type.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Choosing a Chart Type</title><filename>/text/schart/01/choose_chart_type.xhp</filename></topic></meta><body><paragraph role="heading" level="1"><variable id="choose_chart_type"><link href="text/schart/01/choose_chart_type.xhp">Choosing a Chart Type</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">The available chart types</paragraph><paragraph role="paragraph">Choose from the following chart types, depending on data type and intended presentation effect.</paragraph><table><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/columns_52x60.png"/> and
<image src="chart2/res/bar_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_column_bar.xhp">Column or Bar</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/pie_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_pie.xhp">Pie</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/areas_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_area.xhp">Area</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/nostackdirectboth_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_line.xhp">Line</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/valueaxisdirectpoints_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_xy.xhp">XY (scatter)</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/bubble_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_bubble.xhp">Bubble</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/net_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_net.xhp">Net</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/stock_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_stock.xhp">Stock</link></paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent"><image src="chart2/res/columnline_52x60.png"/></paragraph></tablecell><tablecell><paragraph role="tablecontent"><link href="text/schart/01/type_column_line.xhp">Column and Line</link></paragraph></tablecell></tablerow></table><paragraph role="paragraph"> </paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X� �� � text/schart/01/05040201.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Scale</title><filename>/text/schart/01/05040201.xhp</filename></topic></meta><body><section id="skalierung"><bookmark branch="index" id="bm_id3150868"/><paragraph role="heading" level="1"><link href="text/schart/01/05040201.xhp">Scale</link></paragraph><paragraph role="paragraph">Controls the scaling of the X or Y axis.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtysk"/></section><paragraph role="paragraph">The axes are automatically scaled by $[officename] so that all values are optimally displayed.</paragraph><paragraph role="paragraph">To achieve specific results, you can manually change the axis scaling. For example, you can display only the top areas of the columns by shifting the zero line upwards.</paragraph><paragraph role="heading" level="2">Scale</paragraph><paragraph role="paragraph">You can enter values for subdividing axes in this area. You can automatically set the properties <emph>Minimum, Maximum, Major interval, Minor interval count</emph> and <emph>Reference value</emph>.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/EDT_MIN" id="bm_id2984710"/><paragraph role="heading" level="3">Minimum</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/EDT_MIN">Defines the minimum value for the beginning of the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/EDT_MAX" id="bm_id2057252"/><paragraph role="heading" level="3">Maximum</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/EDT_MAX">Defines the maximum value for the end of the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/EDT_STEP_MAIN" id="bm_id6926786"/><paragraph role="heading" level="3">Major interval</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/EDT_STEP_MAIN">Defines the interval for the main division of the axes.</ahelp> The main interval cannot be larger than the value area.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/MT_STEPHELP" id="bm_id8941618"/><paragraph role="heading" level="3">Minor interval count</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/MT_STEPHELP">Defines the interval for the subdivision of the axes.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/EDT_ORIGIN" id="bm_id6544083"/><paragraph role="heading" level="3">Reference value</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/EDT_ORIGIN">Specifies at which position to display the values along the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_MIN" id="bm_id1964476"/><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_MAX" id="bm_id1011688"/><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_STEP_MAIN" id="bm_id708639"/><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_STEP_HELP" id="bm_id5169225"/><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_ORIGIN" id="bm_id6670125"/><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_AUTO_TIME_RESOLUTION" id="bm_id10087605190759"/><paragraph role="heading" level="3">Automatic</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/CBX_AUTO_ORIGIN">You must first deselect the <emph>Automatic</emph> option in order to modify the values.</ahelp></paragraph><paragraph role="note">Disable this feature if you are working with "fixed" values, as it does not permit automatic scaling.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_LOGARITHM" id="bm_id2118594"/><paragraph role="heading" level="3">Logarithmic scale</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_Scale/CBX_LOGARITHM">Specifies that you want the axis to be subdivided logarithmically.</ahelp></paragraph><paragraph role="note">Use this feature if you are working with values that differ sharply from each other. You can use logarithmic scaling to make the grid lines of the axis equidistant but have values that may increase or decrease.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/CBX_REVERSE" id="bm_id109575190759"/><paragraph role="heading" level="3">Reverse direction</paragraph><paragraph role="paragraph"><ahelp hid=".">Defines where the lower and where the higher values are displayed at the axis. The unchecked state is the mathematical direction.</ahelp> That means for Cartesian coordinate systems that the x-axis shows the lower values on the left and the y-axis shows the lower values at the bottom. For polar coordinate systems the mathematical angle axis direction is counterclockwise and the radial axis is from inner to outer.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/LB_AXIS_TYPE" id="bm_id10022759"/><paragraph role="heading" level="3">Type</paragraph><paragraph role="paragraph"><ahelp hid=".">For some types of axes, you can select to format an axis as text or date, or to detect the type automatically.</ahelp> For the axis type "Date" you can set the following options.</paragraph><paragraph role="paragraph">Minimum and maximum value to be shown on the ends of the scale.</paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/LB_TIME_RESOLUTION" id="bm_id1344759"/><paragraph role="paragraph"><ahelp hid=".">Resolution can be set to show days, months, or years as interval steps.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/MT_MAIN_DATE_STEP" id="bm_id2210022759"/><bookmark branch="hid/modules/schart/ui/tp_Scale/LB_MAIN_TIME_UNIT" id="bm_id1033022759"/><paragraph role="paragraph"><ahelp hid=".">Major interval can be set to show a certain number of days, months, or years.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Scale/LB_HELP_TIME_UNIT" id="bm_id1472759"/><paragraph role="paragraph"><ahelp hid=".">Minor interval can be set to show a certain number of days, months, or years.</ahelp></paragraph></body></helpdocument>
PK
w�X�ג�� � ) text/schart/01/smooth_line_properties.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Smooth Line Properties</title><filename>/text/schart/01/smooth_line_properties.xhp</filename></topic></meta><body><bookmark branch="hid/modules/schart/ui/smoothlinesdlg/SmoothLinesDialog" id="bm_id1593677"/><bookmark branch="index" id="bm_id3803827"/><paragraph role="heading" level="1">Smooth Line Properties</paragraph><paragraph role="paragraph">In a chart that displays lines (Line type or XY type), you can choose to show curves instead of straight lines. Some options control the properties of those curves.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#stlp"/></section><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">To change line properties</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Select Cubic Spline or B-Spline.</paragraph><paragraph role="paragraph">These are mathematical models that influence the display of the curves. The curves are created by joining together segments of polynomials.</paragraph></listitem><listitem><paragraph role="paragraph">Optionally set the resolution. A higher value leads to a smoother line.</paragraph></listitem><listitem><paragraph role="paragraph">For B-spline lines optionally set the degree of the polynomials.</paragraph></listitem></list><bookmark branch="hid/modules/schart/ui/smoothlinesdlg/SplineTypeComboBox" id="bm_id1593676"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Apply a line curve model.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/smoothlinesdlg/ResolutionSpinbutton" id="bm_id9044770"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Set the resolution.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/smoothlinesdlg/PolynomialsSpinButton" id="bm_id3674123"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Set the degree of the polynomials.</ahelp></paragraph></body></helpdocument>
PK
w�X>t��� � text/schart/01/05050000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Grid</title><filename>/text/schart/01/05050000.xhp</filename></topic></meta><body><section id="gitter"><bookmark branch="index" id="bm_id3155602"/><paragraph role="heading" level="1"><link href="text/schart/01/05050000.xhp">Grid</link></paragraph><paragraph role="paragraph">Opens a submenu, where you select the grid you want to format.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtgt"/></section><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">X Axis Major Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">Y Axis Major Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">Z Axis Major Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">X Axis Minor Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">Y Axis Minor Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">Z Axis minor Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">All Axis Grids</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X�|�>� � text/schart/01/05020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Title</title><filename>/text/schart/01/05020000.xhp</filename></topic></meta><body><section id="titel"><bookmark branch="index" id="bm_id3150791"/><paragraph role="heading" level="1"><link href="text/schart/01/05020000.xhp">Title</link></paragraph><paragraph role="paragraph">The<emph> Title </emph>menu command opens a submenu for editing the properties of the titles in the chart.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtttl"/></section><paragraph role="heading" level="2"><link href="text/schart/01/05020100.xhp">Main title</link></paragraph><embed href="text/schart/01/05020100.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05020100.xhp">Subtitle</link></paragraph><embed href="text/schart/01/05020100.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05020100.xhp">X-axis title</link></paragraph><embed href="text/schart/01/05020100.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05020200.xhp">Y-axis title</link></paragraph><embed href="text/schart/01/05020200.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05020100.xhp">Z-axis title</link></paragraph><embed href="text/schart/01/05020100.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05020200.xhp">All titles</link></paragraph><embed href="text/schart/01/05020200.xhp#titel"/></body></helpdocument>
PK
w�X-7 7 text/schart/01/04030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data Labels </title><filename>/text/schart/01/04030000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150275"/><bookmark branch="hid/.uno:InsertMenuDataLabels" id="bm_id3144510"/><bookmark branch="hid/modules/schart/ui/tp_DataLabel/tp_DataLabel" id="bm_id3144511"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/dlg_DataLabels" id="bm_id3144511"/><section id="datalabels"><paragraph role="heading" level="1"><variable id="datenbeschriftung"><link href="text/schart/01/04030000.xhp">Data Labels</link></variable></paragraph><paragraph role="paragraph"><variable id="besch"><ahelp hid=".uno:InsertMenuDataLabels">Opens the<emph> Data Labels </emph>dialog, which enables you to set the data labels.</ahelp></variable></paragraph></section><section id="context"><paragraph role="paragraph">If an element of a data series is selected, this command works on that data series only. If no element is selected, this command works on all data series.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efgdbs"/></section><bookmark branch="hid/modules/schart/ui/tp_DataLabel/CB_VALUE_AS_NUMBER" id="bm_id901517"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/CB_VALUE_AS_NUMBER" id="bm_id8825342"/><paragraph role="heading" level="2">Show value as number</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_DataLabel/CB_VALUE_AS_NUMBER">Displays the absolute values of the data points.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/PB_NUMBERFORMAT" id="bm_id1717276"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/PB_NUMBERFORMAT" id="bm_id1717277"/><paragraph role="heading" level="2">Number format</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens a dialog to select the number format.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/CB_VALUE_AS_PERCENTAGE" id="bm_id9111912"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/CB_VALUE_AS_PERCENTAGE" id="bm_id9111911"/><paragraph role="heading" level="2">Show value as percentage</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_DataLabel/CB_VALUE_AS_PERCENTAGE">Displays the percentage of the data points in each column.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/PB_PERCENT_NUMBERFORMAT" id="bm_id381482"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/PB_PERCENT_NUMBERFORMAT" id="bm_id381481"/><paragraph role="heading" level="2">Percentage format</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens a dialog to select the percentage format.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/CB_CATEGORY" id="bm_id3015534"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/CB_CATEGORY" id="bm_id3015533"/><paragraph role="heading" level="2">Show category</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_DataLabel/CB_CATEGORY">Shows the data point text labels.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/CB_SYMBOL" id="bm_id2496108"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/CB_SYMBOL" id="bm_id2496109"/><paragraph role="heading" level="2">Show legend key</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_DataLabel/CB_SYMBOL">Displays the legend icons next to each data point label.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/LB_TEXT_SEPARATOR" id="bm_id6416821"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/LB_TEXT_SEPARATOR" id="bm_id6416822"/><paragraph role="heading" level="2">Separator</paragraph><paragraph role="paragraph"><ahelp hid=".">Selects the separator between multiple text strings for the same object.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/LB_LABEL_PLACEMENT" id="bm_id110620081228357"/><bookmark branch="hid//modules/schart/ui/dlg_DataLabel/LB_LABEL_PLACEMENT" id="bm_id110620081228356"/><paragraph role="heading" level="2">Placement</paragraph><paragraph role="paragraph"><ahelp hid=".">Selects the placement of data labels relative to the objects.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/LB_LABEL_TEXTDIR" id="bm_id1106200812295486"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/LB_LABEL_TEXTDIR" id="bm_id1106200812295487"/><paragraph role="heading" level="2">Text Direction</paragraph><paragraph role="paragraph"><ahelp hid=".">Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/CT_DIAL" id="bm_id100720090156525"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/CT_DIAL" id="bm_id100720090156524"/><paragraph role="heading" level="2">Rotate Text</paragraph><paragraph role="paragraph"><ahelp hid=".">Click in the dial to set the text orientation for the data labels.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_DataLabel/NF_LABEL_DEGREES" id="bm_id1007200901571849"/><bookmark branch="hid/modules/schart/ui/dlg_DataLabel/NF_LABEL_DEGREES" id="bm_id1007200901571850"/><paragraph role="paragraph"><ahelp hid=".">Enter the counterclockwise rotation angle for the data labels.</ahelp></paragraph></body></helpdocument>
PK
w�X�z}�G G text/schart/01/05050100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Grid</title><filename>/text/schart/01/05050100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150398"/><bookmark branch="hid/.uno:DiagramGridXMain" id="bm_id3154684"/><bookmark branch="hid/.uno:DiagramGridYMain" id="bm_id3150439"/><bookmark branch="hid/.uno:DiagramGridZMain" id="bm_id3149260"/><bookmark branch="hid/.uno:DiagramGridXHelp" id="bm_id3154319"/><bookmark branch="hid/.uno:DiagramGridYHelp" id="bm_id3147434"/><bookmark branch="hid/.uno:DiagramGridZHelp" id="bm_id3153142"/><bookmark branch="hid/.uno:DiagramGridAll" id="bm_id3148575"/><paragraph role="heading" level="1">Grid</paragraph><paragraph role="paragraph"><variable id="gitter"><ahelp hid=".uno:DiagramGridAll">Opens the <emph>Grid</emph> dialog for defining grid properties.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtgtr"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X���ã
�
text/schart/01/04010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Titles</title><filename>/text/schart/01/04010000.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:InsertMenuTitles" id="bm_id3146313"/><paragraph role="heading" level="1">Titles</paragraph><paragraph role="paragraph"><variable id="titel"><ahelp hid=".uno:InsertMenuTitles">Opens a dialog to enter or modify the titles in a chart.</ahelp></variable> You can define the text for the main title, subtitle and the axis labels, and specify if they are displayed.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efgttl"/></section><paragraph role="heading" level="2">Main Title</paragraph><paragraph role="paragraph"><ahelp hid="SCH:EDIT:DLG_TITLE:EDT_MAINTITLE">Marking the <emph>Main Title</emph> option activates the main title. Enter the desired title in the corresponding text field.</ahelp></paragraph><paragraph role="heading" level="2">Subtitle</paragraph><paragraph role="paragraph"><ahelp hid="SCH:EDIT:DLG_TITLE:EDT_SUBTITLE">Marking the <emph>Subtitle</emph> option activates the subtitle. Enter the desired title in the corresponding text field.</ahelp></paragraph><bookmark branch="hid/.uno:ToggleTitle" id="bm_id3148870"/><paragraph role="paragraph"><variable id="sytexttitel"><ahelp hid=".uno:ToggleTitle">Click <emph>Title On/Off</emph> on the Formatting bar to show or hide the title and subtitle.</ahelp></variable></paragraph><embed href="text/schart/00/00000004.xhp#titelanaus"/><paragraph role="heading" level="2">X axis</paragraph><paragraph role="paragraph"><ahelp hid="SCH:EDIT:DLG_TITLE:EDT_X_AXIS">Marking the <emph>X axis</emph> option activates the X axis title. Enter the desired title in the corresponding text field.</ahelp></paragraph><paragraph role="heading" level="2">Y axis</paragraph><paragraph role="paragraph"><ahelp hid="SCH:EDIT:DLG_TITLE:EDT_Y_AXIS">Marking the <emph>Y axis</emph> option activates the Y axis title. Enter the desired title in the corresponding text field.</ahelp></paragraph><paragraph role="heading" level="2">Z axis</paragraph><paragraph role="paragraph"><ahelp hid="SCH:EDIT:DLG_TITLE:EDT_Z_AXIS">Marking the <emph>Z axis</emph> option activates the Z axis title. Enter the desired title in the corresponding text field.</ahelp> This option is only available for 3-D charts.</paragraph><bookmark branch="hid/.uno:ToggleAxisTitle" id="bm_id3149054"/><paragraph role="paragraph"><variable id="sytextachse"><ahelp hid=".uno:ToggleAxisTitle">Click <emph>Axes Title On/Off</emph> on the Formatting bar to show or hide the axis labels.</ahelp></variable></paragraph><embed href="text/schart/00/00000004.xhp#achseeinaus"/></body></helpdocument>
PK
w�X�U㻽 � text/schart/01/05060000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Wall</title><filename>/text/schart/01/05060000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150792"/><bookmark branch="hid/.uno:DiagramWall" id="bm_id3148798"/><paragraph role="heading" level="1">Chart Wall</paragraph><paragraph role="paragraph"><variable id="diagramm"><ahelp visibility="visible" hid=".uno:DiagramWall">Opens the<emph> Chart Wall</emph> dialog, where you can modify the properties of the chart wall. The chart wall is the "vertical" background behind the data area of the chart.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtdgw"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X��� � text/schart/01/05010200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data Series</title><filename>/text/schart/01/05010200.xhp</filename></topic></meta><body><section id="datenreihe"><paragraph role="heading" level="1"><link href="text/schart/01/05010200.xhp">Data Series</link></paragraph><paragraph role="paragraph">Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose <emph>Format - Format Selection</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph></section><paragraph role="note">Any changes made here affect the entire data series. For example, if you change the color, all elements belonging to this data series will change color.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtodr"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><embed href="text/shared/01/05020100.xhp#zeichen"/><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/04030000.xhp#datalabels"/><paragraph role="heading" level="2"><link href="text/schart/01/04050000.xhp">Y Error Bars</link></paragraph><embed href="text/schart/01/04050000.xhp#statistik"/><embed href="text/schart/01/04060000.xhp#optionen"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X��؇� � text/schart/01/05040202.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Positioning</title><filename>/text/schart/01/05040202.xhp</filename></topic></meta><body><section id="positioning"><bookmark branch="index" id="bm_id3150869"/><paragraph role="heading" level="1"><link href="text/schart/01/05040202.xhp">Positioning</link></paragraph><paragraph role="paragraph">Controls the positioning of the axis.</paragraph></section><section id="howtoget"><embed href="text/schart/00/00000004.xhp#positioning"/></section><paragraph role="heading" level="2">Axis line</paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/LB_CROSSES_OTHER_AXIS_AT" id="bm_id1006200812484446"/><paragraph role="paragraph"><ahelp hid=".">Select where to cross the other axis: at start, at end, at a specified value, or at a category.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/EDT_CROSSES_OTHER_AXIS_AT" id="bm_id1006200805121926"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the value where the axis line should cross the other axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/EDT_CROSSES_OTHER_AXIS_AT_CATEGORY" id="bm_id1006200805134034"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select the category where the axis line should cross the other axis.</ahelp></paragraph><paragraph role="heading" level="2">Labels</paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/LB_PLACE_LABELS" id="bm_id1006200805141692"/><paragraph role="heading" level="3">Place labels</paragraph><paragraph role="paragraph"><ahelp hid=".">Select where to place the labels: near axis, near axis (other side), outside start, or outside end.</ahelp></paragraph><paragraph role="heading" level="2">Interval marks</paragraph><paragraph role="heading" level="3">Major:</paragraph><paragraph role="paragraph">Specifies whether the marks are to be on the inner or outer side of the axis. It is possible to combine both: you will then see marks on both sides.</paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/CB_TICKS_INNER" id="bm_id1006200805150554"/><paragraph role="heading" level="3">Inner</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_AxisPositions/CB_TICKS_INNER">Specifies that marks are placed on the inner side of the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/CB_TICKS_OUTER" id="bm_id100620080515253"/><paragraph role="heading" level="3">Outer</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_AxisPositions/CB_TICKS_OUTER">Specifies that marks are placed on the outer side of the axis.</ahelp></paragraph><paragraph role="heading" level="2">Minor:</paragraph><paragraph role="paragraph">This area is used to define the marking dashes between the axis marks. It is possible to activate both fields. This will result in a marking line running from the outside to the inside.</paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/CB_MINOR_INNER" id="bm_id100620080515528"/><paragraph role="heading" level="3">Inner</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_AxisPositions/CB_MINOR_INNER">Specifies that minor interval marks are placed on the inner side of the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/CB_MINOR_OUTER" id="bm_id1006200805160860"/><paragraph role="heading" level="3">Outer</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_AxisPositions/CB_MINOR_OUTER">Specifies that minor interval marks are placed on the outer side of the axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_AxisPositions/LB_PLACE_TICKS" id="bm_id1006200805165355"/><paragraph role="heading" level="3">Place marks</paragraph><paragraph role="paragraph"><ahelp hid=".">Select where to place the marks: at labels, at axis, or at axis and labels.</ahelp></paragraph></body></helpdocument>
PK
w�X����g g text/schart/01/05010000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Format Selection</title><filename>/text/schart/01/05010000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3149666"/><bookmark branch="hid/.uno:FormatSelection" id="bm_id3147436"/><paragraph role="heading" level="1">Format Selection</paragraph><paragraph role="paragraph"><variable id="objekteigenschaften"><ahelp hid=".">Formats the selected object.</ahelp></variable> Depending on the object selected, the command opens dialogs that you can also open by choosing the following commands from the <emph>Format</emph> menu:</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtoes"/></section><paragraph role="heading" level="2"><link href="text/schart/01/05060000.xhp">Chart Wall</link></paragraph><embed href="text/schart/01/05060000.xhp#diagramm"/><paragraph role="heading" level="2"><link href="text/schart/01/05080000.xhp">Chart Area</link></paragraph><embed href="text/schart/01/05080000.xhp#diagrammflaeche"/><paragraph role="heading" level="2"><link href="text/schart/01/05070000.xhp">Chart Floor</link></paragraph><embed href="text/schart/01/05070000.xhp#diagrammboden"/><paragraph role="heading" level="2"><link href="text/schart/01/05020100.xhp">Title</link></paragraph><embed href="text/schart/01/05020100.xhp#titel"/><paragraph role="heading" level="2"><link href="text/schart/01/05030000.xhp">Legend</link></paragraph><embed href="text/schart/01/05030000.xhp#legende"/><paragraph role="heading" level="2"><link href="text/schart/01/05040100.xhp">X Axis</link></paragraph><embed href="text/schart/01/05040100.xhp#achsen"/><paragraph role="heading" level="2"><link href="text/schart/01/05040200.xhp">Y Axis</link></paragraph><embed href="text/schart/01/05040200.xhp#yachse"/><paragraph role="heading" level="2"><link href="text/schart/01/05050100.xhp">Grid</link></paragraph><embed href="text/schart/01/05050100.xhp#gitter"/><embed href="text/schart/01/05010100.xhp#datenpunkt"/><embed href="text/schart/01/05010200.xhp#datenreihe"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X�E�� � % text/schart/01/wiz_chart_elements.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Wizard - Chart Elements</title><filename>/text/schart/01/wiz_chart_elements.xhp</filename></topic></meta><body><paragraph role="heading" level="1"><variable id="wiz_chart_elements"><link href="text/schart/01/wiz_chart_elements.xhp">Chart Wizard - Chart Elements</link></variable></paragraph><paragraph role="paragraph">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose the chart elements to be shown.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><bookmark branch="hid/modules/schart/ui/wizelementspage/maintitle" id="bm_id5977050"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a title for your chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/subtitle" id="bm_id1355937"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a subtitle for your chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/primaryXaxis" id="bm_id3793145"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a label for the x-axis (horizontal).</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/primaryYaxis" id="bm_id1741996"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a label for the y-axis (vertical).</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/primaryZaxis" id="bm_id9927365"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a label for the z-axis. This option is only available for three-dimensional charts.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/show" id="bm_id9610889"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays a legend in your chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/left" id="bm_id2193449"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Positions the legend to the left of the chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/top" id="bm_id8514053"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Positions the legend to the top of the chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/right" id="bm_id5466721"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Positions the legend to the right of the chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/bottom" id="bm_id446570"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Positions the legend to the bottom of the chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/x" id="bm_id8159123"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the x-axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/y" id="bm_id2890102"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the y-axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/z" id="bm_id5801568"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the z-axis. This option is only available for three-dimensional charts.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/secondaryXaxis" id="bm_id2484817"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a label for the secondary x-axis. This option is only available for charts that support a secondary x-axis.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/wizelementspage/secondaryXaxis" id="bm_id2484819"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter a label for the secondary y-axis. This option is only available for charts that support a secondary y-axis.</ahelp></paragraph><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">To enter chart elements</paragraph><paragraph role="paragraph">Enter titles or click the elements that you want to be shown on the current chart.</paragraph><paragraph role="heading" level="3">Titles</paragraph><paragraph role="paragraph">If you enter text for a title, subtitle, or any axis, the necessary space will be reserved to display the text next to the chart. If you do not enter a text, no space will be reserved, leaving more space to display the chart.</paragraph><paragraph role="paragraph">It is not possible to link the title text to a cell. You must enter the text directly.</paragraph><paragraph role="paragraph">When the chart is finished, you can change the position and other properties by the <emph>Format</emph> menu.</paragraph><paragraph role="heading" level="3">Legend</paragraph><paragraph role="paragraph">The legend displays the labels from the first row or column, or from the range that you have set in the Data Series dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.</paragraph><paragraph role="paragraph">You cannot enter the text directly, it is automatically generated from the Name cell range.</paragraph><paragraph role="paragraph">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph><paragraph role="heading" level="3">Grids</paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the x-axis.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the y-axis.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays grid lines that are perpendicular to the z-axis. This option is only available for three-dimensional charts.</ahelp></paragraph><paragraph role="paragraph">The visible grid lines can help to estimate the data values in the chart.</paragraph><paragraph role="paragraph">The distance of the grid lines corresponds to the interval settings in the Scale tab of the axis properties.</paragraph><paragraph role="paragraph">Grid lines are not available for pie charts.</paragraph><paragraph role="heading" level="2">Additional elements</paragraph><paragraph role="paragraph">For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Secondary axes</paragraph></listitem><listitem><paragraph role="paragraph">Minor grids</paragraph></listitem><listitem><paragraph role="paragraph">Data labels</paragraph></listitem><listitem><paragraph role="paragraph">Statistics, for example mean values, y error bars and trend lines</paragraph></listitem></list><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/></section></body></helpdocument>
PK
w�X=Q݉� � text/schart/01/04020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Legend</title><filename>/text/schart/01/04020000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3156441"/><bookmark branch="hid/.uno:InsertMenuLegend" id="bm_id3149667"/><paragraph role="heading" level="1">Legend</paragraph><paragraph role="paragraph"><variable id="legende"><ahelp hid=".uno:InsertMenuLegend">Opens the <emph>Legend </emph>dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efglgd"/></section><bookmark branch="hid/.uno:ToggleLegend" id="bm_id3150328"/><paragraph role="paragraph"><variable id="sytextlegende"><ahelp hid=".uno:ToggleLegend">To show or hide a legend, click <emph>Legend On/Off</emph> on the <emph>Formatting</emph> bar.</ahelp></variable></paragraph><section id="sylegende"><table><tablerow><tablecell><paragraph role="paragraph"><image src="cmd/sc_togglelegend.png"/></paragraph></tablecell><tablecell><paragraph role="paragraph">Legend On/Off</paragraph></tablecell></tablerow></table></section><bookmark branch="hid/modules/schart/ui/wizelementspage/show" id="bm_id1106200811535390"/><paragraph role="heading" level="3">Display</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/wizelementspage/show">Specifies whether to display a legend for the chart.</ahelp> This option is only visible if you call the dialog by choosing <emph>Insert - Legend</emph>.</paragraph><paragraph role="heading" level="2">Position</paragraph><paragraph role="paragraph">Select the position for the legend:</paragraph><bookmark branch="modules/schart/ui/tp_LegendPosition/left" id="bm_id1106200811535391"/><bookmark branch="hid/modules/schart/ui/wizelementspage/left" id="bm_id1106200811535392"/><paragraph role="heading" level="3">Left</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_LegendPosition/left">Positions the legend at the left of the chart.</ahelp></paragraph><bookmark branch="modules/schart/ui/tp_LegendPosition/top" id="bm_id1106200811535393"/><bookmark branch="hid/modules/schart/ui/wizelementspage/top" id="bm_id8514053"/><paragraph role="heading" level="3">Top</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_LegendPosition/top">Positions the legend at the top of the chart.</ahelp></paragraph><bookmark branch="modules/schart/ui/tp_LegendPosition/right" id="bm_id1106200811535394"/><bookmark branch="hid/modules/schart/ui/wizelementspage/right" id="bm_id5492721"/><paragraph role="heading" level="3">Right</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_LegendPosition/right">Positions the legend at the right of the chart.</ahelp></paragraph><bookmark branch="modules/schart/ui/tp_LegendPosition/bottom" id="bm_id1106200811535395"/><bookmark branch="hid/modules/schart/ui/wizelementspage/bottom" id="bm_id445570"/><paragraph role="heading" level="3">Bottom</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_LegendPosition/bottom">Positions the legend at the bottom of the chart.</ahelp></paragraph><paragraph role="heading" level="2">Text Orientation</paragraph><paragraph role="paragraph">This feature is only available if complex text layout support is enabled in <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - Language settings - Languages</item>.</paragraph><bookmark branch="hid/modules/schart/ui/tp_LegendPosition/LB_LEGEND_TEXTDIR" id="bm_id1106200812070599"/><paragraph role="heading" level="3">Text Direction</paragraph><paragraph role="paragraph"><ahelp hid=".">Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.</ahelp></paragraph></body></helpdocument>
PK
w�XPE�D� � text/schart/01/05020101.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Alignment</title><filename>/text/schart/01/05020101.xhp</filename></topic></meta><body><section id="ausricht"><bookmark branch="index" id="bm_id3150793"/><paragraph role="heading" level="1"><link href="text/schart/01/05020101.xhp">Alignment</link></paragraph><paragraph role="paragraph">Modifies the alignment of the chart title.</paragraph></section><paragraph role="paragraph">Some of the options are not available for all types of labels. For example, there are different options for 2D and 3D object labels.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frttya"/></section><embed href="text/schart/01/05020201.xhp#schreibr"/><paragraph role="note">Please note that problems may arise in displaying labels if the size of your chart is too small. You can avoid this by either enlarging the view or decreasing the font size.</paragraph></body></helpdocument>
PK
w�X^�B� � * text/schart/01/stepped_line_properties.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Smooth Line Properties</title><filename>/text/schart/01/stepped_line_properties.xhp</filename></topic></meta><body><bookmark branch="hid/modules/schart/ui/steppedlinesdlg/SteppedLinesDialog" id="bm_id1738954"/><bookmark branch="index" id="bm_id1467210"/><paragraph role="heading" level="1">Stepped Line Properties</paragraph><paragraph role="paragraph">In a chart that displays lines (Line type or XY type), you can choose to connect the points with steps instead of straight lines. Some options control the properties of those steps.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#stlp"/></section><paragraph role="heading" level="2">Different step types</paragraph><list type="unordered"><listitem><paragraph role="paragraph"><image src="chart2/res/step_start_30.png"/></paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/steppedlinesdlg/step_start_rb">Start with horizontal line and step up vertically at the end.</ahelp></paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_end_30.png"/></paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/steppedlinesdlg/step_center_x_rb">Start to step up vertically and end with horizontal line.</ahelp></paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_center_x_30.png"/></paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/steppedlinesdlg/step_end_rb">Start with horizontal line, step up vertically in the middle of the X values and end with horizontal line.</ahelp></paragraph></listitem><listitem><paragraph role="paragraph"><image src="chart2/res/step_center_y_30.png"/></paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/steppedlinesdlg/step_center_y_rb">Start to step up vertically to the middle of the Y values, draw a horizontal line and finish by stepping vertically to the end.</ahelp></paragraph></listitem></list></body></helpdocument>
PK
w�XҀ��_< _< text/schart/01/04050100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Trend Lines</title><filename>/text/schart/01/04050100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id1744743"/><bookmark branch="hid/.uno:InsertMenuTrendlines" id="bm_id2001709"/><bookmark branch="hid/modules/schart/ui/tp_Trendline/TP_TRENDLINE" id="bm_id2001710"/><paragraph role="heading" level="1"><variable id="regression"><link href="text/schart/01/04050100.xhp">Trend Lines</link></variable></paragraph><paragraph role="paragraph"><variable id="trendlinestext"><ahelp hid=".">Trend lines can be added to all 2D chart types except for Pie and Stock charts.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#trendlines"/></section><bookmark branch="hid/modules/schart/ui/tp_Trendline/linear" id="bm_id6944181"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">A linear trend line is shown.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/logarithmic" id="bm_id886257"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">A logarithmic trend line is shown.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/exponential" id="bm_id8892483"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">An exponential trend line is shown.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/power" id="bm_id7198400"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">A power trend line is shown.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/polynomial" id="bm_id180820161047491735"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">A polynomial trend line is shown with a given degree.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label3" id="bm_id180820161152296070"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Degree of polynomial trend line.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/movingAverage" id="bm_id180820161104335824"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">A moving average trend line is shown with a given period.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label4" id="bm_id180820161157368991"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Number of points to calculate average of moving average trend line.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label5" id="bm_id180820161429301956"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Name of trend line in legend.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label7" id="bm_id180820161430141657"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Trend line is extrapolated for higher x-values.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label8" id="bm_id180820161504266451"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Trend line is extrapolated for lower x-values.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/setIntercept" id="bm_id180820161122038174"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">For linear, polynomial and exponential trend lines, intercept value is forced to a given value.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/interceptValue" id="bm_id180820161125169514"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Value of intercept if it is forced.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/showEquation" id="bm_id4724875"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows the trend line equation next to the trend line.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/showCorrelationCoefficient" id="bm_id9068880"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows the coefficient of determination next to the trend line.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label6" id="bm_id180820161515523577"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Name of X variable in trend line equation.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_Trendline/label9" id="bm_id180820161516105398"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Name of Y variable in trend line equation.</ahelp></paragraph><paragraph role="note">If you insert a trend line to a chart type that uses categories, like <emph>Line</emph> or <emph>Column</emph>, then the numbers 1, 2, 3, <emph>…</emph> are used as x-values to calculate the trend line. For such charts the XY chart type might be more suitable.</paragraph><list type="unordered"><listitem><paragraph role="paragraph">To insert a trend line for a data series, select the data series in the chart. Choose <item type="menuitem">Insert - Trend Lines</item>, or right-click to open the context menu, and choose <item type="menuitem">Insert - Trend Line</item>.</paragraph></listitem><listitem><bookmark branch="hid/.uno:InsertMenuMeanValues" id="bm_id7854243"/><paragraph role="paragraph">Mean Value Lines are special trend lines that show the mean value. Use <item type="menuitem">Insert - Mean Value Lines</item> to insert mean value lines for data series.</paragraph><embed href="text/schart/01/04030000.xhp#context"/></listitem><listitem><paragraph role="paragraph">To delete a trend line or mean value line, click the line, then press the Del key.</paragraph></listitem></list><paragraph role="note">A trend line is shown in the legend automatically. Its name can be defined in options of the trend line.</paragraph><paragraph role="paragraph">The trend line has the same color as the corresponding data series. To change the line properties, select the trend line and choose <item type="menuitem">Format - Format Selection - Line</item>.</paragraph><bookmark branch="hid/.uno:InsertTrendlineEquationAndR2" id="bm_id2754601"/><paragraph role="heading" level="2">Trend Line Equation and Coefficient of Determination</paragraph><bookmark branch="hid/.uno:InsertTrendlineEquation" id="bm_id2754600"/><paragraph role="paragraph">When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R<sup>2</sup>, even if they are not shown: click on the trend line to see the information in the status bar.</paragraph><paragraph role="paragraph"><ahelp hid=".">To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose <item type="menuitem">Insert Trend Line Equation</item>.</ahelp></paragraph><paragraph role="paragraph">To change format of values (use less significant digits or scientific notation), select the equation in the chart, right-click to open the context menu, and choose <item type="menuitem">Format Trend Line Equation - Numbers</item>.</paragraph><paragraph role="paragraph">Default equation uses <item type="literal">x</item> for abscissa variable, and <item type="literal">f(x)</item> for ordinate variable. To change these names, select the trend line, choose <item type="menuitem">Format - Format Selection – Type</item> and enter names in <item type="literal">X Variable Name</item> and <item type="literal">Y Variable Name</item> edit boxes.</paragraph><bookmark branch="hid/.uno:InsertR2Value" id="bm_id2754602"/><paragraph role="paragraph">To show the coefficient of determination R<sup>2</sup>, select the equation in the chart, right-click to open the context menu, and choose <item type="menuitem">Insert R<sup>2</sup></item>.</paragraph><paragraph role="note">If intercept is forced, coefficient of determination R<sup>2</sup> is not calculated in the same way as with free intercept. R<sup>2</sup> values can not be compared with forced or free intercept.</paragraph><paragraph role="heading" level="2">Trend Lines Curve Types</paragraph><paragraph role="paragraph">Following regression types are available:</paragraph><list type="unordered"><listitem><paragraph role="paragraph"><emph>Linear</emph> trend line: regression through equation <item type="literal">y=a∙x+b</item>. Intercept <item type="literal">b</item> can be forced.</paragraph></listitem><listitem><paragraph role="paragraph"><emph>Polynomial</emph> trend line: regression through equation <item type="literal">y=Σ(a<sub>i</sub>∙x<sup>i</sup>)</item>. Intercept <item type="literal">a<sub>0</sub></item> can be forced. Degree of polynomial must be given (at least 2).</paragraph></listitem><listitem><paragraph role="paragraph"><emph>Logarithmic</emph> trend line: regression through equation <item type="literal">y=a∙ln(x)+b</item>.</paragraph></listitem><listitem><paragraph role="paragraph"><emph>Exponential</emph> trend line: regression through equation <item type="literal">y=b∙exp(a∙x)</item>.This equation is equivalent to <item type="literal">y=b∙m<sup>x</sup></item> with <item type="literal">m=exp(a)</item>. Intercept <item type="literal">b</item> can be forced.</paragraph></listitem><listitem><paragraph role="paragraph"><emph>Power</emph> trend line: regression through equation <item type="literal">y=b∙x<sup>a</sup></item>.</paragraph></listitem><listitem><paragraph role="paragraph"><emph>Moving average</emph> trend line: simple moving average is calculated with the <emph>n</emph> previous y-values, <emph>n</emph> being the period. No equation is available for this trend line.</paragraph></listitem></list><paragraph role="heading" level="2">Constraints</paragraph><paragraph role="paragraph"> The calculation of the trend line considers only data pairs with the following values:</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Logarithmic trend line: only positive x-values are considered.</paragraph></listitem><listitem><paragraph role="paragraph">Exponential trend line: only positive y-values are considered, except if all y-values are negative: regression will then follow equation <item type="literal">y=-b∙exp(a∙x)</item>.</paragraph></listitem><listitem><paragraph role="paragraph">Power trend line: only positive x-values are considered; only positive y-values are considered, except if all y-values are negative: regression will then follow equation<item type="literal"> y=-b∙x<sup>a</sup></item>.</paragraph></listitem></list><paragraph role="paragraph">You should transform your data accordingly; it is best to work on a copy of the original data and transform the copied data.</paragraph><paragraph role="heading" level="2">Calculate Parameters in Calc</paragraph><paragraph role="paragraph">You can also calculate the parameters using Calc functions as follows.</paragraph><paragraph role="heading" level="3">The linear regression equation</paragraph><paragraph role="paragraph">The <emph>linear regression</emph> follows the equation <item type="literal">y=m*x+b</item>.</paragraph><paragraph role="code">m = SLOPE(Data_Y;Data_X) </paragraph><paragraph role="code">b = INTERCEPT(Data_Y ;Data_X) </paragraph><paragraph role="paragraph">Calculate the coefficient of determination by</paragraph><paragraph role="code">r<sup>2</sup> = RSQ(Data_Y;Data_X) </paragraph><paragraph role="paragraph">Besides m, b and r<sup>2</sup> the array function <emph>LINEST</emph> provides additional statistics for a regression analysis.</paragraph><paragraph role="heading" level="3">The logarithmic regression equation</paragraph><paragraph role="paragraph">The <emph>logarithmic regression</emph> follows the equation <item type="literal">y=a*ln(x)+b</item>.</paragraph><paragraph role="code">a = SLOPE(Data_Y;LN(Data_X)) </paragraph><paragraph role="code">b = INTERCEPT(Data_Y ;LN(Data_X)) </paragraph><paragraph role="code">r<sup>2</sup> = RSQ(Data_Y;LN(Data_X)) </paragraph><paragraph role="heading" level="3">The exponential regression equation</paragraph><paragraph role="paragraph"> For exponential trend lines a transformation to a linear model takes place. The optimal curve fitting is related to the linear model and the results are interpreted accordingly.</paragraph><paragraph role="paragraph">The exponential regression follows the equation <item type="literal">y=b*exp(a*x)</item> or <item type="literal">y=b*m^x</item>, which is transformed to <item type="literal">ln(y)=ln(b)+a*x</item> or <item type="literal">ln(y)=ln(b)+ln(m)*x</item> respectively.</paragraph><paragraph role="code">a = SLOPE(LN(Data_Y);Data_X) </paragraph><paragraph role="paragraph">The variables for the second variation are calculated as follows:</paragraph><paragraph role="code">m = EXP(SLOPE(LN(Data_Y);Data_X)) </paragraph><paragraph role="code">b = EXP(INTERCEPT(LN(Data_Y);Data_X)) </paragraph><paragraph role="paragraph">Calculate the coefficient of determination by</paragraph><paragraph role="code">r<sup>2</sup> = RSQ(LN(Data_Y);Data_X) </paragraph><paragraph role="paragraph">Besides m, b and r<sup>2</sup> the array function LOGEST provides additional statistics for a regression analysis.</paragraph><paragraph role="heading" level="3">The power regression equation</paragraph><paragraph role="paragraph"> For <emph>power regression</emph> curves a transformation to a linear model takes place. The power regression follows the equation <item type="literal">y=b*x^a</item> , which is transformed to <item type="literal">ln(y)=ln(b)+a*ln(x)</item>.</paragraph><paragraph role="code">a = SLOPE(LN(Data_Y);LN(Data_X)) </paragraph><paragraph role="code">b = EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) </paragraph><paragraph role="code">r<sup>2</sup> = RSQ(LN(Data_Y);LN(Data_X)) </paragraph><paragraph role="heading" level="3">The polynomial regression equation</paragraph><paragraph role="paragraph">For <emph>polynomial regression</emph> curves a transformation to a linear model takes place.</paragraph><paragraph role="paragraph">Create a table with the columns x, x<sup>2</sup>, x<sup>3</sup>, … , x<sup>n</sup>, y up to the desired degree n. </paragraph><paragraph role="paragraph">Use the formula <item type="literal">=LINEST(Data_Y,Data_X)</item> with the complete range x to x<sup>n</sup> (without headings) as Data_X. </paragraph><paragraph role="paragraph">The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position.</paragraph><paragraph role="paragraph">The first element of the third row of the LINEST output is the value of r<sup>2</sup>. See the <link href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function for details on proper use and an explanation of the other output parameters.</paragraph><section id="relatedtopics"><paragraph role="paragraph"><link href="text/schart/01/04050000.xhp">X/Y Error Bars</link></paragraph><paragraph role="paragraph"><link href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function</paragraph><paragraph role="paragraph"><link href="text/scalc/01/04060107.xhp#Section7">LOGEST</link> function</paragraph><paragraph role="paragraph"><link href="text/scalc/01/04060185.xhp#slope">SLOPE</link> function</paragraph><paragraph role="paragraph"><link href="text/scalc/01/04060181.xhp#intercept">INTERCEPT</link> function</paragraph><paragraph role="paragraph"><link href="text/scalc/01/04060181.xhp#rsq">RSQ</link> function</paragraph></section></body></helpdocument>
PK
w�X:N-g�, �, text/schart/01/three_d_view.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>3D View </title><filename>/text/schart/01/three_d_view.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3156423"/><bookmark branch="hid/.uno:View3D" id="bm_id3150449"/><paragraph role="heading" level="1"><variable id="three_d_view"><link href="text/schart/01/three_d_view.xhp">3D View</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> or in the context menu of a chart you can choose a chart type. <ahelp hid="." visibility="hidden">Opens a dialog to edit the properties of a three dimensional view for Column, Bar, Pie, and Area charts. For Line and XY (Scatter) charts you can see 3D lines.</ahelp></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="paragraph">The chart preview responds to the new settings that you enter in the dialog. </paragraph><list type="unordered"><listitem><paragraph role="paragraph">When you leave the dialog with OK, the settings are applied permanently. </paragraph></listitem><listitem><paragraph role="paragraph">When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog.</paragraph></listitem></list><paragraph role="paragraph">For a 3D chart you can choose <item type="menuitem">Format - 3D View</item> to set perspective, appearance and illumination.</paragraph><paragraph role="heading" level="2">Perspective</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Enter the values for rotation of the chart on the three axes and for a perspective view.</paragraph></listitem></list><paragraph role="paragraph">Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles.</paragraph><paragraph role="paragraph">With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders.</paragraph><paragraph role="paragraph">An x value of 90, with y and z set to 0, provides a view from top down to the chart. With x set to -90, you see the bottom of the chart.</paragraph><paragraph role="paragraph">The rotations are applied in the order first x, then y, last z.</paragraph><paragraph role="paragraph">When shading is enabled and you rotate a chart, the lights are rotated as if they are fixed to the chart.</paragraph><paragraph role="note">The rotation axes always relate to the page, not to the chart's axes. This is different from some other chart programs.</paragraph><paragraph role="paragraph">Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection. </paragraph><paragraph role="paragraph">Set the focus length with the spin button. 100% gives a perspective view where a far edge in the chart looks approximately half as big as a near edge.</paragraph><paragraph role="note">Older versions of %PRODUCTNAME cannot display the percentage of perspective the same way as the current version.</paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/CBX_RIGHT_ANGLED_AXES" id="bm_id5293740"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">If Right-angled axes is enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. Right-angled axes is enabled by default for newly created 3D charts. Pie and Donut charts do not support right-angled axes.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/MTR_FLD_X_ROTATION" id="bm_id6549272"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the x axis. The preview responds to the new settings.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/MTR_FLD_Y_ROTATION" id="bm_id6529740"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the y axis. The preview responds to the new settings.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/MTR_FLD_Z_ROTATION" id="bm_id9121982"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the z axis. The preview responds to the new settings.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/CBX_PERSPECTIVE" id="bm_id2394482"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneGeometry/MTR_FLD_PERSPECTIVE" id="bm_id3808404"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Mark the Perspective box to view the chart as through a camera lens. Use the spin button to set the percentage. With a high percentage nearer objects look bigger than more distant objects.</ahelp></paragraph><paragraph role="heading" level="2">Appearance</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Select a scheme from the list box.</paragraph></listitem></list><paragraph role="paragraph">By selecting a scheme, the check boxes and the light sources are set accordingly.</paragraph><list type="unordered"><listitem><paragraph role="paragraph">If you mark or unmark a combination of check boxes that is not given by the Realistic or Simple scheme, you create a Custom scheme.</paragraph></listitem><listitem><paragraph role="paragraph">Mark <emph>Shading</emph> to use the Gouraud method for rendering the surface, otherwise a flat method is used. </paragraph><paragraph role="paragraph">The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible. </paragraph><paragraph role="paragraph">The Gouraud method applies gradients for a smoother, more realistic look.</paragraph></listitem></list><list type="unordered"><listitem><paragraph role="paragraph">Mark <emph>Object Borders</emph> to draw lines along the edges.</paragraph></listitem><listitem><paragraph role="paragraph">Mark <emph>Rounded Edges</emph> to smooth the edges of box shapes.</paragraph></listitem></list><bookmark branch="hid/modules/schart/ui/tp_3D_SceneAppearance/LB_SCHEME" id="bm_id631733"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a scheme from the list box, or click any of the check boxes below.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneAppearance/CB_SHADING" id="bm_id7811822"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Applies Gouraud shading if marked, or flat shading if unmarked.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneAppearance/CB_OBJECTLINES" id="bm_id3640247"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Shows borders around the areas by setting the line style to Solid.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneAppearance/CB_ROUNDEDEDGE" id="bm_id4585100"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Edges are rounded by 5%.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/tp_3D_SceneIllumination" id="bm_id476392"/><paragraph role="heading" level="2">Illumination</paragraph><paragraph role="paragraph">Set the light sources for the 3D view.</paragraph><list type="unordered"><listitem><paragraph role="paragraph">Click any of the eight buttons to switch a directed light source on or off.</paragraph><paragraph role="paragraph">By default, the second light source is switched on. It is the first of seven "normal", uniform light sources. The light source number one projects a specular light with highlights.</paragraph></listitem><listitem><paragraph role="paragraph">For the selected light source, you can then choose a color and intensity in the list box just below the eight buttons. The brightness values of all lights are added, so use dark colors when you enable multiple lights.</paragraph></listitem><listitem><paragraph role="paragraph">The small preview inside this tab page has two sliders to set the vertical and horizontal position of the selected light source. The light source always aims to the middle of the object.</paragraph></listitem><listitem><paragraph role="paragraph">The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.</paragraph></listitem><listitem><paragraph role="paragraph">Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions.</paragraph></listitem></list><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Drag the right slider to set the vertical height and direction of the selected light source.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Drag the bottom slider to set the horizontal position and direction of the selected light source.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Click to switch between an illumination model of a sphere or a cube.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_1" id="bm_id2334665"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Click to enable or disable the specular light source with highlights.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_2" id="bm_id476393"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_3" id="bm_id2655720"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_4" id="bm_id3682058"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_5" id="bm_id5977965"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_6" id="bm_id3050325"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_7" id="bm_id9421979"/><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHT_8" id="bm_id1646778"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Click to enable or disable the uniform light source.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/LB_LIGHTSOURCE" id="bm_id1601611"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a color for the selected light source.</ahelp></paragraph><bookmark branch="hidmodules/schart/ui/tp_3D_SceneIllumination/BTN_LIGHTSOURCE_COLOR" id="bm_id733359"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/LB_AMBIENTLIGHT" id="bm_id1228370"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a color for the ambient light.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_3D_SceneIllumination/BTN_AMBIENT_COLOR" id="bm_id879848"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�XkG�C� � text/schart/01/05070000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Floor</title><filename>/text/schart/01/05070000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3154346"/><bookmark branch="hid/.uno:DiagramFloor" id="bm_id3150400"/><paragraph role="heading" level="1">Chart Floor</paragraph><paragraph role="paragraph"><variable id="diagrammboden"><ahelp hid=".uno:DiagramFloor">Opens the<emph> Chart Floor</emph> dialog, where you can modify the properties of the chart floor. The chart floor is the lower area in 3D charts. This function is only available for 3D charts.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtdgb"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�XJ�Ǖ� � text/schart/01/05080000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Area</title><filename>/text/schart/01/05080000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3149670"/><bookmark branch="hid/.uno:DiagramArea" id="bm_id3149457"/><paragraph role="heading" level="1">Chart Area</paragraph><paragraph role="paragraph"><variable id="diagrammflaeche"><ahelp visibility="visible" hid=".uno:DiagramArea">Opens the<emph> Chart Area</emph> dialog, where you can modify the properties of the chart area. The chart area is the background behind all elements of the chart.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtdgf"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X�R�b`5 `5 text/schart/01/type_stock.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Stock</title><filename>/text/schart/01/type_stock.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id2959990"/><paragraph role="heading" level="1"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Stock</paragraph><paragraph role="paragraph">A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.</paragraph><paragraph role="paragraph">For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below.</paragraph><table><tablerow><tablecell/><tablecell><paragraph role="tablehead">A</paragraph></tablecell><tablecell><paragraph role="tablehead">B</paragraph></tablecell><tablecell><paragraph role="tablehead">C</paragraph></tablecell><tablecell><paragraph role="tablehead">D</paragraph></tablecell><tablecell><paragraph role="tablehead">E</paragraph></tablecell><tablecell><paragraph role="tablehead">F</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">1</paragraph></tablecell><tablecell/><tablecell><paragraph role="tablecontent">Transaction volume</paragraph></tablecell><tablecell><paragraph role="tablecontent">Opening price</paragraph></tablecell><tablecell><paragraph role="tablecontent">Low (bottom price)</paragraph></tablecell><tablecell><paragraph role="tablecontent">High (top price)</paragraph></tablecell><tablecell><paragraph role="tablecontent">Closing price</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">2</paragraph></tablecell><tablecell><paragraph role="tablecontent">Monday</paragraph></tablecell><tablecell><paragraph role="tablecontent">2500</paragraph></tablecell><tablecell><paragraph role="tablecontent">20</paragraph></tablecell><tablecell><paragraph role="tablecontent">15</paragraph></tablecell><tablecell><paragraph role="tablecontent">25</paragraph></tablecell><tablecell><paragraph role="tablecontent">17</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">3</paragraph></tablecell><tablecell><paragraph role="tablecontent">Tuesday</paragraph></tablecell><tablecell><paragraph role="tablecontent">3500</paragraph></tablecell><tablecell><paragraph role="tablecontent">32</paragraph></tablecell><tablecell><paragraph role="tablecontent">22</paragraph></tablecell><tablecell><paragraph role="tablecontent">37</paragraph></tablecell><tablecell><paragraph role="tablecontent">30</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">4</paragraph></tablecell><tablecell><paragraph role="tablecontent">Wednesday</paragraph></tablecell><tablecell><paragraph role="tablecontent">1000</paragraph></tablecell><tablecell><paragraph role="tablecontent">15</paragraph></tablecell><tablecell><paragraph role="tablecontent">15</paragraph></tablecell><tablecell><paragraph role="tablecontent">17</paragraph></tablecell><tablecell><paragraph role="tablecontent">17</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">5</paragraph></tablecell><tablecell><paragraph role="tablecontent">Thursday</paragraph></tablecell><tablecell><paragraph role="tablecontent">2200</paragraph></tablecell><tablecell><paragraph role="tablecontent">40</paragraph></tablecell><tablecell><paragraph role="tablecontent">30</paragraph></tablecell><tablecell><paragraph role="tablecontent">47</paragraph></tablecell><tablecell><paragraph role="tablecontent">35</paragraph></tablecell></tablerow><tablerow><tablecell><paragraph role="tablecontent">6</paragraph></tablecell><tablecell><paragraph role="tablecontent">Friday</paragraph></tablecell><tablecell><paragraph role="tablecontent">4600</paragraph></tablecell><tablecell><paragraph role="tablecontent">27</paragraph></tablecell><tablecell><paragraph role="tablecontent">20</paragraph></tablecell><tablecell><paragraph role="tablecontent">32</paragraph></tablecell><tablecell><paragraph role="tablecontent">31</paragraph></tablecell></tablerow></table><paragraph role="paragraph">The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series.</paragraph><paragraph role="paragraph">Depending on the chosen variant, you do not need all columns.</paragraph><paragraph role="heading" level="2">Stock Chart Variants</paragraph><paragraph role="paragraph">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart wizard</link>. Then select one of the four variants.</paragraph><paragraph role="heading" level="2">Type 1</paragraph><paragraph role="paragraph">Based on<emph> low</emph>
<emph>and high </emph>column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph><paragraph role="paragraph">Based on<emph> low, high,</emph> and <emph>close</emph> column Type 1 shows an additional horizontal mark <emph>for</emph> the closing price.</paragraph><paragraph role="heading" level="2">Type 2</paragraph><paragraph role="paragraph">Based on <emph>open, low, high</emph>, and <emph>close</emph> column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values.</paragraph><paragraph role="heading" level="2">Type 3</paragraph><paragraph role="paragraph">Based on <emph>volume, low, high</emph>, and <emph>close</emph> column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.</paragraph><paragraph role="heading" level="2">Type 4</paragraph><paragraph role="paragraph">Based on all five data columns <emph>volume, open, low, high</emph>, and <emph>close</emph>, Type 4 combines a chart of Type 2 with a column chart for the transaction volume.</paragraph><paragraph role="paragraph">Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side.</paragraph><paragraph role="heading" level="2">Setting the Data Source</paragraph><paragraph role="heading" level="2">Charts based on its own data</paragraph><paragraph role="paragraph">To change the data series of a chart having its own data, choose <link href="text/schart/01/03010000.xhp">Chart Data Table</link> from the View menu or from the context menu of the chart in edit mode.</paragraph><paragraph role="paragraph">In an embedded chart data table, the data series are always organized in columns.</paragraph><paragraph role="paragraph">For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant. </paragraph><paragraph role="paragraph">If you have already got a stock chart and you want to change the variant, then first change the chart type to a column chart, add or remove columns so that it fits to the variant, and then change the chart type back to a stock chart.</paragraph><paragraph role="paragraph">Do not write the name of a data series in a row. Write the name into the field above the role name.</paragraph><paragraph role="paragraph">The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order.</paragraph><paragraph role="heading" level="2">Charts based on Calc or Writer tables</paragraph><paragraph role="paragraph">You can choose or alter a data range on the second page of the Chart wizard or in the <link href="text/schart/01/wiz_data_range.xhp">Data Range</link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp">Data Series</link> dialog.</paragraph><paragraph role="paragraph">To specify a data range do one of the following:</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Enter the data range in the text box.</paragraph><paragraph role="paragraph">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph><paragraph role="paragraph">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph></listitem></list><list type="ordered"><listitem><paragraph role="paragraph">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click <emph>Select </emph>
<emph>data range</emph> again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range.</paragraph></listitem></list><paragraph role="paragraph">Click one of the options for data series in rows or in columns. </paragraph><paragraph role="paragraph">Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".</paragraph><paragraph role="heading" level="2">Fine Tuning the Data Ranges of Table Based Stock Charts</paragraph><paragraph role="paragraph">You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog.</paragraph><paragraph role="heading" level="2">Organize Data Series</paragraph><paragraph role="paragraph">In the <emph>data series</emph> area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume.</paragraph><paragraph role="paragraph">If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series.</paragraph><paragraph role="paragraph">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph><paragraph role="paragraph">To add a data series, select one of the existing data series and click <emph>Add</emph>. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the <emph>Data Range</emph> dialog.</paragraph><paragraph role="heading" level="2">Setting Data Ranges</paragraph><paragraph role="paragraph">In the <emph>Data Ranges</emph> dialog you can set or change the data range of each component of the selected data series.</paragraph><paragraph role="paragraph">In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.</paragraph><paragraph role="paragraph">Enter the range into the text box or click on <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph><paragraph role="paragraph">Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table.</paragraph><paragraph role="heading" level="2">Legend</paragraph><paragraph role="paragraph">The legend displays the labels from the first row or column or from the special range that you have set in the <emph>Data Series</emph> dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.</paragraph><paragraph role="paragraph">The legend shows the value from the range, which you entered in the <emph>Range for Name</emph> field in the <emph>Data Range</emph> dialog. The default entry is the column header of the closing price column.</paragraph><paragraph role="paragraph">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X~��� � text/schart/01/type_area.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Area</title><filename>/text/schart/01/type_area.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id4130680"/><paragraph role="heading" level="1"><variable id="type_area"><link href="text/schart/01/type_area.xhp">Chart Type Area</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Area</paragraph><paragraph role="paragraph">An area chart shows values as points on the y axis. The x axis shows categories. The y values of each data series are connected by a line. The area between each two lines is filled with a color. The area chart's focus is to emphasize the changes from one category to the next.</paragraph><paragraph role="paragraph">Normal - this subtype plots all values as absolute y values. It first plots the area of the last column in the data range, then the next to last, and so on, and finally the first column of data is drawn. Thus, if the values in the first column are higher than other values, the last drawn area will hide the other areas.</paragraph><paragraph role="paragraph">Stacked - this subtypes plots values cumulatively stacked on each other. It ensures that all values are visible, and no data set is hidden by others. However, the y values no longer represent absolute values, except for the last column which is drawn at the bottom of the stacked areas.</paragraph><paragraph role="paragraph">Percent - this subtype plots values cumulatively stacked on each other and scaled as percentage of the category total.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�XK�� � text/schart/01/type_bubble.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Bubble</title><filename>/text/schart/01/type_bubble.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id2183975"/><paragraph role="heading" level="1"><variable id="type_bubble"><link href="text/schart/01/type_bubble.xhp">Chart Type Bubble</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Bubble</paragraph><paragraph role="paragraph">A bubble chart shows the relations of three variables. Two variables are used for the position on the X-axis and Y-axis, while the third variable is shown as the relative size of each bubble.</paragraph><paragraph role="paragraph">The data series dialog for a bubble chart has an entry to define the data range for the Bubble Sizes.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X�VI1* * text/schart/01/05030000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Legend</title><filename>/text/schart/01/05030000.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:Legend" id="bm_id3154017"/><paragraph role="heading" level="1">Legend</paragraph><paragraph role="paragraph"><variable id="legende"><ahelp hid=".uno:Legend">Defines the border, area and character attributes for a legend.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtlgd"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><paragraph role="heading" level="2"><link href="text/shared/01/05020100.xhp">Character</link></paragraph><embed href="text/shared/01/05020100.xhp#zn"/><paragraph role="heading" level="2"><link href="text/schart/01/04020000.xhp">Display</link></paragraph><embed href="text/schart/01/04020000.xhp#legende"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�X�H��_ _ text/schart/01/04070000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Grids</title><filename>/text/schart/01/04070000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3147434"/><bookmark branch="hid/.uno:InsertMenuGrids" id="bm_id3145748"/><bookmark branch="hid/modules/schart/ui/insertgriddlg/InsertGridDialog" id="bm_id3145749"/><paragraph role="heading" level="1">Grids</paragraph><paragraph role="paragraph"><variable id="gitter"><ahelp hid=".">You can divide the axes into sections by assigning gridlines to them. This allows you to get a better overview of the chart, especially if you are working with large charts.</ahelp></variable> The Y axis major grid is activated by default.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efgaugg"/></section><paragraph role="heading" level="2">Major grids</paragraph><paragraph role="paragraph">Defines the axis to be set as the major grid.</paragraph><bookmark branch="hid/modules/schart/ui/insertgriddlg/primaryX" id="bm_id1858885"/><paragraph role="heading" level="3">X axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/primaryX">Adds gridlines to the X axis of the chart.</ahelp></paragraph><bookmark branch="hid/.uno:ToggleGridVertical" id="bm_id3149020"/><paragraph role="paragraph"><variable id="sytextxgitter"><ahelp hid=".uno:ToggleGridVertical">The <emph>Vertical Grids</emph> icon on the <emph>Formatting</emph> bar toggles the visibility of the grid display for the X axis.</ahelp></variable> It switches between the three states: no grid, major grid and both major and minor grids displayed. The change will affect check boxes in <emph>Insert - Grids</emph>.</paragraph><embed href="text/schart/00/00000004.xhp#gitterx"/><bookmark branch="hid/modules/schart/ui/insertgriddlg/primaryY" id="bm_id1858884"/><paragraph role="heading" level="3">Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/primaryY">Adds gridlines to the Y axis of the chart.</ahelp></paragraph><bookmark branch="hid/.uno:ToggleGridHorizontal" id="bm_id3155115"/><paragraph role="paragraph"><variable id="sytextygitter"><ahelp hid=".uno:ToggleGridHorizontal">The <emph>Horizontal Grids</emph> icon on the <emph>Formatting</emph> bar toggles the visibility of the grid display for the Y axis.</ahelp></variable> It switches between the three states: no grid, major grid and both major and minor grids displayed. The change will affect check boxes in <emph>Insert - Grids</emph>.</paragraph><embed href="text/schart/00/00000004.xhp#gittery"/><bookmark branch="hid/modules/schart/ui/insertgriddlg/primaryZ" id="bm_id1858883"/><paragraph role="heading" level="3">Z axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/primaryZ">Adds gridlines to the Z axis of the chart.</ahelp> This option is only available if you're working with 3D charts.</paragraph><paragraph role="heading" level="2">Minor grids</paragraph><paragraph role="paragraph">Use this area to assign a minor grid for each axis. Assigning minor grids to the axis reduces the distance between the major grids.</paragraph><bookmark branch="hid/modules/schart/ui/insertgriddlg/secondaryX" id="bm_id1858882"/><paragraph role="heading" level="3">X axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/secondaryX">Adds gridlines that subdivide the X axis into smaller sections.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/insertgriddlg/secondaryY" id="bm_id2156132"/><paragraph role="heading" level="3">Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/secondaryY">Adds gridlines that subdivide the Y axis into smaller sections.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/insertgriddlg/secondaryZ" id="bm_id9931943"/><paragraph role="heading" level="3">Z axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertgriddlg/secondaryZ">Adds gridlines that subdivide the Z axis into smaller sections.</ahelp> This option is only available if you're working with 3D charts.</paragraph></body></helpdocument>
PK
w�X��1� � ! text/schart/01/wiz_chart_type.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Wizard - Chart Type</title><filename>/text/schart/01/wiz_chart_type.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id4266792"/><bookmark branch="hid/modules/schart/ui/tp_ChartType/tp_ChartType" id="bm_id863980"/><paragraph role="heading" level="1"><variable id="wiz_chart_type"><link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard - Chart Type</link></variable></paragraph><paragraph role="paragraph">On the first page of the Chart Wizard you can <link href="text/schart/01/choose_chart_type.xhp">choose a chart type</link>.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><embed href="text/shared/00/00000001.xhp#ShiftF1"/><paragraph role="heading" level="2">To choose a chart type</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Choose a basic <link href="text/schart/01/choose_chart_type.xhp">chart type</link>: click any of the entries labeled Column, Bar, Pie, and so on.</paragraph><paragraph role="paragraph">The contents on the right side will change to offer more options depending on the basic chart type.</paragraph></listitem><listitem><paragraph role="paragraph">Optionally, click any of the options. While you change the settings in the wizard, watch the preview in the document to see how the chart will look.</paragraph></listitem></list><paragraph role="paragraph">Press <item type="keycode">Shift+F1</item> and point to a control to see an extended help text.</paragraph><paragraph role="paragraph">Click <emph>Finish</emph> on any wizard page to close the wizard and create the chart using the current settings.</paragraph><paragraph role="paragraph">Click <emph>Next</emph> to see the next wizard page, or click the entries on the left side of the wizard to go to that page.</paragraph><paragraph role="paragraph">Click <emph>Back</emph> to see the previous wizard page.</paragraph><paragraph role="paragraph">Click <emph>Cancel</emph> to close the wizard without creating a chart.</paragraph><bookmark branch="hid/CHART2_HID_SCH_WIZARD_ROADMAP" id="bm_id2511368"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Click to go to the named wizard page.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/charttype" id="bm_id8073976"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a basic chart type.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/subtype" id="bm_id3088473"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a sub type of the basic chart type.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/3dlook" id="bm_id8226569"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enables a 3D look for the data values.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/3dscheme" id="bm_id678731"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select the type of 3D look.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/shape" id="bm_id8631244"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Select a shape from the list.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/stack" id="bm_id7211523"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Displays stacked series for Line charts.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/ontop" id="bm_id7261879"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Stack series display values on top of each other.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/percent" id="bm_id7606128"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Stack series display values as percent.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/linetype" id="bm_id5778374"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Choose the type of line to draw.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/properties" id="bm_id7417523"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to set the line or curve properties.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/sort" id="bm_id6278878"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Connects points by ascending X values, even if the order of values is different, in an XY scatter diagram.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ChartType/nolines" id="bm_id7565843"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Set the number of lines for the Column and Line chart type.</ahelp></paragraph><bookmark branch="hid/.uno:DiagramType" id="bm_id863979"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens the Chart Type dialog.</ahelp></paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�X����
�
" text/schart/01/type_column_bar.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Column and Bar</title><filename>/text/schart/01/type_column_bar.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id4919583"/><paragraph role="heading" level="1"><variable id="type_column_bar"><link href="text/schart/01/type_column_bar.xhp">Chart Type Column and Bar</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Column</paragraph><paragraph role="paragraph">This type shows a bar chart or bar graph with vertical bars. The height of each bar is proportional to its value. The x axis shows categories. The y axis shows the value for each category.</paragraph><paragraph role="paragraph">Normal - this subtype shows all data values belonging to a category next to each other. Main focus is on the individual absolute values, compared to every other value.</paragraph><paragraph role="paragraph">Stacked - this subtype shows the data values of each category on top of each other. Main focus is the overall category value and the individual contribution of each value within its category.</paragraph><paragraph role="paragraph">Percent - this subtype shows the relative percentage of each data value with regard to the total of its category. Main focus is the relative contribution of each value to the category's total.</paragraph><paragraph role="paragraph">You can enable a <link href="text/schart/01/three_d_view.xhp">3D view</link> of the data values. The "realistic" scheme tries to give the best 3D look. The "simple" scheme tries to mimic the chart view of other Office products.</paragraph><paragraph role="paragraph">For 3D charts, you can select the shape of each data value from Box, Cylinder, Cone, and Pyramid.</paragraph><paragraph role="heading" level="2">Bar</paragraph><paragraph role="paragraph">This type shows a bar chart or bar graph with horizontal bars. The length of each bar is proportional to its value. The y axis shows categories. The x axis shows the value for each category.</paragraph><paragraph role="paragraph">The subtypes are the same as for the Column type.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�Xz�# text/schart/01/05020200.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Title</title><filename>/text/schart/01/05020200.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:AllTitles" id="bm_id3150769"/><bookmark branch="hid/.uno:YTitle" id="bm_id3150449"/><paragraph role="heading" level="1">Title</paragraph><paragraph role="paragraph"><variable id="titel"><ahelp hid=".uno:YTitle">Modifies the properties of the selected title or the properties of all titles together.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtegt"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><paragraph role="heading" level="2"><link href="text/shared/01/05020100.xhp">Character</link></paragraph><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/05020101.xhp#ausricht"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�XU�v
� � text/schart/01/05040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Axis</title><filename>/text/schart/01/05040000.xhp</filename></topic></meta><body><section id="achse"><paragraph role="heading" level="1"><link href="text/schart/01/05040000.xhp">Axis</link></paragraph><paragraph role="paragraph">This opens a submenu to edit axial properties.</paragraph></section><paragraph role="paragraph">The tabs in the dialogs depend on the chart type selected.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frttyab"/></section><paragraph role="heading" level="2"><link href="text/schart/01/05040100.xhp">X axis</link></paragraph><embed href="text/schart/01/05040100.xhp#achsen"/><paragraph role="heading" level="2"><link href="text/schart/01/05040200.xhp">Y axis</link></paragraph><embed href="text/schart/01/05040200.xhp#yachse"/><bookmark branch="hid/.uno:DiagramAxisA" id="bm_id3151075"/><paragraph role="heading" level="2"><link href="text/schart/01/05040100.xhp">Secondary X Axis</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DiagramAxisA">Opens a dialog where you can edit the properties of the secondary X axis. To insert a secondary X axis, choose <emph>Insert - Axes</emph> and select <emph>X axis</emph>.</ahelp></paragraph><bookmark branch="hid/.uno:DiagramAxisB" id="bm_id3155445"/><paragraph role="heading" level="2"><link href="text/schart/01/05040200.xhp">Secondary Y Axis</link></paragraph><paragraph role="paragraph"><ahelp hid=".uno:DiagramAxisB">Opens a dialog where you can edit the properties of the secondary Y axis. To insert a secondary Y axis, choose <emph>Insert - Axes</emph> and select <emph>Y axis</emph>.</ahelp></paragraph><paragraph role="heading" level="2"><link href="text/schart/01/05040100.xhp">Z axis</link></paragraph><embed href="text/schart/01/05040100.xhp#achsen"/><paragraph role="heading" level="2"><link href="text/schart/01/05040100.xhp">All axes</link></paragraph><embed href="text/schart/01/05040100.xhp#achsen"/></body></helpdocument>
PK
w�Xp��" text/schart/01/05010100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Data Point</title><filename>/text/schart/01/05010100.xhp</filename></topic></meta><body><section id="datenpunkt"><paragraph role="heading" level="1"><link href="text/schart/01/05010100.xhp">Data Point</link></paragraph><paragraph role="paragraph">This dialog allows you to change the properties of a selected data point. The dialog appears when there is only one data point selected when you choose <emph>Format - Format Selection</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph></section><paragraph role="note">Any changes made only affect this one data point. For example, if you edit the color of a bar, only the color of that bar will be different.</paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtodd"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><embed href="text/shared/01/05020100.xhp#zeichen"/><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/04030000.xhp#datenbeschriftung"/><embed href="text/schart/01/04030000.xhp#besch"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�XlX�r text/schart/01/05020100.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Title</title><filename>/text/schart/01/05020100.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3150769"/><bookmark branch="hid/.uno:MainTitle" id="bm_id3150870"/><bookmark branch="hid/.uno:XTitle" id="bm_id3150441"/><bookmark branch="hid/.uno:ZTitle" id="bm_id3153771"/><bookmark branch="hid/.uno:SubTitle" id="bm_id3154686"/><bookmark branch="hid/.uno:SecondaryXTitle" id="bm_id082520090430086"/><bookmark branch="hid/.uno:SecondaryYTitle" id="bm_id0825200904302515"/><paragraph role="heading" level="1">Title</paragraph><paragraph role="paragraph"><variable id="titel"><ahelp hid=".uno:ZTitle">Modifies the properties of the selected title.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#frtoe"/></section><embed href="text/shared/01/05200100.xhp#linie"/><embed href="text/shared/01/05210100.xhp#flaeche"/><embed href="text/shared/01/05210700.xhp#transparenz"/><paragraph role="heading" level="2"><link href="text/shared/01/05020100.xhp">Character</link></paragraph><embed href="text/shared/01/05020100.xhp#zn"/><embed href="text/schart/01/05020101.xhp#ausricht"/><embed href="text/shared/00/00000001.xhp#zurueck"/></body></helpdocument>
PK
w�Xˁ'%a a text/schart/01/04050000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>X/Y Error Bars</title><filename>/text/schart/01/04050000.xhp</filename></topic></meta><body><bookmark branch="hid/.uno:InsertMenuYErrorBars" id="bm_id877101"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/dlg_InsertErrorBars" id="bm_id877102"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/tp_ErrorBars" id="bm_id877102"/><paragraph role="heading" level="1"><link href="text/schart/01/04050000.xhp">X/Y Error Bars</link></paragraph><paragraph role="paragraph"><variable id="statistik"><ahelp hid=".">Use the <emph>X or Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp></variable></paragraph><embed href="text/schart/01/04030000.xhp#context"/><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efgsta"/></section><paragraph role="paragraph">An error bar is an indicator line that spans over a range from x/y - NegativeErrorValue to x/y + PositiveErrorValue. In this term, x or y is the value of the data point. When "standard deviation" is selected, x or y is the mean value of the data series. NegativeErrorValue and PositiveErrorValue are the amounts calculated by the error bar function or given explicitly.</paragraph><paragraph role="note">The <emph>Insert - X/Y Error Bars</emph> menu command is only available for 2D charts.</paragraph><paragraph role="heading" level="2">Error category</paragraph><paragraph role="paragraph">In the <emph>Error category</emph> area, you can choose different ways to display the error category.</paragraph><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_NONE" id="bm_id3862117"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_NONE" id="bm_id3862118"/><paragraph role="heading" level="3">None</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_ErrorBars/RB_NONE">Does not show any error bars.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_CONST" id="bm_id3964964"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/MF_POSITIVE" id="bm_id3964968"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/MF_NEGATIVE" id="bm_id3964969"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_CONST" id="bm_id3964966"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/MF_POSITIVE" id="bm_id3964961"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/MF_NEGATIVE" id="bm_id3964963"/><paragraph role="heading" level="3">Constant value</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_ErrorBars/RB_CONST">Displays constant values that you specify in the Parameters area.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_PERCENT" id="bm_id3336588"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_PERCENT" id="bm_id3336589"/><paragraph role="heading" level="3">Percentage</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/tp_ErrorBars/RB_PERCENT">Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_FUNCTION" id="bm_id7856685"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_FUNCTION" id="bm_id7856686"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/LB_FUNCTION" id="bm_id0428200810313556"/><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/LB_FUNCTION" id="bm_id0428200810313557"/><paragraph role="heading" level="3">Functions</paragraph><paragraph role="paragraph"><ahelp hid=".">Select a function to calculate the error bars.</ahelp></paragraph><paragraph role="paragraph">Standard Error: Displays the standard error.</paragraph><paragraph role="paragraph"><ahelp hid=".">Variance: Displays the variance calculated from the number of data points and respective values.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid=".">Standard Deviation: Displays the standard deviation (square root of the variance). Unlike other functions, error bars are centered on the mean.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid=".">Error Margin: Displays the highest error margin in percent according to the highest value of the data group. Set the percentage in the Parameters area.</ahelp></paragraph><paragraph role="heading" level="3">Cell Range</paragraph><paragraph role="paragraph"><ahelp hid=".">Click Cell Range and then specify a cell range from which to take the positive and negative error bar values.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Click a button to shrink the dialog, then use the mouse to select the cell range in the spreadsheet. Click the button again to restore the dialog to full size.</ahelp></paragraph><paragraph role="heading" level="3">From Data Table</paragraph><paragraph role="paragraph"><ahelp hid=".">For a chart with its own data, the error bar values can be entered in the chart data table. The Data Table dialog shows additional columns titled Positive X or Y-Error-Bars and Negative X or Y-Error-Bars.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the value to add to the displayed value as the positive error value.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the value to subtract from the displayed value as the negative error value.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the address range from where to get the positive error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Enter the address range from where to get the negative error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph><paragraph role="heading" level="3">Same value for both</paragraph><paragraph role="paragraph"><ahelp hid=".">Enable to use the positive error values also as negative error values. You can only change the value of the "Positve (+)" box. That value gets copied to the "Negative (-)" box automatically.</ahelp></paragraph><paragraph role="heading" level="2">Error indicator</paragraph><paragraph role="paragraph"><ahelp hid=".">Specifies the error indicator.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_BOTH" id="bm_id0428200810544351"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_BOTH" id="bm_id0428200810544352"/><paragraph role="heading" level="3">Positive and Negative</paragraph><paragraph role="paragraph"><ahelp hid=".">Shows positive and negative error bars.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_POSITIVE" id="bm_id0428200810550028"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_POSITIVE" id="bm_id0428200810550029"/><paragraph role="heading" level="3">Positive</paragraph><paragraph role="paragraph"><ahelp hid=".">Shows only positive error bars.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/tp_ErrorBars/RB_NEGATIVE" id="bm_id0428200810551739"/><bookmark branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_NEGATIVE" id="bm_id0428200810551740"/><paragraph role="heading" level="3">Negative</paragraph><paragraph role="paragraph"><ahelp hid=".">Shows only negative error bars.</ahelp></paragraph><section id="relatedtopics"><embed href="text/schart/01/04050100.xhp#regression"/></section></body></helpdocument>
PK
w�X]$� S S text/schart/01/04040000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Axes</title><filename>/text/schart/01/04040000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3147428"/><bookmark branch="hid/.uno:InsertMenuAxes" id="bm_id3146121"/><bookmark branch="hid/modules/schart/ui/insertaxisdlg/InsertAxisDialog" id="bm_id3146122"/><paragraph role="heading" level="1">Axes</paragraph><paragraph role="paragraph"><variable id="achsen"><ahelp hid=".uno:InsertMenuAxes">Specifies the axes to be displayed in the chart.</ahelp></variable></paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#efgaug"/></section><paragraph role="heading" level="2">Major axis</paragraph><bookmark branch="hid/modules/schart/ui/insertaxisdlg/primaryX" id="bm_id8561357"/><paragraph role="heading" level="3">X axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertaxisdlg/primaryX">Displays the X axis as a line with subdivisions.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/insertaxisdlg/primaryY" id="bm_id5721915"/><paragraph role="heading" level="3">Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertaxisdlg/primaryY">Displays the Y axis as a line with subdivisions.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/insertaxisdlg/primaryZ" id="bm_id5266884"/><paragraph role="heading" level="3">Z axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertaxisdlg/primaryZ">Displays the Z axis as a line with subdivisions.</ahelp> This axis can only be displayed in 3D charts.</paragraph><paragraph role="heading" level="2">Secondary axis</paragraph><paragraph role="paragraph">Use this area to assign a second axis to your chart. If a data series is already assigned to this axis, $[officename] automatically displays the axis and the label. You can turn off these settings later on. If no data has been assigned to this axis and you activate this area, the values of the primary Y axis are applied to the secondary axis.</paragraph><bookmark branch="hid/modules/schart/ui/insertaxisdlg/secondaryX" id="bm_id7411420"/><paragraph role="heading" level="3">X axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertaxisdlg/secondaryX">Displays a secondary X axis in the chart.</ahelp></paragraph><bookmark branch="hid/modules/schart/ui/insertaxisdlg/secondaryY" id="bm_id5671559"/><paragraph role="heading" level="3">Y axis</paragraph><paragraph role="paragraph"><ahelp hid="modules/schart/ui/insertaxisdlg/secondaryY">Displays a secondary Y axis in the chart.</ahelp></paragraph><paragraph role="tip"><ahelp hid="modules/schart/ui/insertaxisdlg/secondaryY">The major axis and the secondary axis can have different scaling. For example, you can scale one axis to 2 in. and the other to 1.5 in. </ahelp></paragraph></body></helpdocument>
PK
w�XY���� � text/schart/01/type_net.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Chart Type Net</title><filename>/text/schart/01/type_net.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id2193975"/><paragraph role="heading" level="1"><variable id="type_net"><link href="text/schart/01/type_net.xhp">Chart Type Net</link></variable></paragraph><paragraph role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph><section id="howtoget"><embed href="text/schart/00/00000004.xhp#wiz"/></section><paragraph role="heading" level="2">Net</paragraph><paragraph role="paragraph">A Net chart displays data values as points connected by some lines, in a grid net that resembles a spider net or a radar tube display.</paragraph><paragraph role="paragraph">For each row of chart data, a radial is shown on which the data is plotted. All data values are shown with the same scale, so all data values should have about the same magnitude.</paragraph><section id="relatedtopics"><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/><embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/><embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/><embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/></section></body></helpdocument>
PK
w�XF3�� � text/schart/main0202.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Formatting Bar</title><filename>/text/schart/main0202.xhp</filename></topic></meta><body><section id="chartformatting"><paragraph role="heading" level="1"><link href="text/schart/main0202.xhp">Formatting Bar</link></paragraph><paragraph role="paragraph">The Formatting Bar is shown when a chart is set to edit mode. Double-click a chart to enter edit mode. Click outside the chart to leave edit mode.</paragraph></section><paragraph role="paragraph">You can edit the formatting of a chart using the controls and icons on the Formatting Bar.</paragraph><bookmark branch="hid/.uno:ChartElementSelector" id="bm_id0810200902112648"/><paragraph role="heading" level="2">Select Chart Element</paragraph><paragraph role="paragraph"><ahelp hid=".">Select the element from the chart that you want to format. The element gets selected in the chart preview. Click Format Selection to open the properties dialog for the selected element.</ahelp></paragraph><paragraph role="heading" level="2">Format Selection</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the properties dialog for the selected element.</ahelp></paragraph><paragraph role="heading" level="2">Chart Type</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Chart Type dialog.</ahelp></paragraph><paragraph role="heading" level="2">Chart Data Table</paragraph><paragraph role="paragraph"><ahelp hid=".">Opens the Data Table dialog where you can edit the chart data.</ahelp></paragraph><paragraph role="heading" level="2">Horizontal Grids</paragraph><paragraph role="paragraph"><ahelp hid=".">The Horizontal Grids icon on the Formatting bar toggles the visibility of the grid display for the Y axis.</ahelp></paragraph><paragraph role="heading" level="2">Legend On/Off</paragraph><paragraph role="paragraph"><ahelp hid=".">To show or hide a legend, click Legend On/Off on the Formatting bar.</ahelp></paragraph><paragraph role="heading" level="2">Scale Text</paragraph><paragraph role="paragraph"><ahelp hid=".">Rescales the text in the chart when you change the size of the chart.</ahelp></paragraph><paragraph role="heading" level="2">Automatic Layout</paragraph><paragraph role="paragraph"><ahelp hid=".">Moves all chart elements to their default positions inside the current chart. This function does not alter the chart type or any other attributes other than the position of elements.</ahelp></paragraph></body></helpdocument>
PK
w�X�����/ �/ text/schart/main0000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Charts in $[officename]</title><filename>/text/schart/main0000.xhp</filename></topic></meta><body><bookmark branch="index" id="bm_id3148664"/><paragraph role="heading" level="1"><variable id="chart_main"><link href="text/schart/main0000.xhp">Using Charts in %PRODUCTNAME</link></variable></paragraph><paragraph role="paragraph"><variable id="chart">$[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations.
</variable></paragraph><paragraph role="heading" level="2">Chart Data</paragraph><paragraph role="paragraph">Charts can be based on the following data:</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Spreadsheet values from Calc cell ranges</paragraph></listitem><listitem><paragraph role="paragraph">Cell values from a Writer table</paragraph></listitem><listitem><paragraph role="paragraph">Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc)</paragraph></listitem></list><bookmark branch="hid/.uno:InsertObjectChart" id="bm_id2038889"/><bookmark branch="hid/.uno:InsertObjectChart" id="bm_id3149551"/><bookmark branch="hid/.uno:DrawChart" id="bm_id6209730"/><bookmark branch="hid/.uno:DrawChart" id="bm_id3154688"/><bookmark branch="hid/.uno:StarChartDialog" id="bm_id3146060"/><bookmark branch="hid/SW_HID_INSERT_CHART" id="bm_id3149532"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Creates a chart in the current document. To use a continuous range of cells as the data source for your chart, click inside the cell range, and then choose this command. Alternatively, select some cells and choose this command to create a chart of the selected cells.</ahelp></paragraph><paragraph role="heading" level="2">To insert a chart</paragraph><embed href="text/shared/guide/chart_insert.xhp#chart_insert"/><embed href="text/schart/01/choose_chart_type.xhp#choose_chart_type"/><paragraph role="heading" level="2">To edit a chart</paragraph><list type="ordered"><listitem><paragraph role="paragraph">Click a chart to edit the object properties:</paragraph><paragraph role="paragraph">Size and position on the current page.</paragraph><paragraph role="paragraph">Alignment, text wrap, outer borders, and more.</paragraph></listitem><listitem><paragraph role="paragraph">Double-click a chart to enter the chart edit mode:</paragraph><paragraph role="paragraph">Chart data values (for charts with own data).</paragraph><paragraph role="paragraph">Chart type, axes, titles, walls, grid, and more.</paragraph></listitem><listitem><paragraph role="paragraph">Double-click a chart element in chart edit mode:</paragraph><paragraph role="paragraph">Double-click an axis to edit the scale, type, color, and more.</paragraph><paragraph role="paragraph">Double-click a data point to select and edit the data series to which the data point belongs.</paragraph><paragraph role="paragraph">With a data series selected, click, then double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart).</paragraph><paragraph role="paragraph">Double-click the legend to select and edit the legend. Click, then double-click a symbol in the selected legend to edit the associated data series.</paragraph><paragraph role="paragraph">Double-click any other chart element, or click the element and open the Format menu, to edit the properties.</paragraph></listitem><listitem><paragraph role="paragraph">Click outside the chart to leave the current edit mode.</paragraph></listitem></list><paragraph role="tip">To print a chart in high quality, you can export the chart to a PDF file and print that file.</paragraph><paragraph role="paragraph">In chart edit mode, you see the <link href="text/schart/main0202.xhp">Formatting Bar</link> for charts near the upper border of the document. The Drawing Bar for charts appears near the lower border of the document. The Drawing Bar shows a subset of the icons from the <link href="text/simpress/main0210.xhp">Drawing</link> toolbar of Draw and Impress.</paragraph><paragraph role="paragraph">You can right-click an element of a chart to open the context menu. The context menu offers many commands to format the selected element.</paragraph><bookmark branch="hid/.uno:FormatTitle" id="bm_id0810200903431839"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected title.</ahelp></paragraph><bookmark branch="hid/.uno:FormatChartArea" id="bm_id0810200903401642"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart area.</ahelp></paragraph><bookmark branch="hid/.uno:FormatWall" id="bm_id0810200903420337"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart wall.</ahelp></paragraph><bookmark branch="hid/.uno:FormatFloor" id="bm_id0810200903424458"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart floor.</ahelp></paragraph><bookmark branch="hid/.uno:FormatLegend" id="bm_id0810200903440259"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart legend.</ahelp></paragraph><bookmark branch="hid/.uno:FormatAxis" id="bm_id0810200903443886"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected axis.</ahelp></paragraph><bookmark branch="hid/.uno:FormatDataPoint" id="bm_id081020090345395"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected data point.</ahelp></paragraph><bookmark branch="hid/.uno:FormatMajorGrid" id="bm_id0810200903463111"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the major grid.</ahelp></paragraph><bookmark branch="hid/.uno:FormatMinorGrid" id="bm_id081020090347088"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the minor grid.</ahelp></paragraph><bookmark branch="hid/.uno:FormatDataSeries" id="bm_id0810200903475043"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the data series.</ahelp></paragraph><bookmark branch="hid/.uno:FormatStockLoss" id="bm_id0810200903483389"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the stock loss indicators.</ahelp></paragraph><bookmark branch="hid/.uno:FormatStockGain" id="bm_id0810200903491288"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the stock gain indicators.</ahelp></paragraph><bookmark branch="hid/.uno:FormatDataLabels" id="bm_id0810200903510321"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the data labels.</ahelp></paragraph><bookmark branch="hid/.uno:FormatYErrorBars" id="bm_id0810200903522796"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the Y error bars.</ahelp></paragraph><bookmark branch="hid/.uno:FormatMeanValue" id="bm_id0810200903531785"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the mean value line.</ahelp></paragraph><bookmark branch="hid/.uno:FormatTrendline" id="bm_id0810200903541347"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the trendline.</ahelp></paragraph><bookmark branch="hid/.uno:FormatTrendlineEquation" id="bm_id0810200903583324"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the trendline equation.</ahelp></paragraph><bookmark branch="hid/.uno:FormatDataLabel" id="bm_id0810200903592433"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected data label.</ahelp></paragraph><bookmark branch="hid/.uno:InsertTitles" id="bm_id0810200904002651"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert chart titles.</ahelp></paragraph><bookmark branch="hid/.uno:InsertRemoveAxes" id="bm_id0810200904070699"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert or delete axes.</ahelp></paragraph><bookmark branch="hid/.uno:InsertAxis" id="bm_id0810200904131060"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert an axis.</ahelp></paragraph><bookmark branch="hid/.uno:InsertAxisTitle" id="bm_id0810200904134569"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert an axis title.</ahelp></paragraph><bookmark branch="hid/.uno:InsertMajorGrid" id="bm_id081020090418240"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a major grid.</ahelp></paragraph><bookmark branch="hid/.uno:InsertMinorGrid" id="bm_id0810200904190029"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a minor grid.</ahelp></paragraph><bookmark branch="hid/.uno:InsertDataLabels" id="bm_id0810200904194557"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts data labels.</ahelp></paragraph><bookmark branch="hid/.uno:InsertTrendlineEquationAndR2" id="bm_id0810200904204069"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts the trendline equation and the coefficient of determination R².</ahelp></paragraph><bookmark branch="hid/.uno:InsertR2Value" id="bm_id0810200904250571"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts the coefficient of determination R² value.</ahelp></paragraph><bookmark branch="hid/.uno:InsertDataLabel" id="bm_id081020090428246"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Inserts a single data label.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteLegend" id="bm_id0810200904303930"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the chart legend.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteAxis" id="bm_id0810200904311994"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the selected axis.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteMajorGrid" id="bm_id0810200904315530"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the major grid.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteMinorGrid" id="bm_id0810200904322666"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the minor grid.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteDataLabels" id="bm_id0810200904330358"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes all data labels.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteTrendlineEquation" id="bm_id0810200904341536"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the trendline equation.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteR2Value" id="bm_id0810200904345275"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the R² value.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteDataLabel" id="bm_id0810200904354291"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the selected data label.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteMeanValue" id="bm_id0810200904405280"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the mean value line.</ahelp></paragraph><bookmark branch="hid/.uno:DeleteYErrorBars" id="bm_id0810200904413070"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Deletes the Y error bars.</ahelp></paragraph><bookmark branch="hid/.uno:ResetDataPoint" id="bm_id081020090437598"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Resets the selected data point to default format.</ahelp></paragraph><bookmark branch="hid/.uno:ResetAllDataPoints" id="bm_id0810200904383722"/><paragraph role="paragraph"><ahelp hid="." visibility="hidden">Resets all data points to default format.</ahelp></paragraph><embed href="text/shared/guide/chart_title.xhp#chart_title"/><embed href="text/shared/guide/chart_axis.xhp#chart_axis"/><embed href="text/shared/guide/chart_legend.xhp#chart_legend"/><embed href="text/shared/guide/chart_barformat.xhp#chart_barformat"/><embed href="text/schart/01/three_d_view.xhp#three_d_view"/></body></helpdocument>
PK
w�X�-u5� � text/schart/main0503.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>$[officename] Chart Features</title><filename>/text/schart/main0503.xhp</filename></topic></meta><body><section id="waskann"><paragraph role="heading" level="1"><link href="text/schart/main0503.xhp">$[officename] Chart Features</link></paragraph><paragraph role="paragraph">Charts allow you to present data so that it is easy to visualize.</paragraph></section><paragraph role="paragraph">You can create a chart from source data in a Calc spreadsheet or a Writer table. When the chart is embedded in the same document as the data, it stays linked to the data, so that the chart automatically updates when you change the source data.</paragraph><paragraph role="heading" level="3">Chart Types</paragraph><paragraph role="paragraph">Choose from a variety of 3D charts and 2D charts, such as bar charts, line charts, stock charts. You can change chart types with a few clicks of the mouse.</paragraph><paragraph role="heading" level="3">Individual Formatting</paragraph><paragraph role="paragraph">You can customize individual chart elements, such as axes, data labels, and legends, by right-clicking them in the chart, or with toolbar icons and menu commands.</paragraph></body></helpdocument>
PK
w�X text/schart/04/PK
w�X�,��& & text/schart/04/01020000.xhp<?xml version="1.0" encoding="utf-8"?>
<helpdocument version="1.0"><meta><topic><title>Shortcuts for Charts</title><filename>/text/schart/04/01020000.xhp</filename></topic></meta><body><section id="starcharttastaturbefehle"><bookmark branch="index" id="bm_id3150767"/><paragraph role="heading" level="1"><variable id="Chart_keys"><link href="text/schart/04/01020000.xhp">Shortcuts for Charts</link></variable></paragraph><paragraph role="paragraph">You can use the following shortcut keys in charts.</paragraph><paragraph role="paragraph">You can also use the general <link href="text/shared/04/01010000.xhp">shortcut keys</link> for $[officename].</paragraph></section><section id="keychart"><paragraph role="heading" level="2">Shortcuts in Charts</paragraph><section id="impressheader"><paragraph role="heading" level="3">Shortcut Keys</paragraph><paragraph role="paragraph">Results</paragraph></section><section id="Tab"><paragraph role="heading" level="3">Tab</paragraph><paragraph role="paragraph">Select next object.</paragraph></section><section id="UmTab"><paragraph role="heading" level="3">Shift+Tab</paragraph><paragraph role="paragraph">Select previous object.</paragraph></section><section id="Pos1"><paragraph role="heading" level="3">Home</paragraph><paragraph role="paragraph">Select first object.</paragraph></section><section id="End"><paragraph role="heading" level="3">End</paragraph><paragraph role="paragraph">Select last object.</paragraph></section><section id="Esc"><paragraph role="heading" level="3">Esc</paragraph><paragraph role="paragraph">Cancel selection</paragraph></section><section id="Cur"><paragraph role="heading" level="3">up/down/left/right arrow</paragraph><paragraph role="paragraph">Move the object in the direction of the arrow.</paragraph></section><section id="CurPie"><paragraph role="heading" level="3">up/down/left/right arrow in pie charts</paragraph><paragraph role="paragraph">Moves the selected pie segment in the direction of the arrow.</paragraph></section><section id="F2"><paragraph role="heading" level="3">F2 in titles</paragraph><paragraph role="paragraph">Enter text input mode.</paragraph></section><section id="F3"><paragraph role="heading" level="3">F3</paragraph><paragraph role="paragraph">Open group so that you can edit the individual components (in legend and data series).</paragraph></section><section id="StrgF3"><paragraph role="heading" level="3"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F3</paragraph><paragraph role="paragraph">Exit group (in legend and data series).</paragraph></section><section id="+-"><paragraph role="heading" level="3">+/-</paragraph><paragraph role="paragraph">Reduce or enlarge the chart</paragraph></section><section id="+-Pie"><paragraph role="heading" level="3">+/- in pie charts</paragraph><paragraph role="paragraph">Moves the selected pie segment off or into the pie chart.</paragraph></section></section><section id="relatedtopics"><embed href="text/shared/guide/keyboard.xhp#keyboard"/></section></body></helpdocument>
PK
w�X �A text/schart/PK
w�X �A* text/schart/02/PK
w�XG>�� � ��W text/schart/02/01190000.xhpPK
w�X�Jft. . ��� text/schart/02/02020000.xhpPK
w�XE��? ? ��� text/schart/02/01210000.xhpPK
w�X�63 ��l text/schart/02/01200000.xhpPK
w�X�7(�� � ��� text/schart/02/01220000.xhpPK
w�X �A� text/schart/00/PK
w�XA��< < ��� text/schart/00/00000004.xhpPK
w�X �Ab1 text/schart/01/PK
w�X���� ���1 text/schart/01/type_xy.xhpPK
w�XP��| | ���L text/schart/01/04060000.xhpPK
w�X�&ӎ� � # ���i text/schart/01/type_column_line.xhpPK
w�X�d��o o ��N� text/schart/01/05040100.xhpPK
w�X�Ģ�� � " ���� text/schart/01/wiz_data_series.xhpPK
w�X���� � ��� text/schart/01/type_line.xhpPK
w�X�E 9( ( �� � text/schart/01/03010000.xhpPK
w�Xc@��� � ! ���� text/schart/01/wiz_data_range.xhpPK
w�X�3\K K ���� text/schart/01/05020201.xhpPK
w�X(z��q q ��� text/schart/01/05040200.xhpPK
w�X��4b� � ���� text/schart/01/05120000.xhpPK
w�X6Yͬ� � ��� text/schart/01/type_pie.xhpPK
w�X6h � $ �� text/schart/01/choose_chart_type.xhpPK
w�X� �� � ��Z text/schart/01/05040201.xhpPK
w�X�ג�� � ) ��"' text/schart/01/smooth_line_properties.xhpPK
w�X>t��� � ��D/ text/schart/01/05050000.xhpPK
w�X�|�>� � ��I6 text/schart/01/05020000.xhpPK
w�X-7 7 ��}< text/schart/01/04030000.xhpPK
w�X�z}�G G ���Q text/schart/01/05050100.xhpPK
w�X���ã
�
��mV text/schart/01/04010000.xhpPK
w�X�U㻽 � ��Ia text/schart/01/05060000.xhpPK
w�X��� � ��?e text/schart/01/05010200.xhpPK
w�X��؇� � ��'k text/schart/01/05040202.xhpPK
w�X����g g ��{ text/schart/01/05010000.xhpPK
w�X�E�� � % ���� text/schart/01/wiz_chart_elements.xhpPK
w�X=Q݉� � ���� text/schart/01/04020000.xhpPK
w�XPE�D� � ��Ұ text/schart/01/05020101.xhpPK
w�X^�B� � * ��۴ text/schart/01/stepped_line_properties.xhpPK
w�XҀ��_< _< ��!� text/schart/01/04050100.xhpPK
w�X:N-g�, �, ���� text/schart/01/three_d_view.xhpPK
w�XkG�C� � ���& text/schart/01/05070000.xhpPK
w�XJ�Ǖ� � ���* text/schart/01/05080000.xhpPK
w�X�R�b`5 `5 ���. text/schart/01/type_stock.xhpPK
w�X~��� � ��\d text/schart/01/type_area.xhpPK
w�XK�� � ��>m text/schart/01/type_bubble.xhpPK
w�X�VI1* * ��s text/schart/01/05030000.xhpPK
w�X�H��_ _ ��|w text/schart/01/04070000.xhpPK
w�X��1� � ! ��� text/schart/01/wiz_chart_type.xhpPK
w�X����
�
" ���� text/schart/01/type_column_bar.xhpPK
w�Xz�# ��
� text/schart/01/05020200.xhpPK
w�XU�v
� � ��T� text/schart/01/05040000.xhpPK
w�Xp��" ���� text/schart/01/05010100.xhpPK
w�XlX�r ��ع text/schart/01/05020100.xhpPK
w�Xˁ'%a a ��!� text/schart/01/04050000.xhpPK
w�X]$� S S ���� text/schart/01/04040000.xhpPK
w�XY���� � ��G� text/schart/01/type_net.xhpPK
w�XF3�� � ��#� text/schart/main0202.xhpPK
w�X�����/ �/ ��� text/schart/main0000.xhpPK
w�X�-u5� � ��( text/schart/main0503.xhpPK
w�X �AI- text/schart/04/PK
w�X�,��& & ��v- text/schart/04/01020000.xhpPK = = y �9