From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/schart/01/03010000.xhp | 84 +++++++ helpcontent2/source/text/schart/01/04010000.xhp | 70 ++++++ helpcontent2/source/text/schart/01/04020000.xhp | 88 +++++++ helpcontent2/source/text/schart/01/04030000.xhp | 97 ++++++++ helpcontent2/source/text/schart/01/04040000.xhp | 64 +++++ helpcontent2/source/text/schart/01/04050000.xhp | 125 ++++++++++ helpcontent2/source/text/schart/01/04050100.xhp | 209 ++++++++++++++++ helpcontent2/source/text/schart/01/04060000.xhp | 98 ++++++++ helpcontent2/source/text/schart/01/04070000.xhp | 83 +++++++ helpcontent2/source/text/schart/01/05010000.xhp | 61 +++++ helpcontent2/source/text/schart/01/05010100.xhp | 49 ++++ helpcontent2/source/text/schart/01/05010200.xhp | 45 ++++ helpcontent2/source/text/schart/01/05020000.xhp | 53 ++++ helpcontent2/source/text/schart/01/05020100.xhp | 51 ++++ helpcontent2/source/text/schart/01/05020101.xhp | 47 ++++ helpcontent2/source/text/schart/01/05020200.xhp | 45 ++++ helpcontent2/source/text/schart/01/05020201.xhp | 95 ++++++++ helpcontent2/source/text/schart/01/05030000.xhp | 41 ++++ helpcontent2/source/text/schart/01/05040000.xhp | 51 ++++ helpcontent2/source/text/schart/01/05040100.xhp | 43 ++++ helpcontent2/source/text/schart/01/05040200.xhp | 46 ++++ helpcontent2/source/text/schart/01/05040201.xhp | 95 ++++++++ helpcontent2/source/text/schart/01/05040202.xhp | 82 +++++++ helpcontent2/source/text/schart/01/05050000.xhp | 56 +++++ helpcontent2/source/text/schart/01/05050100.xhp | 53 ++++ helpcontent2/source/text/schart/01/05060000.xhp | 45 ++++ helpcontent2/source/text/schart/01/05070000.xhp | 48 ++++ helpcontent2/source/text/schart/01/05080000.xhp | 45 ++++ helpcontent2/source/text/schart/01/05120000.xhp | 47 ++++ .../source/text/schart/01/choose_chart_type.xhp | 142 +++++++++++ .../text/schart/01/smooth_line_properties.xhp | 64 +++++ .../text/schart/01/stepped_line_properties.xhp | 53 ++++ .../source/text/schart/01/three_d_view.xhp | 170 +++++++++++++ helpcontent2/source/text/schart/01/type_area.xhp | 54 +++++ helpcontent2/source/text/schart/01/type_bubble.xhp | 50 ++++ .../source/text/schart/01/type_column_bar.xhp | 61 +++++ .../source/text/schart/01/type_column_line.xhp | 143 +++++++++++ helpcontent2/source/text/schart/01/type_line.xhp | 58 +++++ helpcontent2/source/text/schart/01/type_net.xhp | 54 +++++ helpcontent2/source/text/schart/01/type_pie.xhp | 54 +++++ helpcontent2/source/text/schart/01/type_stock.xhp | 266 +++++++++++++++++++++ helpcontent2/source/text/schart/01/type_xy.xhp | 117 +++++++++ .../source/text/schart/01/wiz_chart_elements.xhp | 104 ++++++++ .../source/text/schart/01/wiz_chart_type.xhp | 94 ++++++++ .../source/text/schart/01/wiz_data_range.xhp | 79 ++++++ .../source/text/schart/01/wiz_data_series.xhp | 102 ++++++++ 46 files changed, 3681 insertions(+) create mode 100644 helpcontent2/source/text/schart/01/03010000.xhp create mode 100644 helpcontent2/source/text/schart/01/04010000.xhp create mode 100644 helpcontent2/source/text/schart/01/04020000.xhp create mode 100644 helpcontent2/source/text/schart/01/04030000.xhp create mode 100644 helpcontent2/source/text/schart/01/04040000.xhp create mode 100644 helpcontent2/source/text/schart/01/04050000.xhp create mode 100644 helpcontent2/source/text/schart/01/04050100.xhp create mode 100644 helpcontent2/source/text/schart/01/04060000.xhp create mode 100644 helpcontent2/source/text/schart/01/04070000.xhp create mode 100644 helpcontent2/source/text/schart/01/05010000.xhp create mode 100644 helpcontent2/source/text/schart/01/05010100.xhp create mode 100644 helpcontent2/source/text/schart/01/05010200.xhp create mode 100644 helpcontent2/source/text/schart/01/05020000.xhp create mode 100644 helpcontent2/source/text/schart/01/05020100.xhp create mode 100644 helpcontent2/source/text/schart/01/05020101.xhp create mode 100644 helpcontent2/source/text/schart/01/05020200.xhp create mode 100644 helpcontent2/source/text/schart/01/05020201.xhp create mode 100644 helpcontent2/source/text/schart/01/05030000.xhp create mode 100644 helpcontent2/source/text/schart/01/05040000.xhp create mode 100644 helpcontent2/source/text/schart/01/05040100.xhp create mode 100644 helpcontent2/source/text/schart/01/05040200.xhp create mode 100644 helpcontent2/source/text/schart/01/05040201.xhp create mode 100644 helpcontent2/source/text/schart/01/05040202.xhp create mode 100644 helpcontent2/source/text/schart/01/05050000.xhp create mode 100644 helpcontent2/source/text/schart/01/05050100.xhp create mode 100644 helpcontent2/source/text/schart/01/05060000.xhp create mode 100644 helpcontent2/source/text/schart/01/05070000.xhp create mode 100644 helpcontent2/source/text/schart/01/05080000.xhp create mode 100644 helpcontent2/source/text/schart/01/05120000.xhp create mode 100644 helpcontent2/source/text/schart/01/choose_chart_type.xhp create mode 100644 helpcontent2/source/text/schart/01/smooth_line_properties.xhp create mode 100644 helpcontent2/source/text/schart/01/stepped_line_properties.xhp create mode 100644 helpcontent2/source/text/schart/01/three_d_view.xhp create mode 100644 helpcontent2/source/text/schart/01/type_area.xhp create mode 100644 helpcontent2/source/text/schart/01/type_bubble.xhp create mode 100644 helpcontent2/source/text/schart/01/type_column_bar.xhp create mode 100644 helpcontent2/source/text/schart/01/type_column_line.xhp create mode 100644 helpcontent2/source/text/schart/01/type_line.xhp create mode 100644 helpcontent2/source/text/schart/01/type_net.xhp create mode 100644 helpcontent2/source/text/schart/01/type_pie.xhp create mode 100644 helpcontent2/source/text/schart/01/type_stock.xhp create mode 100644 helpcontent2/source/text/schart/01/type_xy.xhp create mode 100644 helpcontent2/source/text/schart/01/wiz_chart_elements.xhp create mode 100644 helpcontent2/source/text/schart/01/wiz_chart_type.xhp create mode 100644 helpcontent2/source/text/schart/01/wiz_data_range.xhp create mode 100644 helpcontent2/source/text/schart/01/wiz_data_series.xhp (limited to 'helpcontent2/source/text/schart/01') diff --git a/helpcontent2/source/text/schart/01/03010000.xhp b/helpcontent2/source/text/schart/01/03010000.xhp new file mode 100644 index 000000000..913028931 --- /dev/null +++ b/helpcontent2/source/text/schart/01/03010000.xhp @@ -0,0 +1,84 @@ + + + + + + + + + + +Data Table +/text/schart/01/03010000.xhp + + + + + + +Data Table +Opens the Data Table dialog where you can edit the chart data. +The Data Table dialog is not available if you insert a chart that is based on a Calc sheet or on a Writer table.UFI: fixes #i31208# + +To update a chart manually when a Writer table got changedi81240 + +Some changes will become visible only after you close and reopen the dialog.UFI: fixes #i22854#still so? +
+ +
+ +To change chart data +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. +Close the Chart Data dialog to apply all changes to the chart. Choose Edit - Undo to cancel the changes. + + +Insert or select a chart that is not based on existing cell data. + + +Choose View - Chart Data Table to open the Data Table dialog. +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. + + +Click a cell in the dialog and change the contents. Click another cell to see the changed contents in the preview. + + +Enter the name of the data series in the text box above the column. + + +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. Regina: see issue 72901 + + +The order of the data series in the chart is the same as in the data table. Use the Move Series Right icon to switch the current column with its neighbor on the right.changed names, see i79863 + + +The order of the categories or data points in the chart is the same as in the data table. Use the Move Row Down icon to switch the current row with its neighbor below. + + +insert rowInserts a new row below the current row. +insert seriesInserts a new data series after the current column. +insert text columnInserts a new text column after the current column for hierarchical axes descriptions. +delete rowDeletes the current row. It is not possible to delete the label row. +delete seriesDeletes the current series or text column. It is not possible to delete the first text column. +move series rightSwitches the current column with its neighbor at the right. +move series leftSwitches the current column with its neighbor at the left. +move row downSwitches the current row with its neighbor below.edit fields, see i72361 +move row upSwitches the current row with its neighbor above.edit fields, see i72361 +Enter names for the data series. + + diff --git a/helpcontent2/source/text/schart/01/04010000.xhp b/helpcontent2/source/text/schart/01/04010000.xhp new file mode 100644 index 000000000..e43178701 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04010000.xhp @@ -0,0 +1,70 @@ + + + + + + + + + + +Titles +/text/schart/01/04010000.xhp + + + + + + +Titles +Opens a dialog to enter or modify the titles in a chart. + You can define the text for the main title, subtitle and the axis labels, and specify if they are displayed. +
+ +
+ +Title +Enter the desired title for the chart. This will be displayed at the top of the chart. + +Subtitle +Enter the desired subtitle for the chart. This will be displayed under the title set in the Title field. + +Axes + +X axis +Enter the desired title for the X axis of the chart. + + +Y axis +Enter the desired title for the Y axis of the chart. + + +Z axis +Enter the desired title for the Z axis of the chart. This option is only available for 3-D charts. + +Secondary Axes +X axis + +Enter the desired secondary title for the X axis of the chart. This will appear on the opposite side of the chart as the X axis title. + +Y axis + +Enter the desired secondary title for the Y axis of the chart. This will appear on the opposite side of the chart as the Y axis title. + + diff --git a/helpcontent2/source/text/schart/01/04020000.xhp b/helpcontent2/source/text/schart/01/04020000.xhp new file mode 100644 index 000000000..3837b670e --- /dev/null +++ b/helpcontent2/source/text/schart/01/04020000.xhp @@ -0,0 +1,88 @@ + + + + + + + + +Legend +/text/schart/01/04020000.xhp + + + + + +chart legends; hiding +hiding;chart legends + + +Legend +Opens the Legend dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed. + +
+ +
+ +To show or hide a legend, click Legend On/Off on the Formatting bar. + + + + + +Icon + + + +Legend On/Off + + +
+ + +Display +Specifies whether to display a legend for the chart. This option is only visible if you call the dialog by choosing Insert - Legend. +Position +Select the position for the legend: + + +Left +Positions the legend at the left of the chart. + + +Top +Positions the legend at the top of the chart. + + +Right +Positions the legend at the right of the chart. + + +Bottom +Positions the legend at the bottom of the chart. +Text Orientation +This feature is only available if complex text layout support is enabled in %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. + +Text Direction +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. + +Overlay +Specifies whether the legend should overlap the chart. Turning off this option is useful if you want to display the legend above an empty part of the chart area instead of beside it. This way the drawing area can fill the whole chart area, increasing its readability. + + diff --git a/helpcontent2/source/text/schart/01/04030000.xhp b/helpcontent2/source/text/schart/01/04030000.xhp new file mode 100644 index 000000000..8d56974b8 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04030000.xhp @@ -0,0 +1,97 @@ + + + + + + + + + Data Labels + /text/schart/01/04030000.xhp + + + +data labels in charts + labels; for charts + charts; data labels + data values in charts + chart legends; showing icons with labels + + + + + + +
+

Data Labels +

+ Opens the Data Labels dialog, which enables you to set the data labels. + +
+
+ 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. +
+
+ +
+ + +

Show value as number

+ Displays the absolute values of the data points. + + +

Number format

+ Opens a dialog to select the number format. + + +

Show value as percentage

+ Displays the percentage of the data points in each column. + + +

Percentage format

+ Opens a dialog to select the percentage format. + + +

Show category

+ Shows the data point text labels. + + +

Show legend key

+ Displays the legend icons next to each data point label. + + +

Separator

+ Selects the separator between multiple text strings for the same object. + + +

Placement

+ Selects the placement of data labels relative to the objects. + + +

Text Direction

+ 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. + + +

Rotate Text

+ Click in the dial to set the text orientation for the data labels. + + +Enter the counterclockwise rotation angle for the data labels. + + diff --git a/helpcontent2/source/text/schart/01/04040000.xhp b/helpcontent2/source/text/schart/01/04040000.xhp new file mode 100644 index 000000000..159f699c2 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04040000.xhp @@ -0,0 +1,64 @@ + + + + + + + + + + +Axes +/text/schart/01/04040000.xhp + + + + +axes; showing axes in charts +charts; showing axes +X axes; showing +Y axes; showing +Z axes; showing +axes; better scaling +secondary axes in charts +mw made "secondary axes;" a one level entry, deleted "charts; showing secondary axes" and generated one "axes;" entry out of two "axes;showing..." entries + + +Axes +Specifies the axes to be displayed in the chart. + +
+ +
+Major axis +X axis +Displays the X axis as a line with subdivisions. +Y axis +Displays the Y axis as a line with subdivisions. +Z axis +Displays the Z axis as a line with subdivisions. This axis can only be displayed in 3D charts. +Secondary axis +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. +X axis +Displays a secondary X axis in the chart. +Y axis +Displays a secondary Y axis in the chart. +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. + + diff --git a/helpcontent2/source/text/schart/01/04050000.xhp b/helpcontent2/source/text/schart/01/04050000.xhp new file mode 100644 index 000000000..591be0c84 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04050000.xhp @@ -0,0 +1,125 @@ + + + + + + + + +X/Y Error Bars +/text/schart/01/04050000.xhp + + + + + + + + +X/Y Error Barsi85330 +Use the X or Y Error Bars dialog to display error bars for 2D charts. + + +
+ +
+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. +The Insert - X/Y Error Bars menu command is only available for 2D charts. +Error category +In the Error category area, you can choose different ways to display the error category. + + +None +Does not show any error bars. + + +Constant value +Displays constant values that you specify in the Parameters area. + + +Percentage +Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area. + + + + +Functions +Select a function to calculate the error bars. +Standard Error: Displays the standard error. +Variance: Displays the variance calculated from the number of data points and respective values. +Standard Deviation: Displays the standard deviation (square root of the variance). Unlike other functions, error bars are centered on the mean. +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. + + + +Cell Range +Click Cell Range and then specify a cell range from which to take the positive and negative error bar values. + + + + +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. + + +From Data Table +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. + +Positive (+) + + +Enter the value to add to the displayed value as the positive error value. + +Negative (-) + + +Enter the value to subtract from the displayed value as the negative error value. + +Positive (+) when Cell Range is selected + + +Enter the address range from where to get the positive error values. Use the Shrink button to select the range from a sheet. + +Negative (-) when Cell Range is selected + + +Enter the address range from where to get the negative error values. Use the Shrink button to select the range from a sheet. + + + +Same value for both +Enable to use the positive error values also as negative error values. You can only change the value of the "Positive (+)" box. That value gets copied to the "Negative (-)" box automatically. +Error Indicator +Specifies the error indicator. + + +Positive and Negative +Shows positive and negative error bars. + + +Positive +Shows only positive error bars. + + +Negative +Shows only negative error bars. +
+ +
+ + diff --git a/helpcontent2/source/text/schart/01/04050100.xhp b/helpcontent2/source/text/schart/01/04050100.xhp new file mode 100644 index 000000000..4569d9bc5 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04050100.xhp @@ -0,0 +1,209 @@ + + + + + + + Trend Lines + /text/schart/01/04050100.xhp + + + + + + + calculating;regression curves + regression curves in charts + trend lines in charts + mean value lines in charts + +only use trend line, not regression curve: i89823 + + + + + Trend Lines + Trend lines can be added to all 2D chart types except for Pie and Stock charts. + +
+ +
Linear + +A linear trend line is shown.Logarithmic + +A logarithmic trend line is shown.Exponential + +An exponential trend line is shown.Power + +A power trend line is shown.Polynomial + +A polynomial trend line is shown with a given degree.Degree + + +Degree of polynomial trend line.Moving average + +A moving average trend line is shown with a given period.Period + + +Number of points to calculate average of moving average trend line.Trend line name + + +Name of trend line in legend.Extrapolate forward + + +Trend line is extrapolated for higher x-values.Extrapolate backward + + +Trend line is extrapolated for lower x-values.Force intercept + +For linear, polynomial and exponential trend lines, intercept value is forced to a given value.Intercept value + +Value of intercept if it is forced.Show equation + +Shows the trend line equation next to the trend line.Show correlation coefficient (R2) + +Shows the coefficient of determination next to the trend line.X name + + +Name of X variable in trend line equation.Y name + + +Name of Y variable in trend line equation. +If you insert a trend line to a chart type that uses categories, like Line or Column, then the numbers 1, 2, 3, … are used as x-values to calculate the trend line. For such charts the XY chart type might be more suitable. + + + + + To insert a trend line for a data series, first double-click the chart to enter edit mode and select the data series in the chart to which a trend line is to be created. + + + Choose Insert - Trend Line, or right-click the data series to open the context menu, and choose Insert Trend Line. + + + Mean Value Lines are special trend lines that show the mean value. Use Insert - Mean Value Lines to insert mean value lines for data series. + + + To delete a trend line or mean value line, click the line, then press the Del key. + + +The menu item Insert - Trend Line is only available when the chart is in edit mode. It will appear grayed out if the chart is in edit mode but no data series is selected. +The trend line has the same color as the corresponding data series. To change the line properties, select the trend line and choose Format - Format Selection - Line. +A trend line is shown in the legend automatically. Its name can be defined in options of the trend line. + + +Trend Line Equation and Coefficient of Determination + +When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R2, even if they are not shown: click on the trend line to see the information in the status bar. +To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. +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 Format Trend Line Equation - Numbers. +Default equation uses x for abscissa variable, and f(x) for ordinate variable. To change these names, select the trend line, choose Format - Format Selection – Type and enter names in X Variable Name and Y Variable Name edit boxes. + +To show the coefficient of determination R2, select the equation in the chart, right-click to open the context menu, and choose Insert R2. +If intercept is forced, coefficient of determination R2 is not calculated in the same way as with free intercept. R2 values can not be compared with forced or free intercept. + +Trend Lines Curve Types +The following regression types are available: + + + + Linear trend line: regression through equation y=a∙x+b. Intercept b can be forced. + + + Polynomial trend line: regression through equation y=Σi(ai∙xi). Intercept a0 can be forced. Degree of polynomial must be given (at least 2). + + + Logarithmic trend line: regression through equation y=a∙ln(x)+b. + + + Exponential trend line: regression through equation y=b∙exp(a∙x).This equation is equivalent to y=b∙mx with m=exp(a). Intercept b can be forced. + + + Power trend line: regression through equation y=b∙xa. + + + Moving average trend line: simple moving average is calculated with the n previous y-values, n being the period. No equation is available for this trend line. + + +Constraints + The calculation of the trend line considers only data pairs with the following values: + + + + Logarithmic trend line: only positive x-values are considered. + + + Exponential trend line: only positive y-values are considered, except if all y-values are negative: regression will then follow equation y=-b∙exp(a∙x). + + + 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 y=-b∙xa. + +You should transform your data accordingly; it is best to work on a copy of the original data and transform the copied data. + +Calculate Parameters in Calc +You can also calculate the parameters using Calc functions as follows. + +The linear regression equation +The linear regression follows the equation y=m*x+b. +m = SLOPE(Data_Y;Data_X) +b = INTERCEPT(Data_Y ;Data_X) +Calculate the coefficient of determination by +r2 = RSQ(Data_Y;Data_X) +Besides m, b and r2 the array function LINEST provides additional statistics for a regression analysis. + +The logarithmic regression equation +The logarithmic regression follows the equation y=a*ln(x)+b. +a = SLOPE(Data_Y;LN(Data_X)) +b = INTERCEPT(Data_Y ;LN(Data_X)) +r2 = RSQ(Data_Y;LN(Data_X)) + +The exponential regression equation + 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. +The exponential regression follows the equation y=b*exp(a*x) or y=b*mx, which is transformed to ln(y)=ln(b)+a*x or ln(y)=ln(b)+ln(m)*x respectively. +a = SLOPE(LN(Data_Y);Data_X) +The variables for the second variation are calculated as follows: +m = EXP(SLOPE(LN(Data_Y);Data_X)) +b = EXP(INTERCEPT(LN(Data_Y);Data_X)) +Calculate the coefficient of determination by +r2 = RSQ(LN(Data_Y);Data_X) +Besides m, b and r2 the array function LOGEST provides additional statistics for a regression analysis. + +The power regression equation + For power regression curves a transformation to a linear model takes place. The power regression follows the equation y=b*xa, which is transformed to ln(y)=ln(b)+a*ln(x). +a = SLOPE(LN(Data_Y);LN(Data_X)) +b = EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) +r2 = RSQ(LN(Data_Y);LN(Data_X)) + +The polynomial regression equation +For polynomial regression curves a transformation to a linear model takes place. +Create a table with the columns x, x2, x3, … , xn, y up to the desired degree n. +Use the formula =LINEST(Data_Y,Data_X) with the complete range x to xn (without headings) as Data_X. +The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xn at the leftmost position. +The first element of the third row of the LINEST output is the value of r2. See the LINEST function for details on proper use and an explanation of the other output parameters. + +
+X/Y Error Bars +LINEST function +LOGEST function +SLOPE function +INTERCEPT function +RSQ function +
+ + + diff --git a/helpcontent2/source/text/schart/01/04060000.xhp b/helpcontent2/source/text/schart/01/04060000.xhp new file mode 100644 index 000000000..b014fcb84 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04060000.xhp @@ -0,0 +1,98 @@ + + + + + + + + + Options + /text/schart/01/04060000.xhp + + + + + + +
+aligning; 2D charts + charts; aligning + pie charts;options + + +Options + 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. +
+
+ +
+ Align data series to: + In this area you can choose between two Y axis scaling modes. The axes can only be scaled and given properties separately. + +Primary Y axis + This option is active as default. All data series are aligned to the primary Y axis. + +Secondary Y axis + 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. + Settings + 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. + +Spacing + Defines the spacing between the columns in percent. The maximal spacing is 600%. + +Overlap + Defines the necessary settings for overlapping data series. You can choose between -100 and +100%. + +Connection Lines + For "stacked" and "percent" column (vertical bar) charts, mark this check box to connect the column layers that belong together with lines. + +Show bars side by side + 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. + 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. The bars from different data series are shown as if they were attached only to one axis. + +Clockwise direction + Available for pie and donut charts. The default direction in which the pieces of a pie chart are ordered is counterclockwise. Enable the Clockwise direction checkbox to draw the pieces in opposite direction. + +Starting angle + 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. + 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. + 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). + +Degrees + Enter the starting angle between 0 and 359 degrees. You can also click the arrows to change the displayed value. + Plot missing values + 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. + +Leave gap + For a missing value, no data will be shown. This is the default for chart types Column, Bar, Line, Net. + +Assume zero + For a missing value, the y-value will be shown as zero. This is the default for chart type Area. + +Continue line + For a missing value, the interpolation from the neighbor values will be shown. This is the default for chart type XY. + +Include values from hidden cells + Check to also show values of currently hidden cells within the source cell range. + + +Hide legend entry + Do not show legend entry for the selected data series or data point. + + diff --git a/helpcontent2/source/text/schart/01/04070000.xhp b/helpcontent2/source/text/schart/01/04070000.xhp new file mode 100644 index 000000000..25e670927 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04070000.xhp @@ -0,0 +1,83 @@ + + + + + + + Grids + /text/schart/01/04070000.xhp + + + + + + + axes; inserting grids + grids; inserting in charts + + + + + + +Grids +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. The Y axis major grid is activated by default. + +
+ +
+ +Major grids +Defines the axis to be set as the major grid. + + +X axis +Adds gridlines to the X axis of the chart. + +The Vertical Grids icon on the Formatting bar toggles the visibility of the grid display for the X axis. It switches between the three states: no grid, major grid and both major and minor grids displayed. The change will affect check boxes in Insert - Grids. + + + +Y axis +Adds gridlines to the Y axis of the chart. + +The Horizontal Grids icon on the Formatting bar toggles the visibility of the grid display for the Y axis. It switches between the three states: no grid, major grid and both major and minor grids displayed. The change will affect check boxes in Insert - Grids. + + + +Z axis +Adds gridlines to the Z axis of the chart. This option is only available if you're working with 3D charts. + +Minor grids +Use this area to assign a minor grid for each axis. Assigning minor grids to the axis reduces the distance between the major grids. + + +X axis +Adds gridlines that subdivide the X axis into smaller sections. + + +Y axis +Adds gridlines that subdivide the Y axis into smaller sections. + + +Z axis +Adds gridlines that subdivide the Z axis into smaller sections. This option is only available if you're working with 3D charts. + + + diff --git a/helpcontent2/source/text/schart/01/05010000.xhp b/helpcontent2/source/text/schart/01/05010000.xhp new file mode 100644 index 000000000..217bb479a --- /dev/null +++ b/helpcontent2/source/text/schart/01/05010000.xhp @@ -0,0 +1,61 @@ + + + + + + + + +Format Selection +/text/schart/01/05010000.xhp + + + +objects;properties of charts +charts; properties +properties;charts +mw changed "properties;" + +Format Selection +Formats the selected object. + Depending on the object selected, the command opens dialogs that you can also open by choosing the following commands from the Format menu: +
+ +
+Chart Wall + +Chart Area + +Chart Floor + +Title + +Legend + +X Axis + +Y Axis + +Grid + + + + + + diff --git a/helpcontent2/source/text/schart/01/05010100.xhp b/helpcontent2/source/text/schart/01/05010100.xhp new file mode 100644 index 000000000..bd3d9c576 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05010100.xhp @@ -0,0 +1,49 @@ + + + + + +Data Point +/text/schart/01/05010100.xhp + + +Sun Microsystems, Inc. + + + + + +
+

Data Point

+ 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 Format - Format Selection. Some of the menu entries are only available for 2D or 3D charts. +
+ 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. +
+ +
+ + + + + + + + + + diff --git a/helpcontent2/source/text/schart/01/05010200.xhp b/helpcontent2/source/text/schart/01/05010200.xhp new file mode 100644 index 000000000..1a30f576c --- /dev/null +++ b/helpcontent2/source/text/schart/01/05010200.xhp @@ -0,0 +1,45 @@ + + + + + +Data Series +/text/schart/01/05010200.xhp + + + +
+

Data Series

+Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose Format - Format Selection. Some of the menu entries are only available for 2D or 3D charts. +
+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. +
+ +
+ + + + + +

Y Error Bars

+ + + + + diff --git a/helpcontent2/source/text/schart/01/05020000.xhp b/helpcontent2/source/text/schart/01/05020000.xhp new file mode 100644 index 000000000..b7429313a --- /dev/null +++ b/helpcontent2/source/text/schart/01/05020000.xhp @@ -0,0 +1,53 @@ + + + + + + + + +Title +/text/schart/01/05020000.xhp + + +Sun Microsystems, Inc. + + + + + + titles; formatting chartsformatting; chart titlesTitle + The Title menu command opens a submenu for editing the properties of the titles in the chart. +
+ +
+ Main title + + Subtitle + + X-axis title + + Y-axis title + + Z-axis title + + All titles + + + diff --git a/helpcontent2/source/text/schart/01/05020100.xhp b/helpcontent2/source/text/schart/01/05020100.xhp new file mode 100644 index 000000000..ed7da3e86 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05020100.xhp @@ -0,0 +1,51 @@ + + + + + + + + + Title + /text/schart/01/05020100.xhp + + + +editing; titles + + + + + + +moved the subtitle bookmark here from 0502020 +Title + Modifies the properties of the selected title. + +
+ +
+ + + + + + + + diff --git a/helpcontent2/source/text/schart/01/05020101.xhp b/helpcontent2/source/text/schart/01/05020101.xhp new file mode 100644 index 000000000..bc0bf588e --- /dev/null +++ b/helpcontent2/source/text/schart/01/05020101.xhp @@ -0,0 +1,47 @@ + + + + + + + + +Alignment +/text/schart/01/05020101.xhp + + +Sun Microsystems, Inc. + + + +
+aligning;titles in charts +titles;alignment (charts) + +Alignment +Modifies the alignment of the chart title. +
+Some of the options are not available for all types of labels. For example, there are different options for 2D and 3D object labels. +
+ +
+ +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. + + diff --git a/helpcontent2/source/text/schart/01/05020200.xhp b/helpcontent2/source/text/schart/01/05020200.xhp new file mode 100644 index 000000000..d8b2a0bb1 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05020200.xhp @@ -0,0 +1,45 @@ + + + + + +Title +/text/schart/01/05020200.xhp + + +Sun Microsystems, Inc. + + + + + +

Title

+Modifies the properties of the selected title or the properties of all titles together. + +
+ +
+ + + + + + + + diff --git a/helpcontent2/source/text/schart/01/05020201.xhp b/helpcontent2/source/text/schart/01/05020201.xhp new file mode 100644 index 000000000..7aec8a242 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05020201.xhp @@ -0,0 +1,95 @@ + + + + + + + + +Alignment +/text/schart/01/05020201.xhp + + + +
+ + + + +Alignmentnew name: Label +Modifies the alignment of axes or title labels. +
+Some of the options listed here are not available for all labels. For example, there are different options for 2D and 3D object labels. +
+ +
+ +Show labels +Specifies whether to show or hide the axis labels. + +The AxesTitle On/Off icon on the Formatting bar switches the labeling of all axes on or off. + + +
+Rotate text +Defines the text direction of cell contents. Click one of the ABCD buttons to assign the required direction. + + +ABCD wheel +Clicking anywhere on the wheel defines the variable text orientation. The letters "ABCD" on the button correspond to the new setting. + + +ABCD button +Assigns vertical text orientation for cell contents. +If you define a vertical x-axis label, the text may be cut off by the line of the x-axis. + + +Degrees +Allows you to manually enter the orientation angle. +
+Text flow +Determines the text flow of the data label. + +Overlap +Specifies that the text in cells may overlap other cells. This can be especially useful if there is a lack of space. This option is not available with different title directions. + +Break +Allows a text break. +The following options are not available for all chart types: +Order +The options on this tab are only available for a 2D chart, under Format - Axis - Y Axis or X Axis. In this area, you can define the alignment of the number labels on the X or Y axis. + +Tile +Arranges numbers on the axis side by side. + +Stagger odd +Staggers numbers on the axis, even numbers lower than odd numbers. + +Stagger even +Stagger numbers on the axes, odd numbers lower than even numbers. + +Automatic +Automatically arranges numbers on the axis. +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. + +need to create a new Equation dialog box main page with links to sub pages later. This page then contains only the Text Direction control. +Text Direction +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. + + diff --git a/helpcontent2/source/text/schart/01/05030000.xhp b/helpcontent2/source/text/schart/01/05030000.xhp new file mode 100644 index 000000000..05cb1381d --- /dev/null +++ b/helpcontent2/source/text/schart/01/05030000.xhp @@ -0,0 +1,41 @@ + + + + + +Legend +/text/schart/01/05030000.xhp + + + +

Legend

+Defines the border, area and character attributes for a legend. + +
+ +
+ + + + +

Display

+ + + + diff --git a/helpcontent2/source/text/schart/01/05040000.xhp b/helpcontent2/source/text/schart/01/05040000.xhp new file mode 100644 index 000000000..e91100622 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05040000.xhp @@ -0,0 +1,51 @@ + + + + + + + + + + +Axis +/text/schart/01/05040000.xhp + + + +Axis +This opens a submenu to edit axial properties. +The tabs in the dialogs depend on the chart type selected. +
+ +
+X axis + +Y axis + +Secondary X Axis +Opens a dialog where you can edit the properties of the secondary X axis. To insert a secondary X axis, choose Insert - Axes and select X axis. +Secondary Y Axis +Opens a dialog where you can edit the properties of the secondary Y axis. To insert a secondary Y axis, choose Insert - Axes and select Y axis. +Z axis + +All axes + + + diff --git a/helpcontent2/source/text/schart/01/05040100.xhp b/helpcontent2/source/text/schart/01/05040100.xhp new file mode 100644 index 000000000..b9c1f17ff --- /dev/null +++ b/helpcontent2/source/text/schart/01/05040100.xhp @@ -0,0 +1,43 @@ + + + + + +Axes +/text/schart/01/05040100.xhp + + + +axes;formatting +mw changed "X axes;" to "axes;" + + +

Axes

+Opens a dialog, where you can edit the properties of the selected axis. + The name of the dialog depends on the selected axis. +
+ +
+The Y axis has an enhanced dialog. For X-Y charts, the X axis chart is also enhanced by the Scaling tab. +Scaling the X axis is only possible in the X-Y chart type. + + + + + diff --git a/helpcontent2/source/text/schart/01/05040200.xhp b/helpcontent2/source/text/schart/01/05040200.xhp new file mode 100644 index 000000000..16ecdded5 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05040200.xhp @@ -0,0 +1,46 @@ + + + + + + + + +Y Axis +/text/schart/01/05040200.xhp + + + +Y axes; formatting + + +

Y Axis

+Opens the Y Axis dialog, to change properties of the Y axis. + +
+ +
+ + + + + + + + diff --git a/helpcontent2/source/text/schart/01/05040201.xhp b/helpcontent2/source/text/schart/01/05040201.xhp new file mode 100644 index 000000000..411ec9837 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05040201.xhp @@ -0,0 +1,95 @@ + + + + + + + + +Scale +/text/schart/01/05040201.xhp + + + + +
+scaling; axes +logarithmic scaling along axes +charts;scaling axes +X axes;scaling +Y axes; scaling +mw changed "axes;scaling" to "Y axes, scaling" +Scale +Controls the scaling of the X or Y axis. +
+
+ +
+The axes are automatically scaled by $[officename] so that all values are optimally displayed. +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. +Scale +You can enter values for subdividing axes in this area. You can automatically set the properties Minimum, Maximum, Major interval, Minor interval count and Reference value. + +Minimum +Defines the minimum value for the beginning of the axis. + +Maximum +Defines the maximum value for the end of the axis. + +Major interval +Defines the interval for the main division of the axes. The main interval cannot be larger than the value area. + +Minor interval count +Defines the interval for the subdivision of the axes. + +Reference value +Specifies at which position to display the values along the axis. + + + + + + +Automatic +You must first deselect the Automatic option in order to modify the values. +Disable this feature if you are working with "fixed" values, as it does not permit automatic scaling. + +Logarithmic scale +Specifies that you want the axis to be subdivided logarithmically. +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. + + +Reverse direction +Defines where the lower and where the higher values are displayed at the axis. The unchecked state is the mathematical direction. 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. + + +Type +For some types of axes, you can select to format an axis as text or date, or to detect the type automatically. For the axis type "Date" you can set the following options. +Minimum and maximum value to be shown on the ends of the scale. + +Resolution can be set to show days, months, or years as interval steps. + + +Major interval can be set to show a certain number of days, months, or years. + + +Minor interval can be set to show a certain number of days, months, or years. + + + diff --git a/helpcontent2/source/text/schart/01/05040202.xhp b/helpcontent2/source/text/schart/01/05040202.xhp new file mode 100644 index 000000000..5682bef57 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05040202.xhp @@ -0,0 +1,82 @@ + + + + + + + + +Positioning +/text/schart/01/05040202.xhp + + + + +
+positioning; axes +charts;positioning axes +X axes;positioning +Y axes;positioning +axes;interval marks + +Positioning +Controls the positioning of the axis. +
+
+ +
+Axis line + +Select where to cross the other axis: at start, at end, at a specified value, or at a category. +value selected +Enter the value where the axis line should cross the other axis. +category selected +Select the category where the axis line should cross the other axis. +Position Axis +On tick marks +Specifies that the axis is positioned on the first/last tickmarks. This makes the data points visual representation begin/end at the value axis. + +Between tick marks +Specifies that the axis is positioned between the tickmarks. This makes the data points visual representation begin/end at a distance from the value axis. +Labels + +Place labels +Select where to place the labels: near axis, near axis (other side), outside start, or outside end. +Interval marks +Major: +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. + +Inner +Specifies that marks are placed on the inner side of the axis. + +Outer +Specifies that marks are placed on the outer side of the axis. +Minor: +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. + +Inner +Specifies that minor interval marks are placed on the inner side of the axis. + +Outer +Specifies that minor interval marks are placed on the outer side of the axis. + +Place marks +Select where to place the marks: at labels, at axis, or at axis and labels. + + diff --git a/helpcontent2/source/text/schart/01/05050000.xhp b/helpcontent2/source/text/schart/01/05050000.xhp new file mode 100644 index 000000000..a97d6bbab --- /dev/null +++ b/helpcontent2/source/text/schart/01/05050000.xhp @@ -0,0 +1,56 @@ + + + + + + + + +Grid +/text/schart/01/05050000.xhp + + +Sun Microsystems, Inc. + + + + + + grids; formatting axesaxes; formatting gridsGrid + Opens a submenu, where you select the grid you want to format. +
+ +
+ X Axis Major Grid + + Y Axis Major Grid + + Z Axis Major Grid + + X Axis Minor Grid + + Y Axis Minor Grid + + Z Axis minor Grid + + All Axis Grids + + + + diff --git a/helpcontent2/source/text/schart/01/05050100.xhp b/helpcontent2/source/text/schart/01/05050100.xhp new file mode 100644 index 000000000..131f6ac04 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05050100.xhp @@ -0,0 +1,53 @@ + + + + + + + + +Grid +/text/schart/01/05050100.xhp + + +Sun Microsystems, Inc. + + + +X axes;grid formatting +Y axes;grid formatting +Z axes; grid formatting + + + + + + + + +Grid +Opens the Grid dialog for defining grid properties. + +
+ +
+ + + + diff --git a/helpcontent2/source/text/schart/01/05060000.xhp b/helpcontent2/source/text/schart/01/05060000.xhp new file mode 100644 index 000000000..7919761e7 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05060000.xhp @@ -0,0 +1,45 @@ + + + + + + + + +Chart Wall +/text/schart/01/05060000.xhp + + +Sun Microsystems, Inc. + + + + + + charts; formatting wallsformatting;chart wallsChart Wall + Opens the Chart Wall 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. +
+ +
+ + + + + + diff --git a/helpcontent2/source/text/schart/01/05070000.xhp b/helpcontent2/source/text/schart/01/05070000.xhp new file mode 100644 index 000000000..5d4f94340 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05070000.xhp @@ -0,0 +1,48 @@ + + + + + + + + +Chart Floor +/text/schart/01/05070000.xhp + + +Sun Microsystems, Inc. + + + +charts; formatting floors +formatting; chart floors + + +Chart Floor +Opens the Chart Floor 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. + +
+ +
+ + + + + + diff --git a/helpcontent2/source/text/schart/01/05080000.xhp b/helpcontent2/source/text/schart/01/05080000.xhp new file mode 100644 index 000000000..dc3d3fec9 --- /dev/null +++ b/helpcontent2/source/text/schart/01/05080000.xhp @@ -0,0 +1,45 @@ + + + + + + + + +Chart Area +/text/schart/01/05080000.xhp + + +Sun Microsystems, Inc. + + + + + + charts; formatting areasformatting; chart areasChart Area + Opens the Chart Area dialog, where you can modify the properties of the chart area. The chart area is the background behind all elements of the chart. +
+ +
+ + + + + + diff --git a/helpcontent2/source/text/schart/01/05120000.xhp b/helpcontent2/source/text/schart/01/05120000.xhp new file mode 100644 index 000000000..cd8f277ec --- /dev/null +++ b/helpcontent2/source/text/schart/01/05120000.xhp @@ -0,0 +1,47 @@ + + + + + + + + +Arrangement +/text/schart/01/05120000.xhp + + +Sun Microsystems, Inc. + + + +
+Arrangement +Allows you to modify the order of the data series already set in the chart. +
+The position of the data in the data table remains unchanged. You can only choose the commands after inserting a chart in $[officename] Calc. +
+ +
+This function is only available if you have data displayed in columns. It is not possible to switch to data display in rows. +Bring Forward +Brings the selected data series forward (to the right). +Send Backward +Sends the selected data series backward (to the left). + + diff --git a/helpcontent2/source/text/schart/01/choose_chart_type.xhp b/helpcontent2/source/text/schart/01/choose_chart_type.xhp new file mode 100644 index 000000000..8833dff6f --- /dev/null +++ b/helpcontent2/source/text/schart/01/choose_chart_type.xhp @@ -0,0 +1,142 @@ + + + + + + + + + Choosing a Chart Type + /text/schart/01/choose_chart_type.xhp + + + + Choosing a Chart Type + + On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ The available chart types + Choose from the following chart types, depending on data type and intended presentation effect. + + + + +Icon + and +Icon + + + + Column or Bar + + + + + +Icon + + + + Pie + + + + + +Icon + + + + Area + + + + + +Icon + + + + Line + + + + + +Icon + + + + XY (scatter) + + + + + +Icon + + + + Bubble + + + + + +Icon + + + + Net + + + + + +Icon + + + + Stock + + + + + +Icon + + + + Column and Line + + +
+ +   +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/smooth_line_properties.xhp b/helpcontent2/source/text/schart/01/smooth_line_properties.xhp new file mode 100644 index 000000000..05d04f126 --- /dev/null +++ b/helpcontent2/source/text/schart/01/smooth_line_properties.xhp @@ -0,0 +1,64 @@ + + + + + + + + +Smooth Line Properties +/text/schart/01/smooth_line_properties.xhp + + +Sun Microsystems, Inc. + + + + + +curves;properties in line charts/XY charts +properties;smooth lines in line charts/XY charts + +Smooth Line Properties +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.most possibly these curves are not Bezier curves. +
+ +
+ +To change line properties + + +Select Cubic Spline or B-Spline. +These are mathematical models that influence the display of the curves. The curves are created by joining together segments of polynomials. + + +Optionally set the resolution. A higher value leads to a smoother line. + + +For B-spline lines optionally set the degree of the polynomials. + + + +Apply a line curve model. + +Set the resolution. + +Set the degree of the polynomials. + + diff --git a/helpcontent2/source/text/schart/01/stepped_line_properties.xhp b/helpcontent2/source/text/schart/01/stepped_line_properties.xhp new file mode 100644 index 000000000..628cc61b9 --- /dev/null +++ b/helpcontent2/source/text/schart/01/stepped_line_properties.xhp @@ -0,0 +1,53 @@ + + + + + + + + +Smooth Line Properties +/text/schart/01/stepped_line_properties.xhp + + +Eric Seynaeve + + + + + +curves;properties in line charts/XY charts +properties;stepped lines in line charts/XY charts + +Stepped Line Properties +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. +
+ +
+Different step types + + +Start step icon +Start with horizontal line and step up vertically at the end. + + +End step icon +Start to step up vertically and end with horizontal line. + + +Center X icon +Start with horizontal line, step up vertically in the middle of the X values and end with horizontal line. + + +Center Y icon +Start to step up vertically to the middle of the Y values, draw a horizontal line and finish by stepping vertically to the end. + + + + diff --git a/helpcontent2/source/text/schart/01/three_d_view.xhp b/helpcontent2/source/text/schart/01/three_d_view.xhp new file mode 100644 index 000000000..2b303353e --- /dev/null +++ b/helpcontent2/source/text/schart/01/three_d_view.xhp @@ -0,0 +1,170 @@ + + + + + + + + + 3D View + /text/schart/01/three_d_view.xhp + + + + + + +3D charts + charts; 3D views + illumination; 3D charts + +mw made "3D charts;" a one level entry +3D View + + On the first page of the Chart Wizard or in the context menu of a chart you can choose a chart type. 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.must be AHID, see i80656 +
+ +
+ + The chart preview responds to the new settings that you enter in the dialog. + + + When you leave the dialog with OK, the settings are applied permanently. + + + When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog. + + + For a 3D chart you can choose Format - 3D View to set perspective, appearance and illumination. + Perspective + + + Enter the values for rotation of the chart on the three axes and for a perspective view. + + + Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles. + With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. + 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. + The rotations are applied in the order first x, then y, last z. + When shading is enabled and you rotate a chart, the lights are rotated as if they are fixed to the chart. + The rotation axes always relate to the page, not to the chart's axes. This is different from some other chart programs. + Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection. + 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. + Older versions of %PRODUCTNAME cannot display the percentage of perspective the same way as the current version.Right-angled axes + +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.X rotation + +Sets the rotation of the chart on the x axis. The preview responds to the new settings.Y rotation + +Sets the rotation of the chart on the y axis. The preview responds to the new settings.z rotation + +Sets the rotation of the chart on the z axis. The preview responds to the new settings.perspective + + +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. + Appearance + + + Select a scheme from the list box. + + + By selecting a scheme, the check boxes and the light sources are set accordingly. + + + 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. + + + Mark Shading to use the Gouraud method for rendering the surface, otherwise a flat method is used. + The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible. + The Gouraud method applies gradients for a smoother, more realistic look.Regina: Need an external article on web, which describes the 3D engine in detail. Till that, the user should get some information on Gouraud and Flat. + + + + + Mark Object Borders to draw lines along the edges. + + + Mark Rounded Edges to smooth the edges of box shapes. + + Scheme + +Select a scheme from the list box, or click any of the check boxes below.Shading + +Applies Gouraud shading if marked, or flat shading if unmarked.Object borders + +Shows borders around the areas by setting the line style to Solid.Rounded Edges + +Edges are rounded by 5%. + + Illumination + Set the light sources for the 3D view. + + + Click any of the eight buttons to switch a directed light source on or off. + 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. + + + 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. + + + 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. + + + The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.Regina: Are you sure? I thought, that it only toggles the preview in the dialog. + + + Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions. + + preview right bar + + +Drag the right slider to set the vertical height and direction of the selected light source.preview bottom bar + + +Drag the bottom slider to set the horizontal position and direction of the selected light source.preview right bottom button + + +Click to switch between an illumination model of a sphere or a cube.Light source + +Click to enable or disable the specular light source with highlights. + + + + + + + +Click to enable or disable the uniform light source. + +Select a color for the selected light source. + +Select a color using the color dialog.Ambient light + +Select a color for the ambient light. + +Select a color using the color dialog. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_area.xhp b/helpcontent2/source/text/schart/01/type_area.xhp new file mode 100644 index 000000000..8e5406572 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_area.xhp @@ -0,0 +1,54 @@ + + + + + + + + + + +Chart Type Area +/text/schart/01/type_area.xhp + + + +area charts +chart types;area + +Chart Type Area + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+Area +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. +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. +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. +Percent - this subtype plots values cumulatively stacked on each other and scaled as percentage of the category total. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_bubble.xhp b/helpcontent2/source/text/schart/01/type_bubble.xhp new file mode 100644 index 000000000..b4723ca34 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_bubble.xhp @@ -0,0 +1,50 @@ + + + + + + + + + Chart Type Bubble + /text/schart/01/type_bubble.xhp + + + +bubble charts + chart types;bubble + +Chart Type Bubble + + On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ Bubble + 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. + The data series dialog for a bubble chart has an entry to define the data range for the Bubble Sizes. +
+ + + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/type_column_bar.xhp b/helpcontent2/source/text/schart/01/type_column_bar.xhp new file mode 100644 index 000000000..c854e779a --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_column_bar.xhp @@ -0,0 +1,61 @@ + + + + + + + + +Chart Type Column and Bar +/text/schart/01/type_column_bar.xhp + + +Sun Microsystems, Inc. + + + +column charts +bar charts +chart types;column and bar +mw made one entry out of two "charts types;" +Chart Type Column and Bar + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+Column +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. +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. +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. +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. +You can enable a 3D view 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. +For 3D charts, you can select the shape of each data value from Box, Cylinder, Cone, and Pyramid. +Bar +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. +The subtypes are the same as for the Column type. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_column_line.xhp b/helpcontent2/source/text/schart/01/type_column_line.xhp new file mode 100644 index 000000000..d757b24eb --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_column_line.xhp @@ -0,0 +1,143 @@ + + + + + + + + + + +Chart Type Column and Line +/text/schart/01/type_column_line.xhp + + + +column and line charts +chart types;column and line +combination charts + +Chart Type Column and Line + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+Column and Line +A Column and Line chart is a combination of a Column chart with a Line chart. +Select one of the variants + + +Columns and Lines. The rectangles of the column data series are drawn side by side so that you can easily compare their values. + + +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. + + +You can insert a second y-axis with Insert - Axes after you finish the wizard. +To specify a data range +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 Data Series dialog. + + +Select the data range. + + +Click one of the options for data series in rows or in columns. + + +Check whether the data range has labels in the first row or in the first column or both. + + +Organizing data series +In the Data Series list box you see a list of all data series in the current chart. +The column data series are positioned at the top of the list, the line data series at the bottom of the list. + + +To organize the data series, select an entry in the list. + + +Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry. + + +Click Remove to remove the selected entry from the Data Series list. + + +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. + + +Editing data series + + +Click an entry in the list to view and edit the properties for that entry. +In the Data Ranges list box you see the role names and cell ranges of the data series components. + + +Click an entry, then edit the contents in the text box below. +The label next to the text box states the currently selected role. + + +Enter the range or click Select data range to minimize the dialog and select the range with the mouse. + + +The range for a data role, like Y-Values, must not include a label cell. +Editing categories or data labels + + +Enter or select a cell range that will be used as text for categories or data labels. + + +The values in the Categories range will be shown as labels on the x axis. +Inserting chart elements +Use the Chart Elements page of the Chart Wizard to insert any of the following elements: + + +Chart titles + + +Legend + + +Visible grid lines + + +For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements: + + +Secondary axes + + +Minor grids + + +Data labels + + +Statistics, for example mean values, y error bars and trend lines + + +To set different data labels for each data series, use the properties dialog of the data series. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_line.xhp b/helpcontent2/source/text/schart/01/type_line.xhp new file mode 100644 index 000000000..39737c240 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_line.xhp @@ -0,0 +1,58 @@ + + + + + + + + +Chart Type Line +/text/schart/01/type_line.xhp + + +Sun Microsystems, Inc. + + + +line charts +chart types;line + +Chart Type Line + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+Line +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. +Points only - this subtype plots only points. +Points and lines - this subtype plots points and connects points of the same data series by a line. +Lines only - this subtype plots only lines. +3D lines - this subtype connects points of the same data series by a 3D line. +Mark Stack series 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 Percent, the y values are scaled as percentage of the category total. +Choose the Line type from the dropdown to select how the points will be connected. You can choose either Straight lines, Smooth lines to draw curves through the points or Stepped lines to draw lines which step from point to point. Click Properties to change the properties for the smooth or stepped lines. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_net.xhp b/helpcontent2/source/text/schart/01/type_net.xhp new file mode 100644 index 000000000..ff5411e75 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_net.xhp @@ -0,0 +1,54 @@ + + + + + + + + +Chart Type Net +/text/schart/01/type_net.xhp + + +Sun Microsystems, Inc. + + + +net charts +chart types;net +radar charts, see net charts + +Chart Type Net + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+Net +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. +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. +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/type_pie.xhp b/helpcontent2/source/text/schart/01/type_pie.xhp new file mode 100644 index 000000000..16b652a45 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_pie.xhp @@ -0,0 +1,54 @@ + + + + + + + + + Chart Type Pie + /text/schart/01/type_pie.xhp + + + +donut charts + pie charts;types + chart types;pie/donut +mw made one index entry out of two "chart types;"mw made "pie charts" a two level entry +Chart Type Pie + + On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ Pie + 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. + 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. + 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. + 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. + 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. +
+ + + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/type_stock.xhp b/helpcontent2/source/text/schart/01/type_stock.xhp new file mode 100644 index 000000000..760955498 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_stock.xhp @@ -0,0 +1,266 @@ + + + + + + + Chart Type Stock + /text/schart/01/type_stock.xhp + + + +stock charts + chart types;stock + data sources;setting for stock charts +mw added one entry +Chart Type Stock + + On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ Stock + 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.UFI: should we show example charts for every type? + For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below. + + + + + + A + + + B + + + C + + + D + + + E + + + F + + + + + 1 + + + + + Transaction volume + + + Opening price + + + Low (bottom price) + + + High (top price) + + + Closing price + + + + + 2 + + + Monday + + + 2500 + + + 20 + + + 15 + + + 25 + + + 17 + + + + + 3 + + + Tuesday + + + 3500 + + + 32 + + + 22 + + + 37 + + + 30 + + + + + 4 + + + Wednesday + + + 1000 + + + 15 + + + 15 + + + 17 + + + 17 + + + + + 5 + + + Thursday + + + 2200 + + + 40 + + + 30 + + + 47 + + + 35 + + + + + 6 + + + Friday + + + 4600 + + + 27 + + + 20 + + + 32 + + + 31 + + +
+ + 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. + Depending on the chosen variant, you do not need all columns. + Stock Chart Variants + Choose the Stock chart type on the first page of the Chart Wizard. Then select one of the four variants. + Type 1 + Based on low and high column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line. + Based on low, high, and close column Type 1 shows an additional horizontal mark for the closing price. + Type 2 + Based on open, low, high, and close 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. + Type 3 + Based on volume, low, high, and close column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.i80596 + Type 4 + Based on all five data columns volume, open, low, high, and close, Type 4 combines a chart of Type 2 with a column chart for the transaction volume. + 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. + Setting the Data Source + Charts based on its own data + To change the data series of a chart having its own data, choose Chart Data Table from the View menu or from the context menu of the chart in edit mode. + In an embedded chart data table, the data series are always organized in columns. + 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. + 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.Watch issue 72433 to see whether a change in the handling is done. + Do not write the name of a data series in a row. Write the name into the field above the role name. + The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order. + Charts based on Calc or Writer tables + You can choose or alter a data range on the second page of the Chart Wizard or in the Data Range dialog. For fine tuning use the Data Series dialog. + To specify a data range do one of the following: + + + Enter the data range in the text box. + 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". + As long as the syntax is not correct, %PRODUCTNAME shows the text in red. + + + + + In Calc, click Select data range to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click Select data range 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. + + + Click one of the options for data series in rows or in columns. + Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken. + Fine Tuning the Data Ranges of Table Based Stock Charts + 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. + Organize Data Series + In the data series 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. + 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. + To remove a data series, select the data series in the list and click Remove. + To add a data series, select one of the existing data series and click Add. 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 Data Range dialog.Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue. + Setting Data Ranges + In the Data Ranges dialog you can set or change the data range of each component of the selected data series. + 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.deleted a para, see i80596 +Enter the range into the text box or click on Select data range to minimize the dialog and select the range with the mouse. + 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. + Legend + The legend displays the labels from the first row or column or from the special 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.deleted 3 paras +The legend shows the value from the range, which you entered in the Range for Name field in the Data Range dialog. The default entry is the column header of the closing price column. + Select one of the position options. When the chart is finished, you can specify other positions using the Format menu. +
+ + + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/type_xy.xhp b/helpcontent2/source/text/schart/01/type_xy.xhp new file mode 100644 index 000000000..d720adb35 --- /dev/null +++ b/helpcontent2/source/text/schart/01/type_xy.xhp @@ -0,0 +1,117 @@ + + + + + + + + +Chart Type XY +/text/schart/01/type_xy.xhp + + + +scatter charts +XY charts +chart types;XY (scatter) +error indicators in charts +error bars in charts +averages in charts +statistics in charts +variances in charts +standard deviation in charts +mw changed xy to XY (2x) +Chart Type XY (Scatter) + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+XY (Scatter) +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. +Choose an XY chart for the following example tasks: + + +scale the x‑axis + + +generate a parameter curve, for example a spiral + + +draw the graph of a function + + +explore the statistical association of quantitative variables + + +Your XY chart may have more than one data series. +XY Chart Variants +You can choose an XY chart variant on the first page of the Chart Wizard, or by choosing Format - Chart Type for a chart in edit mode. +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 Line tab page of the data series properties dialog. +Double-click any data point to open the Data Series dialog. In this dialog, you can change many properties of the data series. +For 2D charts, you can choose Insert - Y Error Bars to enable the display of error bars. +You can enable the display of mean value lines and trend lines using commands on the Insert menu. +Points only +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 %PRODUCTNAME - PreferencesTools - Options - Charts - Default Colors. +Lines Only +This variant draws straight lines from one data point to the next. The data points are not shown by icons. +The drawing order is the same as the order in the data series. Mark Sort by X Values 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. +Points and Lines +This variant shows points and lines at the same time. +3D Lines +The lines are shown like tapes. The data points are not shown by icons. In the finished chart choose 3D View to set properties like illumination and angle of view. +Smooth Lines +Choose Smooth from the Line type dropdown to draw curves instead of straight line segments.i80587 +Click Properties to set details for the curves. + +Cubic Spline interpolates your data points with polynomials of degree 3. The transitions between the polynomial pieces are smooth, having the same slope and curvature. +The Resolution 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. + +B-Spline uses a parametric, interpolating B-spline curve. Those curves are built piecewise from polynomials. The Degree of polynomials sets the degree of these polynomials. +Stepped Lines +Choose Stepped from the Line type dropdown to draw lines which step from point to point instead of straight line segments. +Click Properties to set details for the curves. +There are 4 different step types: + + +Start step icon +Start with horizontal line and step up vertically at the end. + + +End step icon +Start to step up vertically and end with horizontal line. + + +Center X icon +Start with horizontal line, step up vertically in the middle of the X values and end with horizontal line. + + +Center Y icon +Start to step up vertically to the middle of the Y values, draw a horizontal line and finish by stepping vertically to the end. + + +
+ + + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/wiz_chart_elements.xhp b/helpcontent2/source/text/schart/01/wiz_chart_elements.xhp new file mode 100644 index 000000000..d9588db8c --- /dev/null +++ b/helpcontent2/source/text/schart/01/wiz_chart_elements.xhp @@ -0,0 +1,104 @@ + + + + + + + + + Chart Wizard - Chart Elements + /text/schart/01/wiz_chart_elements.xhp + + + + Chart Wizard - Chart Elements + + On this page of the Chart Wizard you can choose the chart elements to be shown. +
+ +
+titles title +Enter a title for your chart. +subtitle +Enter a subtitle for your chart. +x axis +Enter a label for the x-axis (horizontal). +y axisx axis +Enter a label for the y-axis (vertical). +z axis +Enter a label for the z-axis. This option is only available for three-dimensional charts. +legend +Displays a legend in your chart. +legend left +Positions the legend to the left of the chart. +top +Positions the legend to the top of the chart. +right +Positions the legend to the right of the chart. +bottom +Positions the legend to the bottom of the chart. +grid x axis +Displays grid lines that are perpendicular to the x-axis. +y axis +Displays grid lines that are perpendicular to the y-axis. +z axis +Displays grid lines that are perpendicular to the z-axis. This option is only available for three-dimensional charts. +secondary x axis ("2nd x axis" in spec doc) +Enter a label for the secondary x-axis. This option is only available for charts that support a secondary x-axis. +secondary y axis ("2nd y axis" in spec doc) +Enter a label for the secondary y-axis. This option is only available for charts that support a secondary y-axis. + + To enter chart elements + Enter titles or click the elements that you want to be shown on the current chart. + Titles + 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. + It is not possible to link the title text to a cell. You must enter the text directly.Regina: See wishlist and issues 8099, 64825 + When the chart is finished, you can change the position and other properties by the Format menu. + Legend + 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. + You cannot enter the text directly, it is automatically generated from the Name cell range. + Select one of the position options. When the chart is finished, you can specify other positions using the Format menu. + Grids + The visible grid lines can help to estimate the data values in the chart. + The distance of the grid lines corresponds to the interval settings in the Scale tab of the axis properties. + Grid lines are not available for pie charts. + Additional elements + For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements: + + + Secondary axes + + + Minor grids + + + Data labels + + + Statistics, for example mean values, y error bars and trend lines + + +
+ + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/wiz_chart_type.xhp b/helpcontent2/source/text/schart/01/wiz_chart_type.xhp new file mode 100644 index 000000000..b7b55adf7 --- /dev/null +++ b/helpcontent2/source/text/schart/01/wiz_chart_type.xhp @@ -0,0 +1,94 @@ + + + + + + + + +Chart Wizard - Chart Type +/text/schart/01/wiz_chart_type.xhp + + +Sun Microsystems, Inc. + + + +charts;choosing chart types + + + +Chart Wizard - Chart Type + +On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ +To choose a chart type + + +Choose a basic chart type: click any of the entries labeled Column, Bar, Pie, and so on. +The contents on the right side will change to offer more options depending on the basic chart type. + + +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. + + +Press Shift+F1 and point to a control to see an extended help text. +Click Finish on any wizard page to close the wizard and create the chart using the current settings. +Click Next to see the next wizard page, or click the entries on the left side of the wizard to go to that page. +Click Back to see the previous wizard page. +Click Cancel to close the wizard without creating a chart.63365 roadmap + +Click to go to the named wizard page.63293 basic chart types + +Select a basic chart type.63294 options + +Select a sub type of the basic chart type.551781378 3D look checkbox + +Enables a 3D look for the data values.551783937 3D dropdown + +Select the type of 3D look.63325 bar column shape listbox + +Select a shape from the list.551781379 stack series (for Line) + +Displays stacked series for Line charts.551780866 stack series on top + +Stack series display values on top of each other.551780867 stack series percent + +Stack series display values as percent.551781380 smooth lines + +Choose the type of line to draw.551784961 properties + +Opens a dialog to set the line or curve properties.551781381 sort by x values (for XY (scatter)) + +Connects points by ascending X values, even if the order of values is different, in an XY scatter diagram.63323 number of lines (Column + line) + +Set the number of lines for the Column and Line chart type.Toolbar icon Chart Type + +Opens the Chart Type dialog. +
+ + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/wiz_data_range.xhp b/helpcontent2/source/text/schart/01/wiz_data_range.xhp new file mode 100644 index 000000000..70e0b86c2 --- /dev/null +++ b/helpcontent2/source/text/schart/01/wiz_data_range.xhp @@ -0,0 +1,79 @@ + + + + + + + + + Chart Wizard - Data Range + /text/schart/01/wiz_data_range.xhp + + + + +data ranges in charts +mw added one entry +Chart Wizard - Data Range + + On this page of the Chart Wizard you can select one single source of data range. This range may consist of more than one rectangular range of cells.context menu Data Ranges + +Opens the Data Ranges dialog where you can edit Data Range and Data Series. + Use the Chart Wizard - Data Series page if you need more control over the data ranges. +
+ +
+ This dialog is only available for charts based on a Calc or Writer table. + + To specify a data range + + + Select the data range. Do one of the following: + Enter the data range in the text box. + 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". + In Calc, click Select data range to minimize the dialog, then drag over a cell area to select the data range.Hold down the Ctrl key and drag to select multiple ranges. --- see issue 71894 + 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. + + + Click one of the options for data series in rows or in columns. + + + Check whether the data range has labels in the first row or in the first column or both. + + + In the preview you can see how the final chart will look.data range text box & shrinky + + +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 Select data range button.data series in rows + +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.data series in columns + +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.first row as label + +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.first column as label + +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. +
+ + + + +
+ + diff --git a/helpcontent2/source/text/schart/01/wiz_data_series.xhp b/helpcontent2/source/text/schart/01/wiz_data_series.xhp new file mode 100644 index 000000000..6f64b0787 --- /dev/null +++ b/helpcontent2/source/text/schart/01/wiz_data_series.xhp @@ -0,0 +1,102 @@ + + + + + + + + + + +Chart Wizard - Data Series +/text/schart/01/wiz_data_series.xhp + + + + +order of chart data +data series + +Chart Wizard - Data Series + +On this page of the Chart Wizard 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. +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. +
+ +
+This dialog is only available for charts based on a Calc or Writer table. + +Organizing data series +In the Data Series list box you see a list of all data series in the current chart. + + +To organize the data series, select an entry in the list. + + +Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry. + + +Click Remove to remove the selected entry from the Data Series list. + + +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. + + +Editing data series + + +Click an entry in the list to view and edit the properties for that entry. +In the Data Ranges list box you see the role names and cell ranges of the data series components. + + +Click an entry, then edit the contents in the text box below. +The label next to the text box states the currently selected role. + + +Enter the range or click Select data range to minimize the dialog and select the range with the mouse. +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. + + +The range for a data role, like Y-Values, must not include a label cell. +Editing categories or data labels + + +Enter or select a cell range that will be used as text for categories or data labels. UFI: red text means what? + + + +Depending on the chart type, the texts are shown on the X axis or as data labels. Regina: If you enter a range here, the check box "First column as label" (assumed data series in columns) on the Data Range page of the dialog is marked automatically and if you erase the entry in the input field, it is unchecked automatically.data series list box +Shows a list of all data series in the chart. Click an entry to view and edit that data series. Click Add to insert a new series into the list after the selected entry.data ranges list box +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.range for ... & shrinky + +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 Select data range button.categories & shrinky + +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 Select data range button.add button +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.Remove button +Removes the selected entry from the Data Series list.^ up button +Moves up the selected entry in the Data Series list.v down button +Moves down the selected entry in the Data Series list. +
+ + + + +
+ + -- cgit v1.2.3